PBM Policy / WMI query to see which CPUs are in power-saving mode

  • ben-564110

    SSC Eights!

    Points: 942

    Comments posted to this topic are about the item PBM Policy / WMI query to see which CPUs are in power-saving mode

  • TheSQLGuru

    SSC Guru

    Points: 134017

    This has been a VERY hot topic for the SQL community. Thanks for posting this!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • ben-564110

    SSC Eights!

    Points: 942

    Thanks Kevin,

    The nice thing about using PBM or WMI like this for most DBAs is that you don't have to go around raising lots of change requests to install CPU-Z on all your SQL servers just on a hunch that you're server is going slow, which if you're very unlucky can even give your server a blue screen of death!

    Ben

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the script. This is very helpful.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 4 (of 4 total)

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