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
I watched all of the sessions yesterday and they were GREAT! And talk about timing.... Today my boss came to me with a performance problem with one of those 3rd party applications that was having a terrible performance problem. I will be using the techniques I saw yesterday to hopefully identify, isolate and resolve the problem. Thanks again. BTW, when I saw Allen White's presentation on Powershell and SQL performance monitoring at SQLSaturday in Richmond VA, he said "if you ever get a chance to see a Buck Woody prsentation, don't miss it". He was right! Thanks again for providing this valuable training. I can't wait to get the DVD.
That's very kind, David! Glad you enoyed it. We had a blast working together!
Where can we watch the presentations?
Bill - check with Quest. They have them posted on their site.
I really don't like it when people use red.
Red looks like an error coming on the page
Red seems like an error over the page
Red is the color of happiness. And Racecars.