Error in Event Viewer

Question

Post reply

Error in Event Viewer

ravisamigo

SSCertifiable

Points: 7440
More actions
November 29, 2010 at 10:33 pm

#146386

Dear All,
Can some one help me out from this issue.
I can see more errors like this in the event viewer.
ERROR:
-------
Message 29/11/2010 10:10:55 AM Error: 18056, Severity: 20, State: 27.
The client was unable to reuse a session with SPID 1370, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
Thanks and Regards,
Ravichandra.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

See if this is of use for your situation.

http://support.microsoft.com/kb/937745

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ravisamigo SSCertifiable Points: 7440 More actions · Answer 2

Thanks Jason.

Even I got the same solution from Google;but,I want to know what is the cause behind this issue.

Please advise.

Regards,

Ravichandra.

ravisamigo SSCertifiable Points: 7440 More actions · Answer 3

Dear All,

Please advise on the below errors.

Your quick response is much appreciated.

ERROR:1

-----------------

2010-11-29 10:10:55.08 Logon Login failed for user 'xxxxxx'. [CLIENT: 192.168.30.180]

2010-11-29 10:10:55.08 spid1370 Error: 18056, Severity: 20, State: 27.

2010-11-29 10:10:55.08 spid1370 The client was unable to reuse a session with SPID 1370, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

ERROR:2

-----------------

2010-11-29 10:05:44 - ! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)

2010-11-29 18:08:29 - ! [298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]

2010-11-29 18:08:29 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

2010-11-29 18:08:29 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]

Thanks and Regards,

Ravichandra.

ravisamigo SSCertifiable Points: 7440 More actions · Answer 4

Can someone help me out on this please

Thanks and Regards,

Ravichandra.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

This problem occurs because memory allocation contention causes a slowdown on the login process or the query execution process.

It is resolved by applying the hotfix.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ravisamigo SSCertifiable Points: 7440 More actions · Answer 6

Thanks Jason,

But I can see hotfix is for SP2 in "http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=937745&kbln=en-us"

Our environment

------------------

SQLServer2005 -- Standard Edition X86 platform

select serverproperty('productlevel') ---> SP3

select serverproperty('productversion') --->9.00.4053.00

Please advise.

Thanks and Regards,

Ravichandra

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

How much memory do you have?

How many concurrent connections do you have?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ravisamigo SSCertifiable Points: 7440 More actions · Answer 8

Dear Jason,

Please find the information.

Maximum number of councurrent connections -- > 0 [ server properites]

Memory -->32 GB

Minimum Server memory --> 10240 MB

Maximum Server memory --> 30720 MB

Thanks and Regards,

Ravichandra.

ravisamigo SSCertifiable Points: 7440 More actions · Answer 9

Can someone advise me on this.

Your quick response is much appreciated.

Thanks and Regards,

Ravichandra.

ravisamigo SSCertifiable Points: 7440 More actions · Answer 10

Dear All,

Can someone please help me out.

For your information:

-------------------------

CPU Usage -- 100 % and Physical memory -- 89% and Nework utilization -- 0.06%.

O/s -- ->Microsoft(R) Windows(R) Server 2008, Enterprise without Hyper-V

SQL Server edition---> Microsoft SQL Server2005 Standard Edition

The no of processors on the server---> 8 Processors [Intel(R) Xeon(R) CPU E5405 @ 2.00GHz,1995 Mhz,4 core(s),4 logical Processor(s),Intel(R) Xeon(R) CPU E5405 @ 2.00GHz,1995 Mhz,4 core(s),4 logical Processor(s)]

AWE enabled , Min Server memory 10240 MB and Max Server memory 30720 MB

Max Degree of Parallelism ---> 0

Max worker threads --- > 0

NOTE : Tlog backups were failing at certain time( ERROR No: 12291).

Your prompt reply is much appreciated.

Thanks and Regards,

Ravichandra.

ravisamigo SSCertifiable Points: 7440 More actions · Answer 11

Dear All,

Can some one help me out please

Please find the some more information.

-------------------------------------------------------

CPU Usage -- 100 % and Physical memory -- 89% and Nework utilization -- 0.06%.

OS -> Microsoft(R) Windows(R) Server 2008, Enterprise without Hyper-V

SQL Server edition---> Microsoft SQL Server2005 Standard Edition

No of processors on the server---> 8 Processors [Intel(R) Xeon(R) CPU E5405 @ 2.00GHz,1995 Mhz,4 core(s),4 logical Processor(s),Intel(R) Xeon(R) CPU E5405 @ 2.00GHz,1995 Mhz,4 core(s),4 logical Processor(s)]

Min memory and Max memory settings- AWE enabled , Min Server memory 10240 MB and Max Server memory 30720 MB

Max Degree of Parallelism - 0

Max worker threads --- > 0

Note: Tlog backups were failing at certain time( ERROR No: 12291).

Your prompt reply is much appreciated.

Thanks and Regards,

Ravichandra.