Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
01. PREPARING THE DEVELOPMENT ENVIRONMENT
➡ SQL Server Configuration Manager.
➡ SQL Server Management Studio (SSMS).
➡ Setting up the database for this training course
➡ DBO and data preparation
02. MONITORING MECHANISMS AND TOOLS
➡ SQL Server Profiler
➡ Extended Events (XEvents, XE).
➡ Activity Monitor
➡ Performance Monitor
➡ Data Collector (DC)
➡ Query Store (QS)
03. CATALOG AND MANAGEMENT SYSTEM VIEWS
➡ Most commonly used DMV and DMF categories.
04. DATABASE AND SERVER MONITORING
➡ Utilization of RAM, disks, processors, network interfaces
➡ Checking executed SQL queries
➡ Active sessions
➡ Recent connections
➡ Most expensive and blocked queries
➡ TEMPDB space
➡ Sessions using the most space in TEMPDB
➡ Resource allocation
05. PRINCIPLES OF QUERY OPTIMIZER OPERATION
06. PRINCIPLES OF INDEXES
➡ Row indexes and their types: CLUSTERED INDEX, NON-CLUSTERED INDEX
➡ Index selectivity index.
➡ Measuring the execution time of database operations based on the use of indexes
➡ Server suggestions for missing indexes
➡ Tables of type HEAP (STERTA).
➡ Columnar indexes: COLUMNSTORE INDEX
➡ COLUMNSTORE_ARCHIVE compression.
07. QUERY EXECUTION PLANS (QUERY EXECUTION PLAN).
➡ Estimated Execution Plan: Estimated Execution Plan
➡ Actual Execution Plan: Actual Execution Plan
➡ Running and reading query plans
➡ INDEX SCAN and INDEX SEEK operations.
08. STATISTICS (STATISTICS)
➡ Construction and operation principle of statistics
➡ Monitoring and maintenance of statistics
➡ Errors of cardinality estimation
➡ Types of statistics
09. MONITORING OF INDICES
➡ Fragmentation of indexes
➡ Reorganization and reconstruction of indexes
10. PARAMETER SNIFFING AND CODE RECOMPILATIONS
11. MOST COMMONLY USED PERFORMANCE DEGRADING CONSTRUCTS
Requirements
The training is designed for both database administrators and developers who want to expand their competencies to include diagnostics and performance troubleshooting in the area of SQL Server operations and applications running on it.
Trainees are required to have knowledge of the Windows environment and familiarity with the Microsoft SQL Server database environment.
21 Hours
Testimonials (5)
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
The thorough / hands-on knowledge the trainer has.
