FIX: DBCC SQLPERF(THREADS) Fails w/ AV on 6.0 SP 1

ID: Q138013

The information in this article applies to:
BUG# NT: 11497 (6.00)

SYMPTOMS

The command DBCC SQLPERF(THREADS) on SQL Server version 6.0 Service Pack 1 fails with the error:

DBCC function 'threads' in the library 'sqlper60' generated access
violation; SQL Server is terminating process <n>

The client connection that executed this command is terminated, but other client connections are unaffected. The client may see the access violation error listed above, or encounter DB-Library errors 10037, "Unexpected EOF from SQL Server," or 10008, "Bad Token from SQL Server: Datastream processing out of synchronization."

This problem does not exist in SQL Server 6.0 without Service Pack 1 applied.


WORKAROUND

Most of the information from SQLPERF(THREADS) can be found using a combination of other resources such as SQL Enterprise Manager (Current Activity), sp_who, examining the sysprocesses table, and Windows NT Performance Monitor.

For additional information about SQL Server Windows NT threads, please see the following article in the Microsoft Knowledge Base:

Q117559 : INF: How to Correlate Spid, Kpid, and Thread Instance


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0 Service Pack 1. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 windows nt SP1 sqlper60.dll 


Keywords          : kbprg SSrvProg SSrvTran_SQL kbbug6.00.sp1 kbfix6.00.sp2 
Version           : 6.0.sp1
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 20, 1999