By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

sp_who2 displays funky CPU usage on pentium4 server

P: n/a
I've got a new server with Pentium4 xeon processors. I've used sp_who2
for quite a while on my old server -- to look at CPU and IO usage. On
the new server, the CPU times are huge -- although actual performance
is quite good. I know sp_who2 is an undocumented proc. Has anyone
experienced this or is it just me?

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
louis (lo************@gmail.com) writes:
I've got a new server with Pentium4 xeon processors. I've used sp_who2
for quite a while on my old server -- to look at CPU and IO usage. On
the new server, the CPU times are huge -- although actual performance
is quite good. I know sp_who2 is an undocumented proc. Has anyone
experienced this or is it just me?


sp_who2 gets the data from master..sysprocesses. It is difficult to say
what the changes are due to. But if the processes stays connected for a
long time, you will see high numbers.

One possible cause is that there are parallel query plans in use. The
optimizer appears to be fond of parallelism, but the parallel plans are
unfortunately always that effective.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.