This event is now over

Event Details

About

Pre-Con Code PRECON006
Pre-Con Title Analysis of Your SQL Server Like a PRO
Track(s) Database Administration
Trainer Uwe Ricken
Abstract

SQL Server is a mission critical database platform but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.

 

If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyse and tune SQL Server like a BOSS.

In this full training day, I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach.

Modules/Topics
  • Insides to the workflow of the database engine
  • Importance of security settings for the service accounts
  • Waits and Queues methodology
  • Instance and database level configuration
  • Temp DB importance and optimization
  • Index Analysis and tuning
Key Takeaways
  • Understand how Microsoft SQL Server works
  • Consider correct configuration settings for a fast Microsoft SQL Server
  • Avoid mistakes when you install your Microsoft SQL Server
  • Work with a standardized documentation template for the analysis and audit of your Microsoft SQL Server environment
Demos
  • More than 30 analysis scripts help you to understand the bottlenecks of your Microsoft SQL Server
  • Run all scripts on your test- or production environment
  • Analyze the results of the scripts
  • Fix wrong server settings immediately
  • Evaluate bad performing indexes / statistics
  • Take a set of default maintenance tasks every Microsoft SQL Server should have implemented
What Is Included?
  • Level 300-400, exclusive content from Uwe Ricken
  • Gain real-world knowledge, get real-world exposure packed with real-world demos and examples
  • Get your own copy of course material developed by Uwe Ricken
  • 8 hours of interaction with the Master
  • Lunch, Snacks, Tea/Coffee & loads of fun!
  • And may be some surprise goodies !!
Date August 16, 2017
Time 9:00 am to 5:00 pm IST
Duration 8 hours
Location Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)


List Price

        

Until July 20, 2017

7, 500 + 18% GST

= 8, 850

July 21 – 31, 2017

8, 500 + 18% GST = 10, 030

August 1 – 10, 2017

9, 500 + 18% GST = 11, 210

August 11 – 16, 2017

10, 500 + 18% GST = 12, 390

PS: Prices might change without any prior notice

Contact

admin@sqlservergeeks.com

www.dps2017.com

Venue

Davanam Sarovar Portico Suites
Hosur Main Road, Opp Madiwala Police station
Near Silk Board
Bangalore, Karnataka
India

Map