http://www.sqlservercentral.com/blogs/aschenbrenner/2012/12/10/practical-sql-server-performance-troubleshooting-day-1/ Printed 2016/05/02 12:39AM
Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I’m running on January 29 (Vienna/Austria) and January 31 (Zurich/Switzerland) my 1 day workshop called “Practical SQL Server Performance Troubleshooting Day” (see http://www.SQLpassion.at/events.html for further information).
During this 1 day workshop we will take a default installation of SQL Server, and run an OLTP workload with a several hundred users to generate our initial baseline for performance tuning/troubleshooting. Throughout the day we will work across various areas of SQL Server to implement different performance optimizations, and check how those changes will impact the throughput of our test workload. At the end of the day we will have a well-performing SQL Server which can handle a much larger workload than the initial (default) installation.
Following areas are covered in this workshop:
- Windows OS Settings
- Storage Configuration
- SQL Server Instance Settings
- Database Settings
- Index/Statistics Maintenance
- Memory Management
I have also presented this content in November at the SQLPASS Summit in Seattle/USA as a precon with around 130 attendees. Here is some feedback from them:
- “The presentation was like listening to a story, not just technical info. Even though it was demo based it had practical and application real-world applications.”
- “Although I already knew a lot of the principles that was gone over, I also learned a lot that I did not know. It will be good to take the additional knowledge back to work and see if I can improve our production environment.”
- “The speaker provided plenty of information and techniques for SQL Server performance troubleshooting that are not evident in standard SQL Server training and from available online information.”
- “My notes have a bunch of TODOs for follow up research and implementation. Mostly it’s a bunch of settings to check and probably tweak to suit our environment, but I also found a couple new tools to check out.”
- “Baselining is the key to troubleshooting. Solving a problem can lead to more opportunities and sometimes solving problems can create more problems, without a baseline you’ll never know.”
So if you are also interested in improving your SQL Server performance/throughput, don’t hesitate and register at http://www.SQLpassion.at/events.html. There is also an early-bird price available until the end of this year.
See you soon!