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 SkipVought 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
0
0
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
27
TheBugSlayer
TheBugSlayer
bikerboy718
  • Locked
  • Question
SQL Server Monitoring software
Replies
2
Views
36
MakeItSo
MakeItSo
mkal
  • Locked
  • Question
Monitoring size of databases
Replies
0
Views
11
mkal
mkal
Ceez
  • Locked
  • Question
SQL05 Standard - sqlservr 100% CPU at all times!
Replies
3
Views
15
intelwizrd
intelwizrd
niall5098
  • Locked
  • Question
SQL SERVER High CPU issue
Replies
6
Views
13
niall5098
niall5098

Part and Inventory Search

Sponsor

Back
Top