Help Debug Random SQL Server 2000 Reboots, Slow performance

Help Debug Random SQL Server 2000 Reboots, Slow performance

Post by dhruv.gau » Fri, 10 Mar 2006 02:19:52


We recently upgraded our SQL Server from 7.0 to 2000. We did not
upgrade or make changes to the server hardware. Lately the server
decides to reboot itself at random. The number of users or workload has
not changed since or before the upgrade. Before each reboot the
performance goes down drastically and then the reboot occurs. We also
experience sluggish performances at random. After sluggishness it
recovers or reboots. We have not gone a full week since the upgrade
without a reboot. We never had any such issues with SQL Server 7.0. I
have turned the minidump on and have tons of them available. I am
posting the last minidump here but if you guys wish to analyze I can
post more.

Any help is greatly appreciated.



Loading Dump File [D:\MiniDumps\Mini030306-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available

Symbol search path is: D:\Program Files\Debugging Tools for Windows
Executable search path is:
Unable to load image ntoskrnl.exe, Win32 error 2
*** WARNING: Unable to verify timestamp for ntoskrnl.exe
*** ERROR: Module load completed but symbols could not be loaded for
ntoskrnl.exe
Windows 2000 Kernel Version 2195 (Service Pack 4) MP (4 procs) Free x86
compatible
Kernel base = 0x80400000 PsLoadedModuleList = 0x80485b80
Debug session time: Fri Mar 3 10:37:09.640 2006 (GMT-7)
System Uptime: not available
Unable to load image ntoskrnl.exe, Win32 error 2
*** WARNING: Unable to verify timestamp for ntoskrnl.exe
*** ERROR: Module load completed but symbols could not be loaded for
ntoskrnl.exe
Loading Kernel Symbols
.............................................................................................
Loading User Symbols
Loading unloaded module list
...
The call to LoadLibrary(ext) failed, Win32 error 127
"The specified procedure could not be found."
Please check your de *** configuration and/or network access.
The call to LoadLibrary(ext) failed, Win32 error 127
"The specified procedure could not be found."
Please check your de *** configuration and/or network access.
*******************************************************************************
*
*
* Bugcheck Analysis
*
*
*
*******************************************************************************
Bugcheck code 000000D1
Arguments 0a86b374 00000002 00000000 f20c4be8

ChildEBP RetAddr Args to Child
WARNING: Stack unwind information not available. Following frames may
be wrong.
bd781788 00000000 0a86b374 00000002 00000000 nt+0x6b1ac



Thank you,

Drew
 
 
 

1. SQL Server 2000 linked tables - slow performance since server transition

2. SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000

Hi,



I have installed SQL2000 and SQL2005 on the same computer accessing the same
DB



When run the following simple queries the performance is as follows

Could some one please advice on how improve the performance on these queries
run on SQL2005

Are there any settings to be done in SQL2005 ?



SELECT Int_Key FROM fDocHst

Records 20422

SQL2000 - Uses an Index scan, reads 30, avg. dur 63

SQL2005 - Uses an Index scan, reads 30, avg. dur 406



SELECT Int_Key, DocumentNo, Sts, Rev, Title, Category, IntApprvd,
AvlDwgFmts, IntAdr, Type

FROM fDocHst

Records 20422



SQL2000 - Uses a Clustered Index scan, reads 2342, avg. dur 700

SQL2005 - Uses a Clustered Index scan, reads 2342, avg. dur 1261

3. Slow performance - SQL Server 2000

4. Slow performance of SQL Server 2000 against 6.5

5. Occasional Very Slow Performance.. with SQL Server 2000

6. Sql Server 2000 slow performance

7. Slow performance in SQL Server 2000

8. SQL Server 2005 Vs SQL Server 2000 Performance Comparison

9. Problema para actualizar SQL Server 6.5 a SQL Server 2000 en Windows 2000 Server

10. Problem upgrade sql server 6.5 to sql server 2000 enterprise edition on Windows 2000 Server

11. Performance Issues - Access 2000 Frontend SQL Server 2000 Backend

12. Performance difference between SQL 6.5 and SQL 2000 server

13. SQL Server 2000 on Windows 2003 server reboot?