The SQL table locking problem

I need specialist in SQL server, who will find the exact reason of server stacking and will get tips of possible way of problem resolution.

We have an application in MS Access and a number of small VB6 applications. All of them connected to MS SQL Server. An Ms Access program uses DAO 3.5 library. A VB6 application uses ADO 2.7.

Until December of 2011 that was SQL server 2000. After December 2011 we migrate to SQL Server 2008.

From the 2005 I started work with this organization the server begin stack once or more every day. The reason was locking of some table (t_orders) that reaches about 300000 records (dead locks or something like this). I tried find the exact operation that cause the problem but didn’t succeed. The solution was delete each year the records from this table. So the table will have no more than 200000 – 250000 records.

The addition of VB6 modules increased the problem. So the number of records that we could hold in the table becomes less than 200000. And, finally, after migration to SQL 2008 the situation become even worst.

To treat the problem I need to know – what is the exact reason of stacking. Possible the problem can be treated by appropriate configuration of the server. If no, I need know the expressions, that cause the problem to be possible identify the sql expressions in the sources of application and change this expressions appropriately.

For now the SQL server locks once-twice a day.

I collected the logs of sql server monitoring and results of sp_lock, sp_who2, sp_who3, cspWhoCPU_expensive procedures.

Kemahiran: Microsoft Access, Memasang Skrip, SQL, Visual Basic, Destop Windows

Lihat lagi: sql server locking, problem locking sql table, what was the, problem problem, i.t. specialist, find the solution to, find the solution for, find the solution, what is ms sql, what is a stack, t-sql with, t-sql in, sql less than, ms access sql, table, t-sql;, SQL Access, Sql 2012, migration application, locks, ado, access to sql, access sql, sql server 2008 access, vb6 modules

Tentang Majikan:
( 91 ulasan ) Cairo, Egypt

ID Projek: #1524568

Dianugerahkan kepada:


Hello, Please check your PMB.

$80 USD dalam 5 hari
(2 Ulasan)

12 pekerja bebas membida secara purata $128 untuk pekerjaan ini


Please see PMB.

$250 USD dalam sehari
(16 Ulasan)

Ready to [url removed, login to view] more details to see if I can help you.

$120 USD dalam 2 hari
(40 Ulasan)

Greetings I have worked with SQL and VB for quite some time. Based on my experience and on your description of the problem, it seems this could be a nasty combination of problems: Missing Indexes, Badly formed Su Lagi

$150 USD dalam 14 hari
(3 Ulasan)

Check PMB please.

$250 USD dalam sehari
(0 Ulasan)

Good day. I can help you. I need to see your database and your applications. Can you give remote access to your applications and databases?

$50 USD dalam sehari
(0 Ulasan)

Hello. I have big exp VBA in excel DAO and ADO connection. Have portfolio, check PM

$100 USD dalam 3 hari
(0 Ulasan)

Please see my personal message.

$120 USD dalam 2 hari
(0 Ulasan)

I can solve the problem.

$100 USD dalam 15 hari
(0 Ulasan)

I'd be happy to assist in solving this dead-lock issue.

$150 USD dalam 2 hari
(0 Ulasan)

This is Fida student of Aptech Institute of IT Academy i will try to help you in this Problem.

$100 USD dalam 3 hari
(0 Ulasan)

I am an information technology professional with particular experience of project and account management, developing bespoke database applications in the Microsoft Windows OS, training users in both Windows and and sys Lagi

$70 USD dalam 3 hari
(0 Ulasan)