You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The perfstatsanalysis script creates an sp called "proc_PowerPlan".
if not exists (select*from tbl_PowerPlan where ActivePlanName like'%High Performance%')
So if the power plan name is not fully spelled out like that, it may flag "Power Plan is not set to high performance". But, at least in later Windows, you can rename your power plan. PC manufactures may have their own names for plans, etc. Someone could use the High Perf plan and change settings to it, without renaming it. The actual settings under the power plan, like CPU throttling, are really what we are concerned with, and not the name of the plan.
Need to consider for SQL Nexus, at least changing the message that server "might not" have proper power plan...and then be helpful and actually concatenate the power plan name we do see in the message. Might help stop having to look up false positives about the server's power plan.
PSSDiag captures __SQL_Base_Power_Plan_Startup.txt and that appears to be what gets added to tbl_PowerPlan. But also _SQL2019_MiscPssdiagInfo_Startup.OUT captures powerplan in --ServerProperty-- which gets added into tbl_ServerProperties by Nexus. "proc_PowerPlan" consider updating to check both places if one doesn't have it.
The perfstatsanalysis script creates an sp called "proc_PowerPlan".
So if the power plan name is not fully spelled out like that, it may flag "Power Plan is not set to high performance". But, at least in later Windows, you can rename your power plan. PC manufactures may have their own names for plans, etc. Someone could use the High Perf plan and change settings to it, without renaming it. The actual settings under the power plan, like CPU throttling, are really what we are concerned with, and not the name of the plan.
The text was updated successfully, but these errors were encountered: