DPS 2020 Training Class – SQL Server Optimization- by Uwe Ricken

Pre-Con Title

Analyze And Optimize Your SQL Server

Track(s)

Architecture

Tags

#SQLServer #Configuration #Installation

Level

Intermediate

Trainer/Speaker

Uwe Ricken

Abstract

The day-to-day business of a DBA as well as consultants who are on the move in terms of “”Microsoft SQL Server”” include careful analysis of SQL Server systems when the business or the customer reports performance problems. In the “”Analysis of SQL Server”” workshop, a specific example is used to test a Microsoft SQL Server for various problem cases that lead to bottlenecks if they are not set correctly.

In the workshop, the various problem analyzes are demonstrated by examples with explanations of the possible effects. At the same time, a solution plan is drawn up in which the participant can work through the correct settings in the operating system to the configuration settings in Microsoft SQL Server. Finally, solutions are shown if the performance within a single database is assessed as insufficient. All possible performance bottlenecks are simulated and evaluated on an installed Microsoft SQL Server using scripts. The following analysis steps are covered during the workshop:

• Check and evaluate settings in the operating system
• Analysis of the databases for configuration, usage and system utilization
• Configuration and analysis of TEMPDB
• Waits and Latches: What is Microsoft SQL Server waiting for and what influence do the various waiting processes have on the performance of the applications.
• Index maintenance – how are indexes used, which indexes are missing, how is the physical condition of indexes to be assessed.
• At the end of the evaluations, a template is presented in which the results of the investigation.

• Understanding the process route of Microsoft SQL Server
• Important settings for the OS
• Important settings for SQL Server
• Analyse the database configuration
• Analyze Wait Stats
• Best practice configuration
• Reporting of found issues

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

Book Now