The Pesky Windows Power Plan Oh My

  • SQLShark

    SSCrazy

    Points: 2187

    Comments posted to this topic are about the item The Pesky Windows Power Plan Oh My

  • sak3438

    SSC Enthusiast

    Points: 110

    Hey mentor, does changing power plan require a system reboot for it to take effect? (Asks Tom)

  • SQLShark

    SSCrazy

    Points: 2187

    According to the MS article it does not. Here is a good link from Cindy Gross regarding why to change it.

    https://blogs.msdn.microsoft.com/cindygross/2011/03/09/power-saving-options-on-sql-server/

  • Summer90

    SSC-Dedicated

    Points: 32817

    When I get a new server that is one of the first things I change, the power plan.  It is crazy to think power consumption is a worry when you are talking about server processing.

  • ThomasRushton

    SSC-Insane

    Points: 22521

    Just remember that Windows isn’t the only thing that restricts your power.  There are BIOS settings to consider, and, if you’re running virtual machines, there are possible throttles there too.

    Something else to consider is that, just because you *can* change the setting in Windows, doesn’t mean it’ll stay there – if your infrastructure team has been doing stuff, then chances are there’s a group policy they might need to adjust to allow SQL Servers to not be restricted like this.

  • SQLShark

    SSCrazy

    Points: 2187

    Thomas, I can’t agree more with you on that note. I was enagaged to look at a performance issue and I found the Power Plan in Balanaced mode, SO I put some code together and queried about 3,700 Windows machines. I was not happy with what I found. Thanks for the comment, Edward J Pochinski III

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

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