semangat….

buat semua yang kau cintai………….

Error: 18056, Severity: 20, State: 29

Kemarin saya mendapati error log pada mesin SQL server saya

Error: 18056, Severity: 20, State: 29.

The client was unable to reuse a session with SPID 56, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

Apa ini yah??

dari link ini saya dapati http://support.microsoft.com/kb/937745

When this problem occurs, you may also experience the following symptoms:
High CPU usage occurs.
The Microsoft Windows operating system frequently performs context switches.
This problem occurs when SQL Server handles many concurrent connections on a computer that has many processors installed. Additionally, a time-out may occur when you run a query.

tapi benarkah?

ternyata di Forum-forum banyak juga yang mengeluhkan hal ini.

Bahkan sebelumnya sebenarnya masalah ini sudah terjadi pada SQL 2005

Alhamdulillah microsoft mengeluarkan solusinya yakni :

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

FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2

setelah mengikuti petunjuknya saya dihadapkan pada error yang baru yakni

Error: 9954, Severity: 16, State: 1.

SQL Server failed to communicate with filter daemon launch service (Windows error: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. ). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.

sementara saya dapati solusi error baru ini dengan start service >> SQL Full-text Filter Daemon Launcher (Instance Name)

untuk sementara saya akn monitoring dulu apakah ada error sama atau tambahan error pula.

Knowloedge :

Apa sih SPID

A SPID in SQL Server is a Server Process ID. These process ID’s are essentially sessions in SQL Server. Everytime an application connects to SQL Server, a new connection (or SPID) is created. This connection has a defined scope and memory space and cannot interact with other SPIDs. The term SPID is synonymous with Connection, or Session.

Dimana kah dia SPID itu?

SELECT *
FROM sys.dm_exec_sessions

bacaan

http://sqlserverplanet.com/dba/spid-what-is-it
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d1dc80b9-dcaf-4376-af41-4d7afe6cd9b4/the-client-was-unable-to-reuse-a-session-with-spid-xx-which-had-been-reset-for-connection-pooling?forum=sqldatabaseengine
http://sqlserverplanet.com/dba/spid-what-is-it
http://sqlserverplanet.com/dba/using-sp_who2
http://www.sqlservercentral.com/Forums/Topic1319095-1550-1.aspx

https://www.google.com/search?q=Error%3A+18056%2C+Severity%3A+20%2C+State%3A+29.&oq=Error%3A+18056%2C+Severity%3A+20%2C+State%3A+29.&aqs=chrome..69i57j69i58.435j0j7&sourceid=chrome&espv=210&es_sm=93&ie=UTF-8
http://www.sqlservergeeks.com/forums/microsoft-data-platform/sql-server-bi/316/issue-in-sql-server-2008-r2-urgent/1
http://sqlserverperformance.wordpress.com/2011/11/26/hotfix-for-sql-server-20082008-r2-periodically-does-not-accept-connections-bug/
http://blogs.msdn.com/b/sqlsakthi/archive/2011/07/06/error-18056-state-29-the-client-was-unable-to-reuse-a-session-the-failure-id-is-29-after-upgrading-sql-2000-to-sql-2008-sp2.aspx
http://support.microsoft.com/kb/2543687
http://support.microsoft.com/kb/2715953
http://support.microsoft.com/kb/2629969
http://support.microsoft.com/kb/981356
http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx?wa=wsignin1.0
http://support.microsoft.com/kb/937745
http://support.microsoft.com/kb/2543687
http://diagmanager.codeplex.com/

January 9, 2014 - Posted by | SQL | , , ,

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: