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
- Locking/Blocking/Deadlocking
- 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!
-Klaus