data-konzept

'One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second only to storage latency and more of a concern than memory. Although with anything in SQL we can say it depends.

I’ve recently seen a lot of SQL Server instances that were hosted on servers where the power management configuration was not configured; or, I should say it was not disabled.

Power management can reduce the server performance by more than 20% and it’s a simple issue to resolve that requires no code changes to the database or your application.

I decided to create a simple PowerShell script that would report back only if it detected an issue.'...

http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2016/08/11/using-powershell-to-find-processor-issues-more/