Solved

performance management controls checklist

Posted on 2013-01-28
1
385 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

832 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