THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

Presentation Links: SQL Server Performance Tuning (Quest)

I worked with a team of folks brought together by Quest software, and we presented multiple sessions on SQL Server Performance Tuning. Here are the links I mentioned during those presentations:

 

Blitz! SQL Server Takeovers (Brent)

 

You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, "Did you know about this SQL Server over here?" Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.

·        SQL Server Best Practices Article: http://technet.microsoft.com/en-us/library/cc966412.aspx

·        How to determine proper SQL Server configuration settings: http://support.microsoft.com/kb/319942

·        Setting Server Configuration Options (SQL Server 2008 R2, other versions available) : http://technet.microsoft.com/en-us/library/ms189631.aspx

·        Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations: http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx

·        Checklist: SQL Server Performance: http://msdn.microsoft.com/en-us/library/ms979169.aspx

·        Script Repository for SQL Server Information: http://gallery.technet.microsoft.com/ScriptCenter/en-us/site/search?f%5B0%5D.Type=RootCategory&f%5B0%5D.Value=databases&f%5B0%5D.Text=Databases&f%5B1%5D.Type=SubCategory&f%5B1%5D.Value=sqlserver&f%5B1%5D.Text=SQL%20Server

 

 “Turn your head and cough” – Quick Health Check Using Wait Stats for the SQL Server Takeover (Kevin)

So you’ve survived the SQL Server Blitz and have made sure that your server is properly setup, configured, and under proper preventative maintenance.  Now it’s time to play doctor and determining the health of your SQL Server.  Kevin will slip on the latex gloves and show you how to determine the health of an unknown server and the applications running on that SQL Server with a quick physical.

·        SQL Server Best Practices Analyzer (SQL Server 2008 R2, other versions available) : http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

·        Microsoft Assessment and Planning (MAP) Toolkit for SQL Server 2008 (will detect all the way down to SQL Server 2000): http://technet.microsoft.com/en-us/solutionaccelerators/dd537572.aspx

·        DMV Stats:  http://www.codeplex.com/sqldmvstats

·        SQL Server 2005 Performance Dashboard Reports: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

 

Lose Wait Fast with Wait Stats (Brent)

It's time for you to get serious about wait loss - no, not weight loss, but wait loss.  SQL Server wait stats will tell you what your queries and your server have been waiting on, and you don't even have to use Profiler or tracing!  Brent will show you how to troubleshoot issues in real time and check historical data.  He'll also show tools to make this process easier.

·        Troubleshooting Performance Problems in SQL Server 2008 Whitepaper (2005 version also available) : http://msdn.microsoft.com/en-us/library/dd672789.aspx

·        SQL Server 2005 Performance Tuning using Waits and Queues:  http://technet.microsoft.com/library/cc966413.aspx

·        SQL Server 2005 Waits and Queues: http://sqlcat.com/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx

·        OLTP Top 6 Performance Issues for OLTP Applications:  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/oltp-performance-issues.mspx

·        Top SQL Server 2005 Performance Issues for OLTP Applications: http://sqlcat.com/top10lists/archive/2007/11/21/top-sql-server-2005-performance-issues-for-oltp-applications.aspx

 

PerfMon is “Irie Mon” (Kevin)

They say “irie mon” in Jamaica when everything is going well.  Performance Monitor is irie! It’s an extremely important tool in the pocket of any IT professional because it’s available on every version of Windows and provides valuable performance information across all of the components of SQL Server, from the relational and storage engine to SSIS, SSAS, and SSRS.  Kevin will show you how to make sense of PerfMon’s multitude of counters, how to store PerfMon data for long-term analysis, and how to correlate PerfMon

·        Windows Reliability and Performance Monitor : http://technet.microsoft.com/en-us/library/cc755081(WS.10).aspx

·        Overview of Windows Performance Monitor: http://technet.microsoft.com/en-us/library/cc749154.aspx

·        Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005: http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx

·        Troubleshooting Performance Problems in SQL Server 2008: http://sqlcat.com/whitepapers/archive/2009/04/14/troubleshooting-performance-problems-in-sql-server-2008.aspx

 

Published Wednesday, July 21, 2010 3:54 AM by BuckWoody

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Nishant said:

Good Job Honey

May 14, 2012 2:41 PM

Leave a Comment

(required) 
(required) 
Submit

About BuckWoody

http://buckwoody.com/BResume.html

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement