Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CPU monitoring

Status
Not open for further replies.
jimmYLepp

jimmYLepp

Programmer
Jan 22, 2002
39
US
Is there a way to get the current CPU Utilization out of SQL Server Query Analyzer. All I have found is SELECT @@CPU_BUSY which seems to show how much time the CPU has spent processing SQL Server requests, but what I want is something like current % total used, and current % used by just sql server.


jimmY
[evil]
 
Sort by date Sort by votes
I was hoping to be able to have a procedure run and find out the CPU utilization at that moment in time. Since I was able to find WMI for NT 4.0 and it seems SQL Server isn't able to do it. I'll use WMI. Thanks for the advise.

jimmY
[cheers]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
SQL Server monitoring tools - suggestions
Replies
0
Views
102
TheBugSlayer
TheBugSlayer
bikerboy718
  • Locked
  • Question
SQL Server Monitoring software
Replies
2
Views
88
MakeItSo
MakeItSo
mkal
  • Locked
  • Question
Monitoring size of databases
Replies
0
Views
68
mkal
mkal
Ceez
  • Locked
  • Question
SQL05 Standard - sqlservr 100% CPU at all times!
Replies
3
Views
66
intelwizrd
intelwizrd
niall5098
  • Locked
  • Question
SQL SERVER High CPU issue
Replies
6
Views
77
niall5098
niall5098

Part and Inventory Search

Sponsor

Back
Top