Solved

performance management controls checklist

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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
fabric 1 34
VMWare environment audit 8 68
OSPF - Convergence & Downtime 9 37
SMB Packet - File Data 4 14
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.
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 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