Home » Events » DPS 2020 Training Class - SQL

News Stories

Job Search


Back to Events »

DPS 2020 Training Class - SQL

Time06:00:00 Phone
DateMonday, December 07, 2020 Web
VenueOnline Email

DPS 2020 Training Class - SQL Server Optimization 

Hire Fixed Cost Java Developers


Virtual Training Classes at DPS 2020

Training Class is designed to offer intermediate & advanced-level training on a specific topic/subject. This class offers more knowledge, skills and expertise. Apart from attending LIVE classes, you also get on-demand access to class recordings, exclusive content from the instructor, and the participation certificate. It is a STEAL, grab it!

Training Class - Analyze and Optimize your SQL Server

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.

You need to book here:

Make sure you visit the Summit too:

Book NOW to get 55% OFF. Use discount code - DPSMEETUP



Information & Registration

tcube_200_x_100.gifDATE & TIME: 7th December 2020 / 06:00

VENUE: Online


Book Your Ticket or Find Out More About this Event publishes details of this event for information only which are correct at the time of publication. accepts no responsibility for cancellation, amendment and or loss for whatever reason.


For weekly event email

complete Green Box (top right)

Get Instant Irish Tech News from our Social Channels....


Join at Facebook Join at LinkedIn Follow IrishDevdotcom on Twitter


Stackand.Co Software Recruiters
Coworking, Hotdesks and Virtual Office Space in Dublin City Centre
Visit TechStack Solutions