Monitor CPU Usage - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Monitor CPU Usage

Author

Topic

davy_boy2000
Starting Member

28 Posts

Posted - 2002-07-04 : 05:35:56

Hi Folks,

I've been searching the web and cannot find any help on the above. I want to be able to pull back the CPU usage of the SQL Server via an SQL Query, (or external stored procedure). This is so that I can display the current CPU Usage % of the server on an SQL Server Monitoring WEB page by calling the SQL statement.

Cheers,

Davy

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-07-04 : 06:32:50

USE master
EXEC sp_monitor

And here's an example from BOL:
This example shows SQL Server CPU activity as of the current date and time.
SELECT @@CPU_BUSY AS 'CPU ms', GETDATE() AS 'As of'

Edited by - YellowBug on 07/04/2002 06:39:49

davy_boy2000
Starting Member

28 Posts

Posted - 2002-07-04 : 06:47:47

Thanks, but it still doesn't give me what I am looking for. sp_monitor only displays the use of the CPU by SQL, and only since the last time the sp_monitor was ran.

What I am looking for is something like what you get from Task Manager CPU Usage.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources