SQL 7 CPU Spin 
Author Message
 SQL 7 CPU Spin
What's the best way to determine what is causing SQL 7 SPU spin?

Joe Cormane



Tue, 27 Sep 2005 16:09:29 GMT
 SQL 7 CPU Spin

Profiler will allow you to see the sql statements as they are submitted to the database.
You can also
exec sp_who
or
exec sp_who2
within Query Analyzer to see how many connections there are

--
Keith, SQL Server MVP

Quote:

> What's the best way to determine what is causing SQL 7 SPU spin?

> Joe Cormane



Tue, 27 Sep 2005 16:15:16 GMT
 SQL 7 CPU Spin
I apologize for not providing enough information initially.    It's a SQL
7.0 SP4 installation that accepts almost no user connections at all.  It
only runs batch processes for keeping data in sync between an AS/400 and
another SQL 7.0 SP4 server.

When I've run the sp_who and sp_who2 on the system through query analyzer in
the past, I haven't seen anything that would lead me to think it was eating
up all of the CPU.  In fact it looks remarkably low on load.

I get kind of lost when running profiler because I'm somewhat new to SQL
server and don't really know what to look for when I'm creating the trace.

Thanks so much for your assistance.

Joe



Profiler will allow you to see the sql statements as they are submitted to
the database.
You can also
exec sp_who
or
exec sp_who2
within Query Analyzer to see how many connections there are

--
Keith, SQL Server MVP


Quote:
> What's the best way to determine what is causing SQL 7 SPU spin?

> Joe Cormane



Tue, 27 Sep 2005 19:37:35 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. CPU Spin on dual Xeon CPU's.

2. SQL 2000 Compatability Level / 100% CPU Spin

3. SQL Server 2000 CPU spin in opposite directions

4. SQL Server 7.0 : CPU spin caused by simple LIKE operation

5. Cascade Lock Up - CPU Spin

6. Postgres 7.2.1 Really Spinning the CPU

7. ora_s000 spinning, maxing out cpu%

8. SQL 6.5 Sp5a and a SQL Spin which hits 95% CPU and no incoming connections?

9. SQL 6.5 Sp5a and a SQL Spin which hits 95% CPU and no incoming connections?

10. SQL 7 - Date Calculation Spin disables SQLAgent job

11. SQL Server2000 spins hard drive

12. SQL Server is spinning my harddisk too much...


 
Powered by phpBB® Forum Software