{"id":1477,"date":"2014-02-27T12:38:51","date_gmt":"2014-02-27T12:38:51","guid":{"rendered":"http:\/\/blog.eginnovations.com\/?p=1477"},"modified":"2022-11-27T11:30:49","modified_gmt":"2022-11-27T16:30:49","slug":"sql-server-monitoring-tools","status":"publish","type":"post","link":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/","title":{"rendered":"SQL Server Monitoring"},"content":{"rendered":"<h2><span class=\"ez-toc-section\" id=\"Monitoring_Tools_to_Control_Server_Sprawl\"><\/span>Monitoring Tools to Control Server Sprawl<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">According to the Microsoft SQL Server team on <a href=\"http:\/\/bit.ly\/1k2MPal\" rel=\"nofollow\">TechNet<\/a> , SQL Server is world\u2019s most widely deployed database. In its October 2013 magic quadrant, Gartner identified Microsoft as a leader, second only to Oracle.<\/p>\n<p style=\"text-align: center;\"><b>Magic Quadrant for Operational Database Management Systems<\/b><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1506\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450\" alt=\"Database Gartner Magic Quadrant1\" width=\"450\" height=\"450\" border=\"0\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg 608w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1-150x150.jpg 150w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1-300x300.jpg 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1-310x310.jpg 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1-140x140.jpg 140w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><i style=\"line-height: 1.5em; font-size: 8pt;\">Source: Gartner (October 2013) &#8211; <a style=\"line-height: 1.5em; font-size: 8pt;\" href=\"http:\/\/gtnr.it\/IKDu9G\" rel=\"nofollow\">http:\/\/gtnr.it\/IKDu9G<\/a><\/i><\/p>\n<p style=\"text-align: justify;\">SQL Server\u2019s success is attributed to multiple factors:<\/p>\n<ul style=\"text-align: Left;\">\n<li>It is simple to install and easy to maintain.<\/li>\n<li>Several third party applications and development tools support SQL server.<\/li>\n<li>It has a wide array of functionalities and with the scalability enhancements in its latest releases, it represents a good option for enterprises.<\/li>\n<li>Microsoft also provides lower cost, service-provider friendly licensing that makes deployment of SQL easy.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"SQL_Server_Proliferation_Results_in_Sprawl\"><\/span><b style=\"line-height: 1.5em;\">SQL Server Proliferation Results in Sprawl<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">The very success of SQL server has contributed to a high degree of proliferation, leading to SQL server sprawl.\u00a0 Almost all applications today use a database server for data storage. Because of its licensing and ease of use, many packaged applications and in-house applications use SQL server as the backend. To minimize conflict between applications, many a times, a separate SQL server or SQL instance is used for each application.<\/p>\n<p style=\"text-align: justify;\">Since it is simple to deploy, application owners themselves often deploy and use SQL server, instead of depending on a database administration team. Over a period, this uncoordinated deployment has resulted in a proliferation of SQL server instances, leading to SQL sprawl.<\/p>\n<p style=\"text-align: justify;\">Yet another artifact of this evolution is that an enterprise often has multiple versions of SQL server running in parallel.\u00a0 A recent survey conducted by <a href=\"http:\/\/bit.ly\/1cGMys9\" rel=\"nofollow\">Paul S. Randal<\/a> shows that enterprises are still running several older versions of SQL server. In fact, as the table below reveals 45% of enterprises still have SQL Server 2000 deployed!<\/p>\n<p align=\"center\"><b>What\u2019s the oldest version of SQL Server that you have in production?<\/b><\/p>\n<p align=\"center\"><a href=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/oldest-version-of-sql.jpg\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1491\" src=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/oldest-version-of-sql.jpg\" alt=\"SQL server monitoring \u2013 older versions of SQL\" width=\"450\" height=\"186\" border=\"0\" srcset=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/oldest-version-of-sql.jpg 598w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/oldest-version-of-sql-300x124.jpg 300w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/oldest-version-of-sql-310x129.jpg 310w, https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/oldest-version-of-sql-140x58.jpg 140w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><i style=\"line-height: 1.5em; font-size: 8pt;\">Source: SQLSkills.com &#8211; <\/i><a style=\"line-height: 1.5em; font-size: 8pt;\" href=\"http:\/\/bit.ly\/1dnRpvj\" rel=\"nofollow\"><i>http:\/\/bit.ly\/1dnRpvj<\/i><\/a><\/p>\n<p style=\"text-align: justify;\">What makes the problem worse is the fact that often, when an application is decommissioned, the database server it uses has to be manually decommissioned. This also results in SQL server instances being left running but not used.<\/p>\n<p style=\"text-align: justify;\">From a resource usage perspective, for optimal performance, SQL server has been designed to use up all of the memory available on the servers (or VMs) that it is hosted on. If there are unused instances of\u00a0 SQL server running, these will unnecessarily take up a lot of the memory resources. In environments where SQL server is deployed on virtual machines, the bloated memory usage of unused SQL instances could even impact the performance of applications hosted on other virtual machines.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"The_Need_for_Unified_Monitoring_of_Microsoft_SQL_Server\"><\/span><b>The Need for Unified Monitoring of Microsoft SQL Server<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">To manage SQL server in an enterprise, the IT team needs to be able to:<\/p>\n<ul style=\"text-align: left;\">\n<li>Automatically discover all the systems where SQL server is running;<\/li>\n<li>Be able to monitor all the SQL instances, to determine ones that are least used or rarely used;<\/li>\n<li>For the ones that are in use, determine if the resources allocated for each instance are optimal or not.<\/li>\n<li>Measure the performance of each SQL server instance to determine the availability and responsiveness of each instance.<\/li>\n<li>Have a consistent way to monitor different versions of SQL server, so administrators do not have to learn different tools for each version.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">eG Enterprise provides IT administrators a single, integrated monitoring solution using which they can monitor, diagnose and report on the performance of SQL Server across all of the commonly deployed versions and in a consistent manner. SQL versions 7.0, 2000, 2005, 2008, and 2012 are supported. \u00a0Monitoring of named and port-based SQL instances is supported and SQL clusters can also be monitored from the same console.\u00a0 IT administrators also have the option of monitoring SQL Server in an agent based or agentless manner. For more information on the eG SQL monitor, see <a href=\"https:\/\/www.eginnovations.com\/supported-technologies\/mysql-monitoring-performance-management\">https:\/\/www.eginnovations.com\/supported-technologies\/mysql-monitoring-performance-management<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Monitoring Tools to Control Server Sprawl According to the Microsoft SQL Server team on TechNet , SQL Server is world\u2019s most widely deployed database. In its October 2013 magic quadrant, Gartner identified Microsoft as a leader, second only to Oracle. Magic Quadrant for Operational Database Management Systems Source: Gartner (October 2013) &#8211; http:\/\/gtnr.it\/IKDu9G SQL Server\u2019s [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"categories":[366],"tags":[126,1844,183,184,1846,1847,240,1845,1730,241],"class_list":["post-1477","post","type-post","status-publish","format-standard","hentry","category-end-to-end-monitoring-e2e","tag-database-monitoring","tag-eg-enterprise-sql-monitoring","tag-microsoft-sql-server","tag-microsoft-sql-server-performance","tag-monitoring-ms-sql-server","tag-ms-sql-server-monitoring","tag-sql-monitoring","tag-sql-monitoring-tool","tag-sql-server-monitoring","tag-sql-sprawl"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Monitoring Tools &amp; Software | eG Innovations<\/title>\n<meta name=\"description\" content=\"Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.\" \/>\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.eginnovations.com\/blog\/sql-server-monitoring-tools\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Monitoring Tools &amp; Software | eG Innovations\" \/>\n<meta property=\"og:description\" content=\"SQL Server is one of the most widely deployed databases. Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/\" \/>\n<meta property=\"og:site_name\" content=\"eG Innovations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/eGInnovations\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-27T12:38:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-27T16:30:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450\" \/>\n<meta name=\"author\" content=\"Arun Srinivas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"SQL Server Monitoring Tools &amp; Software | eG Innovations\" \/>\n<meta name=\"twitter:description\" content=\"SQL Server is one of the most widely deployed databases. Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450\" \/>\n<meta name=\"twitter:creator\" content=\"@eginnovations\" \/>\n<meta name=\"twitter:site\" content=\"@eginnovations\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Arun Srinivas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Monitoring Tools & Software | eG Innovations","description":"Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.","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.eginnovations.com\/blog\/sql-server-monitoring-tools\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Monitoring Tools & Software | eG Innovations","og_description":"SQL Server is one of the most widely deployed databases. Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.","og_url":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/","og_site_name":"eG Innovations","article_publisher":"https:\/\/www.facebook.com\/eGInnovations","article_published_time":"2014-02-27T12:38:51+00:00","article_modified_time":"2022-11-27T16:30:49+00:00","og_image":[{"url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450","type":"","width":"","height":""}],"author":"Arun Srinivas","twitter_card":"summary_large_image","twitter_title":"SQL Server Monitoring Tools & Software | eG Innovations","twitter_description":"SQL Server is one of the most widely deployed databases. Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.","twitter_image":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450","twitter_creator":"@eginnovations","twitter_site":"@eginnovations","twitter_misc":{"Written by":"Arun Srinivas","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#article","isPartOf":{"@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/"},"author":{"name":"Arun Srinivas","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/39cf71f9ec7dc9e40797d8330cf99511"},"headline":"SQL Server Monitoring","datePublished":"2014-02-27T12:38:51+00:00","dateModified":"2022-11-27T16:30:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/"},"wordCount":639,"commentCount":0,"publisher":{"@id":"https:\/\/www.eginnovations.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450","keywords":["Database monitoring","eG Enterprise SQL monitoring","Microsoft SQL Server","Microsoft SQL server performance","Monitoring MS SQL Server","MS SQL Server monitoring","SQL monitoring","SQL monitoring tool","SQL server monitoring","SQL sprawl"],"articleSection":["End-to-End Monitoring (E2E)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/","url":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/","name":"SQL Server Monitoring Tools & Software | eG Innovations","isPartOf":{"@id":"https:\/\/www.eginnovations.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#primaryimage"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450","datePublished":"2014-02-27T12:38:51+00:00","dateModified":"2022-11-27T16:30:49+00:00","description":"Find out how SQL Server Monitoring Tools can help manage multiple server environments and mitigate server sprawl.","breadcrumb":{"@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#primaryimage","url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450","contentUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/02\/database-gartner-magic-quadrant1.jpg?w=450"},{"@type":"BreadcrumbList","@id":"https:\/\/www.eginnovations.com\/blog\/sql-server-monitoring-tools\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.eginnovations.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Monitoring"}]},{"@type":"WebSite","@id":"https:\/\/www.eginnovations.com\/blog\/#website","url":"https:\/\/www.eginnovations.com\/blog\/","name":"eG Innovations","description":"IT Performance Monitoring Insights","publisher":{"@id":"https:\/\/www.eginnovations.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.eginnovations.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.eginnovations.com\/blog\/#organization","name":"eG Innovations","alternateName":"eg innovations","url":"https:\/\/www.eginnovations.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/07\/eg-logo-dark-gray1_new.jpg","contentUrl":"https:\/\/www.eginnovations.com\/blog\/wp-content\/uploads\/2014\/07\/eg-logo-dark-gray1_new.jpg","width":362,"height":235,"caption":"eG Innovations"},"image":{"@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/eGInnovations","https:\/\/x.com\/eginnovations"]},{"@type":"Person","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/39cf71f9ec7dc9e40797d8330cf99511","name":"Arun Srinivas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eginnovations.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/89fe8afa3a9cc9ed9c429cbeb02b6959?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/89fe8afa3a9cc9ed9c429cbeb02b6959?s=96&d=mm&r=g","caption":"Arun Srinivas"},"url":"https:\/\/www.eginnovations.com\/blog\/author\/arunksrinivas\/"}]}},"modified_by":"Srinivas Ramanathan","_links":{"self":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts\/1477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/comments?post=1477"}],"version-history":[{"count":0,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/posts\/1477\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/media?parent=1477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/categories?post=1477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eginnovations.com\/blog\/wp-json\/wp\/v2\/tags?post=1477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}