We apologize for any inconvenience you may experience while using the website as it is currently undergoing updates.

Ok!

Cities

Vienna

SQL Server Performance Tuning and Optimization

ID  583

Information Technology Telecommunication & Networking Training Courses

SQL Server Performance Tuning and Optimization

Vienna

Hotel Name
Hotel Meeting Room

07 Apr 2025 : 11 Apr  2025

25 Hours

4950 USD

Course Application Form

Candidate Data

Candidate full name *
Email *
Private phone number *

Work phone number

Country & City *
Company / Employer *

Invoice Recipient Data

Recipient name *
Recipient phone number *

Recipient email

Recipient work address details



Sending course brochure to my e-mail

Please leave us your contacts, and we will call you back as soon as possible

Full name *
Email *

Private phone number



Call me back

Please leave us your contacts, and we will call you back as soon as possible

Full name *
Private phone number *
Company / Employer *


Course Inquiry

Please provide us with your contacts with your inquiry, and we will answer it as soon as possible

Full name *
Email *
Private phone number *
Country & City *
Company / Employer *

Your Inquiry



In-house proposal

Please provide us with your contacts and the details of the needed in-house proposal, and we will contact you as soon as possible

Full name *
Email *
Private phone number *
Country & City *
Company / Employer *

Your Inquiry



Course-options

Training Details

COURSE OVERVIEW

In this course, you will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. You will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues.

WHAT YOU'LL LEARN

  • SQL 2014 Architecture including the new Cardinality Estimator
  • Memory-optimized tables
  • Startup stored procedures
  • Database structures
  • Instant File Allocation
  • Table internals and valued parameters
  • Concurrency, transactions, and isolation levels
  • SQL Server locking architecture
  • Partitioned tables and indexes
  • Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)
  • Performance Monitor Tool, execution plans, Data Access Operators, MDW and viewing reports
  • Create, utilize, manage and monitor indexes
  • Cardinality Estimator, incremental statistics, computed column statistics, filtered statics, and maintenance
  • In-Memory OLTP engine, restrictions, the Analyze Migrate Report tool, and in-memory (DMVs)

OUTLINE

SQL 2014 Architecture
  • Cardinality Estimator
  • Memory-Optimized Tables
  • Understand Performance for Developers
  • Startup Parameters and Startup Stored Procedures
  • Database Structures
  • Instant File Allocation
  • How SQL Stores and Locates Data
The Database Engine
  • Temporary Tables Internals
  • Concurrency, Transactions, and Isolation Levels
  • SQL Server Locking Architecture
  • SQL and Storage Area Networks (SAN)
  • SQL on VMs and SQLIO Utility
  • Partitioned Tables and Indexes
SQL Performance Tools
  • Resource Governor
  • Activity Monitor
  • Live Query Statistics
  • Monitoring SQL with Transact-SQL
  • DMOs and Performance Tuning
Query Optimizing and Operators
  • Tuning Process
  • Performance Monitor Tool
  • SQL Query Processing Steps
  • Understanding Execution Plans
  • Set Statistics Time and Set Statistics IO
  • Data Access Operators and Troubleshooting Queries
Understanding Indexes
  • Index Types by Storage and Column Designation
  • Creating and Altering Indexes
  • Metadata
  • DMVs for Indexing, Database Engine Tuning Advisor, Index DMOs
  • Fragmentation and Patterns
  • Index Storage Strategies, Indexed Views, and Monitoring Indexes
Understanding Statistics
  • Cardinality Estimator
  • Incremental, Computed Columns, and Filtered Statistics
  • Maintenance
In-Memory Databases
  • Architecture
  • Tables and Indexes
  • Natively Compiled Stored Procedures
  • Restrictions
  • Analyze Migrate Report Tool
  • In-Memory Data Management Views (DMV)

Day 1 - Asset Cost Management Introduction

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

Day 2 - Laying the Groundwork

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

Day 3 - Applying the Value based Process

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

Day 4 - Ensuring the Continuity of the Value-based Process

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

The European Quality of Training and Management Consulting relies on advanced methodology in developing skills and enhancing the effectiveness of human resources. The company adopts modern methods to achieve these goals. In order to achieve its objectives, European Quality follows the following steps in a precise and professional manner:

  • Lectures and Visual Presentations:

    • Theoretical lectures are presented through PowerPoint presentations, videos, and short films, providing a comprehensive and enjoyable learning experience.

  • Scientific Assessment:

    • Trainees are thoroughly assessed before and after the training program to ensure the desired objectives are achieved and to provide necessary guidance.

  • Brainstorming and Role-playing:

    • Innovation and problem-solving are encouraged through brainstorming sessions and role playing experiences.

  • Practical Cases:

    • Practical learning is emphasized through cases relevant to the subject matter and the nature of work for the trainees, contributing to the development of practical skills.

  • Final Evaluation and Certificates:

    • A comprehensive assessment is conducted at the end of the program. Trainees are awarded attendance and participation certificates recognized by the European Quality for Training and Administrative Consultations, provided they have completed at least 80% of the program days.

  • Training Materials:

    • Professional trainers and experts in various fields create scientific and practical training materials, which are printed and retained, and distributed on CD or flash drives to ensure easy access to the content.

  • Post-Training Follow-up:

    • European Quality for Training and Administrative Consultations provides continuous support after the training program. This support includes additional consultancy sessions or workshops to ensure the continuity of learning and the application of acquired skills in the working environment.

  • Customized Training Programs:

    • Training programs are designed to meet the needs of individual companies and institutions. Client needs are carefully analyzed to ensure that the training content aligns with their specific objectives and achieves the desired impact.

  • Utilizing Technology:

    • Training incorporates modern techniques such as online platforms and distance learning to provide flexible and effective learning experiences. Participants can access educational resources online and engage in discussions and online workshops.

  • Specialized Trainers:

    • Trainers and lecturers are carefully selected to ensure they have high expertise in their fields. Experience and professionalism are added to the training to ensure the delivery of high-quality content and effective learning experiences.

  • Encouraging Participation:

    • European Quality encourages active participation and interaction during training sessions. Interactive activities such as group discussions and collective exercises are organized to stimulate effective participation in the learning process.

  • Focus on Personal Transformation:

    • Participants are encouraged to think critically and develop problem-solving skills and decision making abilities. They are guided towards achieving personal and professional transformation, leading to improved performance in their work areas.

  • Continuous Assessment:

    • Continuous assessments are provided to evaluate participants performance and their understanding of the training materials. This assessment is used to modify the training program if necessary and ensure the desired results are achieved.

  • Terms and Conditions:

    • Terms and conditions apply to all training programs. It is assumed that registering for any training program implies the participants agreement to these terms, including registration, payment, and cancellation policies.

  • Prices and Discounts:

    • It is noted that the prices displayed on the website do not include a 5% value added tax. All prices are subject to discounts according to the companys policies.

European Quality of Training and Management Consulting reserves the right to change the location of the training program, change the accredited lecturers for program delivery, hold, or cancel the program in line with the companys vision and program conditions and our quality policy.

European Quality for Training and Consultancy is certified

ISO 9001-2015

All rights reserved

Course Options

?>
Training other dates & Locations
78
26 Jan 2025   :  30 Jan 2025
Doha
3650$
27 Jan 2025   :  31 Jan 2025
Stockholm
4950$
03 Feb 2025   :  07 Feb 2025
Boston
6950$
09 Feb 2025   :  13 Feb 2025
Dubai
2950$
10 Feb 2025   :  14 Feb 2025
Roma
4950$
16 Feb 2025   :  20 Feb 2025
Dubai
2950$
17 Feb 2025   :  21 Feb 2025
Cape Town
5450$
17 Feb 2025   :  21 Feb 2025
Milan
4950$
17 Feb 2025   :  21 Feb 2025
Prague
4950$
23 Feb 2025   :  27 Feb 2025
ON LINE
1750$
24 Feb 2025   :  28 Feb 2025
Dublin
4950$
03 Mar 2025   :  07 Mar 2025
Athens
4950$
03 Mar 2025   :  07 Mar 2025
Hong Kong
5950$
07 Apr 2025   :  11 Apr 2025
Vienna
4950$
14 Apr 2025   :  18 Apr 2025
Washington
6950$
14 Apr 2025   :  18 Apr 2025
California
6950$
20 Apr 2025   :  24 Apr 2025
Dubai
2950$
21 Apr 2025   :  25 Apr 2025
Berlin
4950$
28 Apr 2025   :  02 May 2025
Copenhagen
4950$
04 May 2025   :  08 May 2025
Beirut
2950$
05 May 2025   :  09 May 2025
Los Angeles
6950$
11 May 2025   :  15 May 2025
Dubai
2950$
12 May 2025   :  16 May 2025
Singapore
5950$
25 May 2025   :  29 May 2025
Marrakech
3950$
26 May 2025   :  30 May 2025
Sydney
5950$
08 Jun 2025   :  12 Jun 2025
Dubai
2950$
09 Jun 2025   :  13 Jun 2025
Barcelona
4950$
15 Jun 2025   :  19 Jun 2025
Cairo
2450$
15 Jun 2025   :  19 Jun 2025
Riyadh
2950$
23 Jun 2025   :  27 Jun 2025
Kuala Lumpur
3950$
30 Jun 2025   :  04 Jul 2025
Florida
6950$
30 Jun 2025   :  04 Jul 2025
London
4950$
06 Jul 2025   :  10 Jul 2025
Dubai
2950$
07 Jul 2025   :  11 Jul 2025
Madrid
4950$
13 Jul 2025   :  17 Jul 2025
Kuwait
3250$
14 Jul 2025   :  18 Jul 2025
Lisbon
4950$
14 Jul 2025   :  18 Jul 2025
Beijing
4950$
20 Jul 2025   :  24 Jul 2025
Amman
2950$
28 Jul 2025   :  01 Aug 2025
Jakarta
3450$
03 Aug 2025   :  07 Aug 2025
Jeddah
2950$
03 Aug 2025   :  07 Aug 2025
Sharm El Sheikh
2950$
11 Aug 2025   :  15 Aug 2025
Amsterdam
4950$
11 Aug 2025   :  15 Aug 2025
Tbilisi
4950$
17 Aug 2025   :  21 Aug 2025
Casablanca
3950$
17 Aug 2025   :  21 Aug 2025
Dubai
2950$
25 Aug 2025   :  29 Aug 2025
Paris
4950$
31 Aug 2025   :  04 Sep 2025
Salalah
3450$
01 Sep 2025   :  05 Sep 2025
Geneva
4950$
08 Sep 2025   :  12 Sep 2025
Vienna
4950$
14 Sep 2025   :  18 Sep 2025
Dubai
2950$
15 Sep 2025   :  19 Sep 2025
Munich
4950$
22 Sep 2025   :  26 Sep 2025
Istanbul
2950$
28 Sep 2025   :  02 Oct 2025
Alkhobar
2950$
29 Sep 2025   :  03 Oct 2025
Toronto
5950$
05 Oct 2025   :  09 Oct 2025
Manama
2950$
06 Oct 2025   :  10 Oct 2025
Zurich
5450$
12 Oct 2025   :  16 Oct 2025
Dubai
2950$
13 Oct 2025   :  17 Oct 2025
Stockholm
4950$
13 Oct 2025   :  17 Oct 2025
San Francisco
6950$
20 Oct 2025   :  24 Oct 2025
Cyprus (Larnaka)
4950$
20 Oct 2025   :  24 Oct 2025
Boston
6950$
20 Oct 2025   :  24 Oct 2025
Roma
4950$
27 Oct 2025   :  31 Oct 2025
Prague
4950$
03 Nov 2025   :  07 Nov 2025
Dublin
4950$
09 Nov 2025   :  13 Nov 2025
Dubai
2950$
10 Nov 2025   :  14 Nov 2025
Athens
4950$
17 Nov 2025   :  21 Nov 2025
Washington
6950$
17 Nov 2025   :  21 Nov 2025
California
6950$
23 Nov 2025   :  27 Nov 2025
Cairo
2450$
23 Nov 2025   :  27 Nov 2025
Riyadh
2950$
01 Dec 2025   :  05 Dec 2025
Kuala Lumpur
3950$
07 Dec 2025   :  11 Dec 2025
Dubai
2950$
08 Dec 2025   :  12 Dec 2025
London
4950$
15 Dec 2025   :  19 Dec 2025
Madrid
4950$
21 Dec 2025   :  25 Dec 2025
Kuwait
3250$
22 Dec 2025   :  26 Dec 2025
Beijing
4950$
28 Dec 2025   :  01 Jan 2026
Dubai
2950$
29 Dec 2025   :  02 Jan 2026
Munich
4950$

Result -->

12 Courses

Download Result List

A

Z

PLC Telemetry and SCADA Technologies

ID 19

One week

Course Details

Dates & Locations

Information Storage and Management

ID 732

Two weeks

Course Details

Dates & Locations

ID 

Two weeks

Course Details

Dates & Locations

ID 

Two weeks

Course Details

Dates & Locations

Professional Business System Analyst

ID 124

One week

Course Details

Dates & Locations

Business Analysis

ID 142

One week

Course Details

Dates & Locations

Supporting and Troubleshooting Windows 10

ID 542

One week

Course Details

Dates & Locations

Computer Application Skills for Engineers and Managers

ID 172

One week

Course Details

Dates & Locations

Transformation of Public Affairs and Government Relations in the Digital Era

ID 878

One week

Course Details

Dates & Locations

Formulation of Smart Goals and Building KPI through Data

ID 739

One week

Course Details

Dates & Locations

Cloud Computing

ID 746

Two weeks

Course Details

Dates & Locations

Construction Site Management & Supervision

ID 245

One week

Course Details

Dates & Locations