Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Check for other "Best Practices" we might be able to point out with tbl_ServerProperties #144

Open
gambit9009 opened this issue Mar 17, 2022 · 0 comments

Comments

@gambit9009
Copy link
Contributor

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant