Useage of processor - 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 Administration (2000)

Useage of processor

Author

Topic

chetancool
Starting Member

34 Posts

Posted - 2004-11-04 : 06:30:01

Hi group..
I want to know that sql server is using how much of processor useage.
is there any way..

Chetan

cjain

Kristen
Test

22859 Posts

Posted - 2004-11-04 : 14:32:26

Performance Monitor??

Kristen

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-11-04 : 15:35:09

There are some statistical functions / variables you can use:
@@IDLE, @@CPU_BUSY
You could poll these at regular intervals and store in a table,
later you can run calculations to see cpu usage over time.

See also sp_monitor

rockmoose

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources