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.
Testimonials (9)
Interakcja z prowadzącym, możliwość zadawania pytań na gorąco
Grzegorz Ziegert
Course - Administration with Powershell
database optimization, dedicated approach, ability to ask questions, insight/assessment of our database
Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Transfer of knowledge using simple and understandable examples.
Katsiaryna
Course - SQL language in MSSQL
Machine Translated
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
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).