Post reply

Creating Alerts on Windows Performance Counters

  • 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

  • June 12, 2008 at 8:47 am

    #827912

    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.

  • June 12, 2008 at 9:20 am

    #827938

    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

  • June 12, 2008 at 9:46 am

    #827965

    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.

  • June 12, 2008 at 11:24 am

    #828004

    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

  • June 12, 2008 at 1:19 pm

    #828084

    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 ...

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

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