Blog Post

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
  • 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

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating