Solved

performance management controls checklist

Posted on 2013-01-28
1
390 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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…

751 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