DMV's and Processor Utilization Percent

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 2005 Forums

SQL Server Administration (2005)

DMV's and Processor Utilization Percent

Author

Topic

PaulTeal
Yak Posting Veteran

67 Posts

Posted - 2008-08-18 : 20:54:51

Do any of the dynamic management views (DMV's) provide the current processor utilization percent like you would find in PerfMon?

Paul Teal

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-18 : 20:58:49

I don't believe so, but you can easily get to this from SQL Server by writing a CLR object. .NET code can get to PerfMon, which means we can put it into a .NET CLR stored procedure.

You can check out my disk space CLR object, which shows how to code PerfMon in it:
http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

PaulTeal
Yak Posting Veteran

67 Posts

Posted - 2008-08-18 : 21:42:21

Dang, wish I new C#. Keep meaning to learn enough to do stuff like that.

Paul Teal

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources