{"id":3436,"date":"2017-01-09T10:42:25","date_gmt":"2017-01-09T10:42:25","guid":{"rendered":"http:\/\/fusionsol.wp.knows.live\/?page_id=3436"},"modified":"2025-04-11T08:50:00","modified_gmt":"2025-04-11T01:50:00","slug":"od10987a-performance","status":"publish","type":"page","link":"https:\/\/www.fusionsol.com\/en\/od10987a-performance\/","title":{"rendered":"OD10987A: Performance Tuning and Optimizing SQL Databases"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><div class=\"vc_row wpb_row vc_row-fluid dt-default\" style=\"margin-top: 0px;margin-bottom: 0px\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h1 lang=\"en\"><span class=\"course-detail-id\">Course OD10987A:<\/span>Performance Tuning and Optimizing SQL Databases<\/h1>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid dt-default\" style=\"margin-top: 0px;margin-bottom: 0px\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_tour wpb_content_element  tab-style-one\" data-interval=\"0\">\n\t\t<div class=\"wpb_wrapper wpb_tour_tabs_wrapper ui-tabs vc_clearfix\">\n\t\t\t<ul class=\"wpb_tabs_nav ui-tabs-nav vc_clearfix text-big\"><li><a href=\"#tab-8dd578e1-a42e-1\">Choose how you want to learn: online or in a classroom<\/a><\/li><li><a href=\"#tab-3a58faf0-f326-8\">About this course<\/a><\/li><li><a href=\"#tab-1483952452641-2-10\">Overview<\/a><\/li><li><a href=\"#tab-1483952471897-3-3\">Course details<\/a><\/li><li><a href=\"#tab-1483952507646-4-7\">Prerequisites<\/a><\/li><li><a href=\"#tab-1483952524804-5-6\">Community Share this page Facebook Twitter LinkedIn Email<\/a><\/li><\/ul>\n\t<div id=\"tab-8dd578e1-a42e-1\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<table class=\"course-moc-on-demand\">\n<thead>\n<tr>\n<th style=\"text-align: left;\" scope=\"col\">Compare learning environments<\/th>\n<th scope=\"col\">\n<p style=\"text-align: center;\"><strong>On-demand training<\/strong><\/p>\n<p style=\"text-align: center;\">Learn more<\/p>\n<\/th>\n<td style=\"text-align: center;\"><\/td>\n<th scope=\"col\">\n<p style=\"text-align: center;\"><strong>Classroom training<\/strong><\/p>\n<p style=\"text-align: center;\"><a class=\"mscom-link\" href=\"https:\/\/www.microsoft.com\/en-us\/learning\/partners.aspx\">Learn more<\/a><\/p>\n<\/th>\n<\/tr>\n<\/thead>\n<tfoot>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Find a Microsoft Learning Partner<\/th>\n<td style=\"text-align: center;\">Find an on-demand training partner<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td style=\"text-align: center;\"><a class=\"mscom-link msl-button msl-button-blue\" href=\"https:\/\/www.microsoft.com\/en-us\/learning\/find-partner.aspx\">Find a classroom training partner<\/a><\/td>\n<\/tr>\n<\/tfoot>\n<tbody>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Anytime access<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Anywhere access to recorded instructor<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Microsoft official training content<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">In-depth training<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Hands-on labs<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">SATV redemption<\/th>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Ask instructor questions in person<\/th>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Attend live class in person<\/th>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Attend live class remotely<\/th>\n<td class=\"no\" style=\"text-align: center;\">No<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td class=\"yes\" style=\"text-align: center;\">Yes<\/td>\n<\/tr>\n<tr>\n<th style=\"text-align: left;\" scope=\"row\">Time commitment<\/th>\n<td style=\"text-align: center;\">Self-paced<br \/>\n(3 month access)<\/td>\n<td style=\"text-align: center;\"><\/td>\n<td style=\"text-align: center;\">4 days<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-3a58faf0-f326-8\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<table>\n<tbody>\n<tr>\n<td>Audience(s):<\/td>\n<td>IT Professionals<\/td>\n<\/tr>\n<tr>\n<td>Technology:<\/td>\n<td>Microsoft SQL Server<\/td>\n<\/tr>\n<tr>\n<td>Level:<\/td>\n<td>300<\/td>\n<\/tr>\n<tr>\n<td>This Revision:<\/td>\n<td>A<\/td>\n<\/tr>\n<tr>\n<td>\n<div>Delivery method:<\/div>\n<\/td>\n<td lang=\"en\">Classroom<\/td>\n<\/tr>\n<tr>\n<td>Length:<\/td>\n<td>2 days<\/td>\n<\/tr>\n<tr>\n<td>Language(s):<\/td>\n<td>English<\/td>\n<\/tr>\n<tr>\n<td>First published:<\/td>\n<td>20 October 2016<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952452641-2-10\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p><b>About this course<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.<\/span><\/p>\n<p><b>Audience profile<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.<\/span><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.<\/span><\/p>\n<p><b>At course completion<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this course, students will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the high level architectural overview of SQL Server and its various components.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the SQL Server execution model, waits and queues.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe <\/span><span style=\"font-style: inherit; font-weight: inherit;\">core I\/O concepts, Storage Area Networks and performance testing.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe architectural concepts and best practices related to data files for user databases and TempDB.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe <\/span><span style=\"font-style: inherit; font-weight: inherit;\">architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Explain data collection strategy and techniques to analyze collected data.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Understand techniques to identify and diagnose bottlenecks to improve overall performance.<\/span><\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952471897-3-3\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p><b>Course Outline<\/b><b>Module 1: SQL Server Architecture, Scheduling, and Waits<\/b>This module covers high level architectural overview of SQL Server and its various components. It dives deep into SQL Server execution model, waits and queues.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">SQL Server Components and SQL OS<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Windows Scheduling vs SQL Scheduling<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Waits and Queues<\/span><\/li>\n<\/ul>\n<p><b>Lab : SQL Server Architecture, Scheduling, and Waits<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the SQL Server components and SQL OS<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the differences between Windows Scheduling and SQL scheduling<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe waits and queues<\/span><\/li>\n<\/ul>\n<p><b>Module 2: SQL Server I\/O<\/b>This module covers core I\/O concepts, Storage Area Networks and performance testing. It focuses on SQL Server I\/O operations and how to test storage performance.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Core Concepts<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Storage Solutions<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">I\/O Setup and Testing<\/span><\/li>\n<\/ul>\n<p><b>Lab : Testing Storage Performance<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the core concepts of SQL I\/O<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe storage solutions<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Setup and test I\/O<\/span><\/li>\n<\/ul>\n<p><b>Module 3: Database Structures<\/b>This module covers Database Structures, Data File and TempDB Internals. It focuses on architectural concepts and best practices related to data files for user databases and TempDB.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Database Structure Internals<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Data File Internals<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">TempDB Internals<\/span><\/li>\n<\/ul>\n<p><b>Lab : Database Structures<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the internal setup of database structures<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the internal setup of data files.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the internal setup of TempDB<\/span><\/li>\n<\/ul>\n<p><b>Module 4: SQL Server Memory<\/b>This module covers Windows and SQL Server Memory internals. It focuses on architectural concepts and best practices related to SQL Server Memory Configuration.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Windows Memory<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">SQL Server Memory<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">In-Memory OLTP<\/span><\/li>\n<\/ul>\n<p><b>Lab : SQL Server Memory<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the components of Windows memory<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the components of SQL Server memory<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe In-Memory OLTP<\/span><\/li>\n<\/ul>\n<p><b>Module 5: Concurrency and Transactions<\/b>This module covers Transactions and Locking Internals. It focuses on architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Concurrency and Transactions<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Locking Internals<\/span><\/li>\n<\/ul>\n<p><b>Lab : Concurrency and Transactions<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Explain concurrency and transactions<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe locking<\/span><\/li>\n<\/ul>\n<p><b>Module 6: Statistics and Index Internals<\/b>This module covers Statistics and Index Internals. It focuses on architectural concepts and best practices related to Statistics and Indexes.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Statistics Internals and Cardinality Estimation<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Index Internals<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Columnstore Indexes<\/span><\/li>\n<\/ul>\n<p><b>Lab : Statistics and index Internals<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe statistics internals<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Explain cardinality estimation<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe why you would use Columnstore indexes and be able to implement one<\/span><\/li>\n<\/ul>\n<p><b>Module 7: Query Execution and Query Plan Analysis<\/b>This module covers Query Execution and Query Plan Analysis. It focuses on architectural concepts of the Optimizer and how to identify and fix query plan issues.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Query execution and optimizer internals<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Analyzing query plans<\/span><\/li>\n<\/ul>\n<p><b>Lab : Query execution and query plan analysis<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe query execution and optimizer<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Analyze query plans and resolve common issues<\/span><\/li>\n<\/ul>\n<p><b>Module 8: Plan Caching and Recompilation<\/b>This module covers Plan Caching and Recompilation. It focuses on architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Plan cache internals<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshooting plan cache issues<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Query store<\/span><\/li>\n<\/ul>\n<p><b>Lab : Plan caching and recompilation<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe plan cache<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot plan cache issues<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe query store and why you would use it<\/span><\/li>\n<\/ul>\n<p><b>Module 9: Extended Events<\/b>This module covers Extended Events. It focuses on architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Extended events core concepts<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Implementing extended events<\/span><\/li>\n<\/ul>\n<p><b>Lab : Extended events<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe the core concepts of extended events<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Implement extended events<\/span><\/li>\n<\/ul>\n<p><b>Module 10: Monitoring, Tracing, and Baselining<\/b>This module covers tools and techniques to monitor, trace and baseline SQL Server performance data. It focuses on data collection strategy and techniques to analyze collected data.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Monitoring and tracing<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Baselining and benchmarking<\/span><\/li>\n<\/ul>\n<p><b>Lab : Monitoring, Tracing and Baselining<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe various options for monitoring and tracing<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Describe various options for benchmarking and baselining<\/span><\/li>\n<\/ul>\n<p><b>Module 11: Troubleshooting Common Performance Issues<\/b>This module covers common performance bottlenecks related to CPU, Memory, IO, TempDB and Concurrency. It focuses on techniques to identify and diagnose bottlenecks to improve overall performance.<b>Lessons<\/b><\/p>\n<ul>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot CPU performance<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot memory performance<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot I\/O performance<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot Concurrency performance<\/span><\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot TempDB performance<\/span><\/li>\n<\/ul>\n<p><b>Lab : Troubleshooting common performance issues<\/b><\/p>\n<p style=\"font-style: inherit; font-weight: inherit;\"><span style=\"font-style: inherit; font-weight: inherit;\">After completing this module, you will be able to:<\/span><\/p>\n<ul style=\"font-style: inherit; font-weight: inherit;\">\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Troubleshoot common performance issues<\/span><\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952507646-4-7\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">In addition to their professional experience, students who attend this training should already have the following technical knowledge:<\/span>\n<ul>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Basic knowledge of the Microsoft Windows operating system and its core functionality.<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Working knowledge of database administration and maintenance<\/span><\/li>\n<li><span style=\"font-style: inherit; font-weight: inherit;\">Working knowledge of Transact-SQL.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n\n\t<div id=\"tab-1483952524804-5-6\" class=\"wpb_tab ui-tabs-panel wpb_ui-tabs-hide vc_clearfix\">\n\t\t\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li>Looking for training resources, events and advice from peers? Join the <a href=\"http:\/\/borntolearn.mslearn.net\/\">Microsoft Training and Certification Community<\/a>.Preparing for an exam now? Find your <a href=\"http:\/\/borntolearn.mslearn.net\/certification\/\">Microsoft Certification Study Group<\/a>.Talk to us on these social networks:\n<ul>\n<li>Facebook<\/li>\n<li>Twitter<\/li>\n<li><a href=\"http:\/\/www.linkedin.com\/groups\/Microsoft-Learning-3183354\">LinkedIn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<\/div>\n<div class=\"wpb_tour_next_prev_nav vc_clearfix\"> <span class=\"wpb_prev_slide\"><a href=\"#prev\" title=\"Previous tab\">Previous tab<\/a><\/span> <span class=\"wpb_next_slide\"><a href=\"#next\" title=\"Next tab\">Next tab<\/a><\/span><\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Course OD10987A:Performance Tuning and Optimizing SQL Databases Choose how you want to learn: online or in a classroomAbout this courseOverviewCourse detailsPrerequisitesCommunity Share this page Facebook Twitter LinkedIn Email Compare learning environments On-demand training Learn more Classroom training Learn more Find a Microsoft Learning Partner Find an on-demand training partner Find a classroom training partner Anytime&hellip;<\/p>","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3436","page","type-page","status-publish","hentry","description-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fusion Solution Co.,Ltd. \u2013 ARTICLE<\/title>\n<meta name=\"description\" content=\"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fusionsol.com\/en\/od10987a-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fusion Solution Co.,Ltd. \u2013 ARTICLE\" \/>\n<meta property=\"og:description\" content=\"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fusionsol.com\/en\/od10987a-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Fusion Solution\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/fusion.solution\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-11T01:50:00+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/od10987a-performance\\\/\",\"url\":\"https:\\\/\\\/www.fusionsol.com\\\/od10987a-performance\\\/\",\"name\":\"Fusion Solution Co.,Ltd. \u2013 ARTICLE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/#website\"},\"datePublished\":\"2017-01-09T10:42:25+00:00\",\"dateModified\":\"2025-04-11T01:50:00+00:00\",\"description\":\"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/od10987a-performance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fusionsol.com\\\/od10987a-performance\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/od10987a-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fusionsol.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OD10987A: Performance Tuning and Optimizing SQL Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/#website\",\"url\":\"https:\\\/\\\/www.fusionsol.com\\\/\",\"name\":\"Fusion Solution\",\"description\":\"Business Innovation Provider\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fusionsol.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/#organization\",\"name\":\"Fusion Solution\",\"url\":\"https:\\\/\\\/www.fusionsol.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.fusionsol.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/04\\\/FusionLogo.png\",\"contentUrl\":\"https:\\\/\\\/www.fusionsol.com\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/04\\\/FusionLogo.png\",\"width\":249,\"height\":249,\"caption\":\"Fusion Solution\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fusionsol.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/fusion.solution\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCYhatfvclBLCGPdNCyX7EZg\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fusion Solution Co.,Ltd. \u2013 ARTICLE","description":"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fusionsol.com\/en\/od10987a-performance\/","og_locale":"en_US","og_type":"article","og_title":"Fusion Solution Co.,Ltd. \u2013 ARTICLE","og_description":"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.","og_url":"https:\/\/www.fusionsol.com\/en\/od10987a-performance\/","og_site_name":"Fusion Solution","article_publisher":"https:\/\/www.facebook.com\/fusion.solution\/","article_modified_time":"2025-04-11T01:50:00+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.fusionsol.com\/od10987a-performance\/","url":"https:\/\/www.fusionsol.com\/od10987a-performance\/","name":"Fusion Solution Co.,Ltd. \u2013 ARTICLE","isPartOf":{"@id":"https:\/\/www.fusionsol.com\/#website"},"datePublished":"2017-01-09T10:42:25+00:00","dateModified":"2025-04-11T01:50:00+00:00","description":"10th Years Development Business Solution. We\u2019re still the same great company that has been there for you during those late nights.","breadcrumb":{"@id":"https:\/\/www.fusionsol.com\/od10987a-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fusionsol.com\/od10987a-performance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fusionsol.com\/od10987a-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fusionsol.com\/"},{"@type":"ListItem","position":2,"name":"OD10987A: Performance Tuning and Optimizing SQL Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.fusionsol.com\/#website","url":"https:\/\/www.fusionsol.com\/","name":"Fusion Solution","description":"Business Innovation Provider","publisher":{"@id":"https:\/\/www.fusionsol.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fusionsol.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fusionsol.com\/#organization","name":"Fusion Solution","url":"https:\/\/www.fusionsol.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fusionsol.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.fusionsol.com\/wp-content\/uploads\/sites\/2\/2020\/04\/FusionLogo.png","contentUrl":"https:\/\/www.fusionsol.com\/wp-content\/uploads\/sites\/2\/2020\/04\/FusionLogo.png","width":249,"height":249,"caption":"Fusion Solution"},"image":{"@id":"https:\/\/www.fusionsol.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/fusion.solution\/","https:\/\/www.youtube.com\/channel\/UCYhatfvclBLCGPdNCyX7EZg"]}]}},"_links":{"self":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages\/3436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/comments?post=3436"}],"version-history":[{"count":6,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages\/3436\/revisions"}],"predecessor-version":[{"id":32385,"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/pages\/3436\/revisions\/32385"}],"wp:attachment":[{"href":"https:\/\/www.fusionsol.com\/en\/wp-json\/wp\/v2\/media?parent=3436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}