Solved

performance management controls checklist

Posted on 2013-01-28
1
382 Views
Last Modified: 2013-02-11
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?
0
Comment
Question by:pma111
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 38827840
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Netgear switch to Cisco switch VLAN not passing traffic 8 33
forward schedule of change 1 19
Public DNS? 10 52
Steps to produce a data strategy 5 40
If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now