Creating Alerts on Windows Performance Counters

Question

Creating Alerts on Windows Performance Counters

Ray Laubert

SSCrazy

Points: 2910
More actions
June 12, 2008 at 8:39 am

#122128

I have an issue were I need to create an alert on Available MBytes on my database server. I know I have seen somewhere on the web how to access this information, but now I can not find it.
If you know how to access Windows Performance counters from within SQL while setting up alerts please post it here.
Thanks
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLshifu SSC Eights! Points: 953 More actions · Answer 1

if you are using powershell, you could write a script to check available memory(MB) metric (system.diagnostics.performancecounters()). If it is greater than a threshold, send you and your team an alert email.

Ray Laubert SSCrazy Points: 2910 More actions · Answer 2

Need or want to do this from within SQL as other counters and conditions will exist. Thanks

Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g

SQLshifu SSC Eights! Points: 953 More actions · Answer 3

Checkout the dynamic management views such as select * from sys.dm_os_performance_counters

http://msdn.microsoft.com/en-us/library/ms176083.aspx

so far, I have not found Availabele MB in any of the views.

Ray Laubert SSCrazy Points: 2910 More actions · Answer 4

This is a Windows counter and will not be in the DM views.

Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g

Adam Bean One Orange Chip Points: 26631 More actions · Answer 5

Can't say I have any experience with it, but you can create your own custom counters via SQLServer:User Settable. Might be able to tie into CLR or some extended stored procs such as xp_fixeddrives?

I might give this a shot myself, seems interesting ...