performance management controls checklist

Can anyone assist with putting together a top level checklist of best practice “performance management controls” that should be followed for effective performance management of business critical database servers?

I.e. a list that our audit/risk teams should compare to (( “what should be being done, to what is being done”))  verify what is happening on these systems, to ensure for effective performance management.

Any sort of top 10 controls checklist would be useful. I can’t find anything via Google.
If you have had experience in network and systems management before, especially from “availability perspectives”, what would good performance management look like, what would you look for, what can typically be improved, what would poor performance management look like?
LVL 3
pma111Asked:
Who is Participating?
 
lcohanDatabase AnalystCommented:
I think you need to build your own "10 most critical factors" checklist depending on your speciffic environment and there are many articles/tools to help you uinderstand what is needed to keep a SQL server in Windows environment to operate properly. Please see article below and try your own search for "monitoring SQL pesformance" in google:

http://msdn.microsoft.com/en-us/library/ee377023(v=bts.10).aspx
http://sqlblog.com/blogs/kevin_kline/archive/2008/03/28/the-most-important-performance-monitor-counters-for-sql-server.aspx
http://www.techrepublic.com/blog/datacenter/monitoring-sql-server-performance/162

Some usefool tools that can help you monitoring SQL performance - I always recommend on the top to use SQL own Performance Dashboard Reports:

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/sql-server-performance-dashboard-reports-in-ssms-introduction-install-datediff-error-amp-modified-for-sql-2008.aspx
http://blogs.msdn.com/b/arvindsh/archive/2010/06/25/performance-dashboard-reports-in-sql-server-2008.aspx

and others like:
http://www.red-gate.com/products/dba/sql-monitor/?utm_source=google&utm_medium=cpc&utm_content=unmet_need&utm_campaign=sqlmonitor&gclid=CIHb64zVi7UCFQf0nAoduV0Adg

http://www.quest.com/landing/default.aspx?ID=7500&gclid=CKaPwI3Vi7UCFQWonQodfwwAKg



OR
1.      SQL Server 2005 Best Practices Analyzer (August 2008)
2.      SQL Server Health and History Tool (SQLH2)
3.      SQLIO Disk Subsystem Benchmark Tool
4.      RML Utilities for SQL Server (x86)
5.      SQL Server Health and History Tool (SQLH2) Performance Collector

Built-In Performance Reports in SQL Server 2005
http://www.mssqltips.com/tip.asp?tip=1179
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.