Posted by Matik on 06/20/06 15:07

Hi to all,

I have a problem I can not trace.
Andgeneraly this is my problem probably.

I have a SQL Server 2000 SP3 with one database.
On this DB are runing lot of threads from different applications. So
the access is multiple.

The problem is, on one of the applications (C++ programmed) I get from
time to time, problem, that the calls in database are sometimes
performed very very long.

If usualy it takes like 50ms, sometimes it takes up to over one minute!

I can not trace, why the application need so long time, to perform this
statement.
I've checked the code, but it seams to be ok.
Probably, other aplication are locking resources, so the first one need
to wait so long.

Question is, how to find out, which one is locking the resources, or
maybe which resources for so long?

I was trying to analyze SQL Profiler, but the only error I found was
this one:

Error: 16954, Severity: 10, State: 1


Help me, how to diagnose the problem. How can I trace, which processes
are blocking eachother.

Any advise will be helpful..

Thanks - Matik

• Next in forum: Datatype-convertion in TSQL
• Prev in forum: SQLDMO - Getting 'Local' Server name
• Thread view: Error: 16954, Severity: 10, State: 1 and Timeout problem

[Reply to this message]