{"id":742,"date":"2016-01-13T10:08:23","date_gmt":"2016-01-13T18:08:23","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=742"},"modified":"2017-04-13T09:19:31","modified_gmt":"2017-04-13T16:19:31","slug":"collection-of-baseline-scripts","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/","title":{"rendered":"Collection of Baseline Scripts"},"content":{"rendered":"<p>The topic of baselines in SQL Server is one that I&#8217;ve had an interest in for a long time.\u00a0 In fact, the very first session I ever gave back in 2011 was on baselines.\u00a0 I still believe they are incredibly important, and most of the data I capture is still the same, but I have tweaked a couple things over the years.\u00a0 I&#8217;m in the process of creating a set of baseline scripts that folks can use to automate the capture of this information, in the event that they do not have\/cannot afford a third-party monitoring tool (note, a monitoring tool such as <a href=\"https:\/\/www.sentryone.com\/platform\/sql-server-performance-monitoring\">SQL Sentry&#8217;s Performance Advisor<\/a> can make life WAY easier, but I know that not every can justify the need to management).\u00a0 For now, I&#8217;m starting with links to all relevant posts and then I&#8217;ll update this post once I have everything finalized.<\/p>\n<p>These scripts are just a starting point for what to monitor.\u00a0 One thing I like to point in our <a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/iepto2\/\">IEPTO2: Performance Tuning and Optimization<\/a> course is that there is A LOT of data you can capture related to your SQL Server environment.\u00a0 Your options include Performance Monitor (using Custom Data Collectors), queries via Extended Events or Trace (depending on version), and any data from the DMVs or system views within SQL Server. You have decide what to capture based on<\/p>\n<p style=\"padding-left: 30px;\">1) What problem you might be trying to solve in your environment, and<\/p>\n<p style=\"padding-left: 30px;\">2) What information is most important for you to have.\u00a0 Start simple, and then work your way up.<\/p>\n<p>Figure out the one or two most critical things to capture, and start there, and then add on.<\/p>\n<p>If you find there&#8217;s something missing from my scripts, let me know and I&#8217;ll try to get it added!<\/p>\n<p><strong>Monitoring in general<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/the-accidental-dba-tools-for-on-going-monitoring\/\">Tools for monitoring<\/a><\/li>\n<li><a href=\"http:\/\/sqldatapartners.com\/2016\/01\/27\/baselines\/\">Podcast Episode 28: How Do You Know There Is A Problem? Baselines!<\/a><\/li>\n<\/ul>\n<p><strong>Configuration Information<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sqlperformance.com\/2015\/02\/system-configuration\/proactive-sql-server-health-checks-3\">Instance and Database Settings<\/a><\/li>\n<\/ul>\n<p><strong>Disk and I\/O<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sqlperformance.com\/2014\/12\/io-subsystem\/proactive-sql-server-health-checks-1\">Available Disk Space and File Space<\/a><\/li>\n<li><a href=\"https:\/\/sqlperformance.com\/2013\/10\/t-sql-queries\/io-latency\">Virtual File Stats<\/a><\/li>\n<li><a href=\"https:\/\/www.sqlskills.com\/blogs\/erin\/the-accidental-dba-monitoring-disk-io\/\">Monitoring I\/O<\/a><\/li>\n<\/ul>\n<p><strong>Maintenance<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sqlperformance.com\/2014\/12\/sql-maintenance\/proactive-sql-server-health-checks-2\">Job run times<\/a><\/li>\n<\/ul>\n<p><strong>Errors<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sqlperformance.com\/2015\/07\/system-configuration\/proactive-sql-server-health-checks-4\">The ERRORLOG<\/a><\/li>\n<\/ul>\n<p><strong>Performance<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sqlperformance.com\/2015\/10\/sql-performance\/proactive-sql-server-health-checks-5\">Wait Statistics<\/a><\/li>\n<\/ul>\n<p><strong>Pluralsight<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-benchmarking\">SQL Server: Benchmarking and Baselining<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The topic of baselines in SQL Server is one that I&#8217;ve had an interest in for a long time.\u00a0 In fact, the very first session I ever gave back in 2011 was on baselines.\u00a0 I still believe they are incredibly important, and most of the data I capture is still the same, but I have [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Collection of Baseline Scripts - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Looking for a set of baseline scripts to capture information about your SQL Server? Then start here with this list of links to get you rolling!\" \/>\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.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Collection of Baseline Scripts - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Looking for a set of baseline scripts to capture information about your SQL Server? Then start here with this list of links to get you rolling!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-13T18:08:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:19:31+00:00\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/\",\"name\":\"Collection of Baseline Scripts - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2016-01-13T18:08:23+00:00\",\"dateModified\":\"2017-04-13T16:19:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Looking for a set of baseline scripts to capture information about your SQL Server? Then start here with this list of links to get you rolling!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Collection of Baseline Scripts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Collection of Baseline Scripts - Erin Stellato","description":"Looking for a set of baseline scripts to capture information about your SQL Server? Then start here with this list of links to get you rolling!","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.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/","og_locale":"en_US","og_type":"article","og_title":"Collection of Baseline Scripts - Erin Stellato","og_description":"Looking for a set of baseline scripts to capture information about your SQL Server? Then start here with this list of links to get you rolling!","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/","og_site_name":"Erin Stellato","article_published_time":"2016-01-13T18:08:23+00:00","article_modified_time":"2017-04-13T16:19:31+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/","name":"Collection of Baseline Scripts - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2016-01-13T18:08:23+00:00","dateModified":"2017-04-13T16:19:31+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Looking for a set of baseline scripts to capture information about your SQL Server? Then start here with this list of links to get you rolling!","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/collection-of-baseline-scripts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Collection of Baseline Scripts"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/742"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=742"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/742\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}