{"id":545,"date":"2013-02-04T06:24:59","date_gmt":"2013-02-04T14:24:59","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=545"},"modified":"2013-02-04T06:27:32","modified_gmt":"2013-02-04T14:27:32","slug":"sql-server-baselines-series-on-sqlservercentral-com","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/","title":{"rendered":"SQL Server Baselines Series on SQLServerCentral.com"},"content":{"rendered":"<p>Today the fourth article in my baselines series was published on SQLServerCentral.com.\u00a0 Listed below are the links to all of the articles, and I\u2019ve decided to continue the series on my blog here.\u00a0 I truly believe that every SQL Server environment can benefit from having baselines.\u00a0 I say that all the time, I know, and people seem to agree with me \ud83d\ude42\u00a0 But yet there are <i>many<\/i> systems out there that don\u2019t have baseline data.\u00a0 The biggest roadblock that I see is deciding <i>what<\/i> to capture, and then writing the scripts to capture what you want.\u00a0 The goal of the series I wrote for SQLServerCentral.com was to provide background about why baselines are important, and provide a set of scripts to get started.\u00a0 The value of baselines may seem obvious to you, but for new DBAs the benefits may not be as apparent, so taking a few minutes to step through them is useful.\u00a0 The scripts I provide are straight-forward and there\u2019s a reason for that: It\u2019s not rocket science.\u00a0 Capturing baseline data is really easy to do, and my goal is to provide scripts so DBAs can quickly and easily start capturing data, and hopefully once people realize how simple it was, they will develop their own scripts.<\/p>\n<p>But just because I\u2019ve provided a few scripts doesn\u2019t mean I\u2019m done.\u00a0 I am going to continue to develop and post scripts here that DBAs can use to set up baselines in their own environment. I recognize that there are some excellent applications available from third party vendors that will capture baseline data, and if your company has the budget to purchase such an application, I would highly recommend doing so. My scripts are not a replacement for any of those applications. But for those of you who don\u2019t have the budget, or perhaps need some data in order to make a case for <i>why<\/i> you need one of those applications, these scripts will get you started.<\/p>\n<p>If you have any feedback about the scripts, or requests for what I write next, feel free to email me! The scripts are a work in progress and I plan to continually work to make them better.<\/p>\n<p><a href=\"http:\/\/www.sqlservercentral.com\/articles\/baselines\/94657\/\">5 Reasons You Must Start Capturing Baseline Data<\/a><\/p>\n<p><a href=\"http:\/\/www.sqlservercentral.com\/articles\/baselines\/94656\/\">Back to Basics: Capturing Baselines on Production SQL Servers<\/a><\/p>\n<p><a href=\"http:\/\/www.sqlservercentral.com\/articles\/baselines\/96059\/\">Capturing Baselines on SQL Server: Where\u2019s My Space?<\/a><\/p>\n<p><a href=\"http:\/\/www.sqlservercentral.com\/articles\/baselines\/96270\/\">Capturing Baselines on SQL Server: Wait Statistics<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today the fourth article in my baselines series was published on SQLServerCentral.com.\u00a0 Listed below are the links to all of the articles, and I\u2019ve decided to continue the series on my blog here.\u00a0 I truly believe that every SQL Server environment can benefit from having baselines.\u00a0 I say that all the time, I know, and [&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":[20],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Baselines: Articles on SQLServerCentral.com - Erin Stellato<\/title>\n<meta name=\"description\" content=\"In this post are links for the four articles I wrote about SQL Server Baselines on SQLServerCentral.com. I will continue the series on my blog here.\" \/>\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\/sql-server-baselines-series-on-sqlservercentral-com\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Baselines: Articles on SQLServerCentral.com - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"In this post are links for the four articles I wrote about SQL Server Baselines on SQLServerCentral.com. I will continue the series on my blog here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-04T14:24:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-04T14:27:32+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\/sql-server-baselines-series-on-sqlservercentral-com\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/\",\"name\":\"SQL Server Baselines: Articles on SQLServerCentral.com - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2013-02-04T14:24:59+00:00\",\"dateModified\":\"2013-02-04T14:27:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"In this post are links for the four articles I wrote about SQL Server Baselines on SQLServerCentral.com. I will continue the series on my blog here.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Baselines Series on SQLServerCentral.com\"}]},{\"@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":"SQL Server Baselines: Articles on SQLServerCentral.com - Erin Stellato","description":"In this post are links for the four articles I wrote about SQL Server Baselines on SQLServerCentral.com. I will continue the series on my blog here.","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\/sql-server-baselines-series-on-sqlservercentral-com\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Baselines: Articles on SQLServerCentral.com - Erin Stellato","og_description":"In this post are links for the four articles I wrote about SQL Server Baselines on SQLServerCentral.com. I will continue the series on my blog here.","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/","og_site_name":"Erin Stellato","article_published_time":"2013-02-04T14:24:59+00:00","article_modified_time":"2013-02-04T14:27:32+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\/sql-server-baselines-series-on-sqlservercentral-com\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/","name":"SQL Server Baselines: Articles on SQLServerCentral.com - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2013-02-04T14:24:59+00:00","dateModified":"2013-02-04T14:27:32+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"In this post are links for the four articles I wrote about SQL Server Baselines on SQLServerCentral.com. I will continue the series on my blog here.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/sql-server-baselines-series-on-sqlservercentral-com\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"SQL Server Baselines Series on SQLServerCentral.com"}]},{"@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\/545"}],"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=545"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/545\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}