SQL Server Performance Tuning and Optimization

Code

583

Start Date

2025-10-12

End Date

2025-10-16

City

Stockholm

Price

4950 $

Language

Participants

1-15

Hotel

Hotel Meeting Room

Provide us with your details and the team will contact you

Send to a friend

Please fill in all the fields below and a link will be sent to your e-mail when you click it. You will be redirected to the download page

Full Name

Mobile Number

E-mail

Please fill in all the fields below and a link will be sent to your email when it is clicked

Full Name

Mobile Number

E-mail

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)

To view the training curriculum, please click here
To view the registration, payment, and cancellation policy, please click here
To view the terms and conditions for the training program locations, please click here.

European Quality for Training and Consultancy is certified

ISO 9001-2015

Other Dates for the Courses

Information Technology Telecommunication & Networking Training Courses

Courses Category

Most Read

The Proposed Courses

SQL Server Performance Tuning and Optimization

COURSE OVERVIEW

WHAT YOU'LL LEARN

OUTLINE

SQL 2014 Architecture

The Database Engine

SQL Performance Tools

Query Optimizing and Operators

Understanding Indexes

Understanding Statistics

In-Memory Databases

Other Dates for the Courses

Categories

Other links

Search in site

Mailing List

Payment Methods

Cities

Contact us