{"id":174,"date":"2011-06-09T16:30:08","date_gmt":"2011-06-09T20:30:08","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=174"},"modified":"2014-11-13T15:24:05","modified_gmt":"2014-11-13T20:24:05","slug":"presentation-materials-sql-server-performance-monitoring-basics","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/","title":{"rendered":"Presentation Materials &#8211; SQL Server Performance Monitoring Basics"},"content":{"rendered":"<div>\n<h3>SQL Server Performance Monitoring Basics<\/h3>\n<\/div>\n<h4>Will my SQL Server keep up with the load of tomorrow?<\/h4>\n<p>This class will give you tools that enable you to see performance trends and identify problems before they become problems.\n<\/p>\n<p>\nOn the way to this goal we will stop at these stations:\n<\/p>\n<ul>\n<li> An introduction to the ACID properties with a deeper look at Isolation including an introduction to locks and latches.<\/li>\n<li> A short look at the query lifecycle with the query compilation and the three query execution phases.<\/li>\n<li>A visit to blocking, showing ways to monitor for blocking occurrences.<\/li>\n<li> An explanation of performance related DMVs.<\/li>\n<\/ul>\n<p>\nThe class closes out by introducing a tool that allows monitoring the covered concepts on all your servers from a central place, the Management Data Warehouse.<\/p>\n<p>After attending the class, you will be able to:<\/p>\n<ul>\n<li>describe ACID and its components and explain what its impact on concurrency is<\/li>\n<li>differentiate between locks and latches<\/li>\n<li>explain the query lifecycle<\/li>\n<li>identify blocked and blocking sessions and their SQL statements<\/li>\n<li> use DMVs to get a picture of your server health<\/li>\n<li>monitor important SQL Server performance metrics over time using the Management Data Warehouse<\/li>\n<li>see important trends in your performance metrics<\/li>\n<\/ul>\n<h3>Downloads<\/h3>\n<ul>\n<li>\n<a href=\"http:\/\/downloads.sqlity.net\/PerfMonitoringBasics.zip\">Slides and SQL Code<\/a>\n<\/li>\n<li>\nSqlQueryStress: <a href=\"http:\/\/www.datamanipulation.net\/sqlquerystress\/\"  target=\"_OutsideSources\">www.datamanipulation.net\/sqlquerystress<\/a>\n<\/li>\n<\/ul>\n<h3>Other Resources<\/h3>\n<h5>Books<\/h5>\n<ul>\n<li>\n<a href=\"http:\/\/www.amazon.com\/gp\/product\/0470484284\/ref=as_li_ss_tl?ie=UTF8&tag=sqlitynet-20&linkCode=as2&camp=217145&creative=399369&creativeASIN=0470484284\"  target=\"_OutsideSources\">Professional SQL Server 2008 Internals and Troubleshooting<\/a><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\" \/>\n<\/li>\n<li>\n<a href=\"http:\/\/www.amazon.com\/gp\/product\/0735626243\/ref=as_li_ss_tl?ie=UTF8&tag=sqlitynet-20&linkCode=as2&camp=217145&creative=399369&creativeASIN=0735626243\"  target=\"_OutsideSources\">Microsoft\u00ae SQL Server\u00ae 2008 Internals (Pro - Developer)<\/a><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0735626243&camp=217145&creative=399369\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\" \/>\n<\/li>\n<\/ul>\n<h5>White Papers<\/h5>\n<ul>\n<li>\n<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/cc966413.aspx\"  target=\"_OutsideSources\">SQL Server 2005 Waits and Queues - Microsoft TechNet<\/a>\n<\/li>\n<\/ul>\n<h5>Other Resources<\/h5>\n<ul>\n<li>\n<a href=\"http:\/\/www.microsoft.com\/downloads\/en\/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en\"  target=\"_OutsideSources\">SQL Server 2005 Performance Dashboard Reports<\/a>\n<\/li>\n<li>\nFixing <a href=\"http:\/\/blogs.technet.com\/b\/rob\/archive\/2009\/02\/18\/performance-dashboard-reports-for-sql-server-2008.aspx\"  target=\"_OutsideSources\">Performance Dashboard Reports for SQL Server 2008<\/a>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Performance Monitoring Basics Will my SQL Server keep up with the load of tomorrow? This class will give you tools that enable you to see performance trends and identify problems before they become problems. On the way to <a href=\"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/\">[more&#8230;]<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[11],"tags":[],"class_list":["post-174","post","type-post","status-publish","format-standard","hentry","category-presentations"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Presentation Materials - SQL Server Performance Monitoring Basics - sqlity.net<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Presentation Materials - SQL Server Performance Monitoring Basics - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"SQL Server Performance Monitoring Basics Will my SQL Server keep up with the load of tomorrow? This class will give you tools that enable you to see performance trends and identify problems before they become problems. On the way to [more...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2011-06-09T20:30:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T20:24:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"Presentation Materials &#8211; SQL Server Performance Monitoring Basics\",\"datePublished\":\"2011-06-09T20:30:08+00:00\",\"dateModified\":\"2014-11-13T20:24:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/\"},\"wordCount\":255,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.assoc-amazon.com\\\/e\\\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369\",\"articleSection\":[\"Presentations\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/\",\"name\":\"Presentation Materials - SQL Server Performance Monitoring Basics - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.assoc-amazon.com\\\/e\\\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369\",\"datePublished\":\"2011-06-09T20:30:08+00:00\",\"dateModified\":\"2014-11-13T20:24:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.assoc-amazon.com\\\/e\\\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369\",\"contentUrl\":\"http:\\\/\\\/www.assoc-amazon.com\\\/e\\\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/174\\\/presentation-materials-sql-server-performance-monitoring-basics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Presentation Materials &#8211; SQL Server Performance Monitoring Basics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Presentation Materials - SQL Server Performance Monitoring Basics - sqlity.net","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:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/","og_locale":"en_US","og_type":"article","og_title":"Presentation Materials - SQL Server Performance Monitoring Basics - sqlity.net","og_description":"SQL Server Performance Monitoring Basics Will my SQL Server keep up with the load of tomorrow? This class will give you tools that enable you to see performance trends and identify problems before they become problems. On the way to [more...]","og_url":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2011-06-09T20:30:08+00:00","article_modified_time":"2014-11-13T20:24:05+00:00","og_image":[{"url":"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369","type":"","width":"","height":""}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"Presentation Materials &#8211; SQL Server Performance Monitoring Basics","datePublished":"2011-06-09T20:30:08+00:00","dateModified":"2014-11-13T20:24:05+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/"},"wordCount":255,"commentCount":1,"image":{"@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#primaryimage"},"thumbnailUrl":"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369","articleSection":["Presentations"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/","url":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/","name":"Presentation Materials - SQL Server Performance Monitoring Basics - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#primaryimage"},"thumbnailUrl":"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369","datePublished":"2011-06-09T20:30:08+00:00","dateModified":"2014-11-13T20:24:05+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#primaryimage","url":"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369","contentUrl":"http:\/\/www.assoc-amazon.com\/e\/ir?t=&l=as2&o=1&a=0470484284&camp=217145&creative=399369"},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/174\/presentation-materials-sql-server-performance-monitoring-basics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"Presentation Materials &#8211; SQL Server Performance Monitoring Basics"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-2O","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/174\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}