Error: 16955, Severity: 16, State: 2

When I used sql profiler to trace exception error of my sql server, I got a
bunch of error 16945,16955 and 208, I wonder if anyone knows how could I
locate where the error raised?
Thanks.Check if the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;302477 applies to
your case.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"davidw" <wyx1999@.hotmail.com> wrote in message
news:OA#1t6xVDHA.2100@.TK2MSFTNGP11.phx.gbl...
> When I used sql profiler to trace exception error of my sql server, I got
a
> bunch of error 16945,16955 and 208, I wonder if anyone knows how could I
> locate where the error raised?
> Thanks.
>

Error: 16954, Severity: 10, State: 1 and Timeout problem

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 - MatikMatik (marzec@.sauron.xo.pl) writes:
> 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

The text for this message is "Executing SQL directly; no cursor."

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

You could try my aba_lockinfo. This stored procedure gives you a
snapshot of what is going on. Which processes that are active,
which are blocking and which are block. You get what they lock,
what they are waiting for, and their current statement. You find it on
http://www.sommarskog.se/sqlutil/aba_lockinfo.html.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thank's Erland!

Matik

Erland Sommarskog napisal(a):
> Matik (marzec@.sauron.xo.pl) writes:
> > 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
> The text for this message is "Executing SQL directly; no cursor."
> > Help me, how to diagnose the problem. How can I trace, which processes
> > are blocking eachother.
> You could try my aba_lockinfo. This stored procedure gives you a
> snapshot of what is going on. Which processes that are active,
> which are blocking and which are block. You get what they lock,
> what they are waiting for, and their current statement. You find it on
> http://www.sommarskog.se/sqlutil/aba_lockinfo.html.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx

Error: 16954, Severity: 10, State: 1

Hi there.
I ran a trace over our SQL server and picked this error up.
Does anyone have any idea what could be causing this ?
Error: 16954, Severity: 10, State: 1
Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
Any help would be greatly appreciated.
Thanks
AndyHi
This error is connected with the use or no use of cursors.
The message indicated that a server side cursor was requested
(sp_cursoropen) but no cursor was necessary, as the SQL statement was
executed directly.
The error message can be informational.
Do you get timeout or disconnection after this error or any specific issue
on the Server Side?
HTH
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Andy Hayes" <andyh@.friday-ad.co.uk> wrote in message
news:OjUrMY8bEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> I ran a trace over our SQL server and picked this error up.
> Does anyone have any idea what could be causing this ?
> Error: 16954, Severity: 10, State: 1
> Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
> Any help would be greatly appreciated.
> Thanks
> Andy
>

Error: 16954, Severity: 10, State: 1

Hi there.
I ran a trace over our SQL server and picked this error up.
Does anyone have any idea what could be causing this ?
Error: 16954, Severity: 10, State: 1
Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
Any help would be greatly appreciated.
Thanks
AndyHi
This error is connected with the use or no use of cursors.
The message indicated that a server side cursor was requested
(sp_cursoropen) but no cursor was necessary, as the SQL statement was
executed directly.
The error message can be informational.
Do you get timeout or disconnection after this error or any specific issue
on the Server Side?
HTH
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Andy Hayes" <andyh@.friday-ad.co.uk> wrote in message
news:OjUrMY8bEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> I ran a trace over our SQL server and picked this error up.
> Does anyone have any idea what could be causing this ?
> Error: 16954, Severity: 10, State: 1
> Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
> Any help would be greatly appreciated.
> Thanks
> Andy
>

Error: 16954, Severity: 10, State: 1

Hi there.
I ran a trace over our SQL server and picked this error up.
Does anyone have any idea what could be causing this ?
Error: 16954, Severity: 10, State: 1
Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
Any help would be greatly appreciated.
Thanks
Andy
Hi
This error is connected with the use or no use of cursors.
The message indicated that a server side cursor was requested
(sp_cursoropen) but no cursor was necessary, as the SQL statement was
executed directly.
The error message can be informational.
Do you get timeout or disconnection after this error or any specific issue
on the Server Side?
HTH
Regards
Sadeesh
This posting is provided AS IS with no warranties, and confers no rights.
"Andy Hayes" <andyh@.friday-ad.co.uk> wrote in message
news:OjUrMY8bEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> I ran a trace over our SQL server and picked this error up.
> Does anyone have any idea what could be causing this ?
> Error: 16954, Severity: 10, State: 1
> Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
> Any help would be greatly appreciated.
> Thanks
> Andy
>