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
Table tbl_ServerProperties has 'cpu_count' and 'number of visible schedulers'. If those aren't equal, point out SQL not using all procs.
'VISIBLEONLINE_SCHEDULER_COUNT' is also there. Maybe redundant?
In a few cases we have heard of servers that might need a patch to fix perf issues we'd never catch in SQL alone.
'registry SystemManufacturer'
'registry SystemProductName'
We might be able to have a warning for those machines found.
'resource governor enabled' (not sure what this checks ...and just because it is on doesnt mean there is any effect.)
'possibly running in virtual machine' (just good to know especially with perf issues)
'sqlserver_start_time' & 'machine start time' (server hasn't been restarted in a "long" time? but how much is a "long" time? not patched, etc)
The text was updated successfully, but these errors were encountered:
Table tbl_ServerProperties has 'cpu_count' and 'number of visible schedulers'. If those aren't equal, point out SQL not using all procs.
'VISIBLEONLINE_SCHEDULER_COUNT' is also there. Maybe redundant?
In a few cases we have heard of servers that might need a patch to fix perf issues we'd never catch in SQL alone.
'registry SystemManufacturer'
'registry SystemProductName'
We might be able to have a warning for those machines found.
'resource governor enabled' (not sure what this checks ...and just because it is on doesnt mean there is any effect.)
'possibly running in virtual machine' (just good to know especially with perf issues)
'sqlserver_start_time' & 'machine start time' (server hasn't been restarted in a "long" time? but how much is a "long" time? not patched, etc)
The text was updated successfully, but these errors were encountered: