SQL Server process 100% CPU

Thats not a heck of a lot to go on as it could be lots of things. Maybe
these will help you to narrow down the issue:


<a style='text-decoration: underline;' href="http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp" target="_blank">http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp</a>
Performance WP's
<a style='text-decoration: underline;' href="http://www.swynk.com/friends/vandenberg/perfmonitor.asp" target="_blank">http://www.swynk.com/friends/vandenberg/perfmonitor.asp</a> Perfmon counters
<a style='text-decoration: underline;' href="http://www.sql-server-performance.com/sql_server_performance_audit.asp" target="_blank">http://www.sql-server-performance.com/sql_server_performance_audit.asp</a>
Hardware Performance CheckList
<a style='text-decoration: underline;' href="http://www.sql-server-performance.com/best_sql_server_performance_tips.asp" target="_blank">http://www.sql-server-performance.com/best_sql_server_performance_tips.asp</a>
SQL 2000 Performance tuning tips
<a style='text-decoration: underline;' href="http://www.support.microsoft.com/?id=q224587" target="_blank">http://www.support.microsoft.com/?id=q224587</a> Troubleshooting App
Performance
<a style='text-decoration: underline;' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp" target="_blank">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/admin.../ad_per</a>
Disk Monitoring


--
Andrew J. Kelly SQL MVP


"paulfdgs" <paulfdgs DeleteThis @discussions.microsoft.com> wrote in message
news:62E9B1A6-8289-444F-88EF-B27FF16F53D6@microsoft.com...
 > When under heavy load, sqlsevr.exe is maxing out. It's running on a NT box
 > and has 2 other boxes writing to it. Then, after it's maxed, we get ADO
 > time-out errors. Any ideas? Any help is appreciated greatly.<!-- ~MESSAGE_AFTER~ -->