{"id":4312,"date":"2015-02-15T13:37:00","date_gmt":"2015-02-15T12:37:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/"},"modified":"2015-02-15T13:37:00","modified_gmt":"2015-02-15T12:37:00","slug":"sql-server-monitoring-with-nagios-installation","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/","title":{"rendered":"SQL Server monitoring with nagios: installation"},"content":{"rendered":"<p>Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin.<br \/>\nI have installed this plugin to test those functionalities and I will explain here how to do it.<\/p>\n<h3>Prerequisites installation<\/h3>\n<h4>FreeTDS installation<\/h4>\n<p>FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.<br \/>\nFirst we will download this set of libraries, for that go to the freetds website and click on Stable Release:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog1_20150129-144605_1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog1_20150129-144605_1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog1_20150129-144605_1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg\" alt=\"b2ap3_thumbnail_blog1_20150129-144605_1.jpg\" \/><\/a><\/p>\n<p>The file Freetds-stable.tgz will be downloaded.<br \/>\nWhen the file is downloaded, go to the nagios download directory and uncompressed the tgz file:<br \/>\n<a class=\"easyblog-thumb-preview\" title=\"script11.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script11.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_script11.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script11.jpg\" alt=\"b2ap3_thumbnail_script11.jpg\" \/><\/a><\/p>\n<p>Go to the Freetds directory and list files:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"script2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_script2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script2.jpg\" alt=\"b2ap3_thumbnail_script2.jpg\" \/><\/a><\/p>\n<p>Prepare and control libraries before compilation:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"script3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_script3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script3.jpg\" alt=\"b2ap3_thumbnail_script3.jpg\" \/><\/a><\/p>\n<p>Now, we will compile and install the Freetds libraries:<\/p>\n<p><samp><span style=\"background-color: #ffff00;\"><a class=\"easyblog-thumb-preview\" title=\"script4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script4.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"b2ap3_thumbnail_script4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script4.jpg\" alt=\"b2ap3_thumbnail_script4.jpg\" width=\"347\" height=\"37\" \/><\/a><\/span><\/samp><samp><\/samp><\/p>\n<p>Please, check if you don&#8217;t have any errors.<br \/>\nIf not, Freetds is now installed.<\/p>\n<h4>Perl-module DBD::Sybase installation<\/h4>\n<p>DBD::Sybase is a Perl module which works with the DBI module to provide access to Sybase databases.<br \/>\nTo download this module go to http:\/\/search.cpan.org\/~mewp\/DBD-Sybase-1.15\/Sybase.pm and click the download link:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog2_20150129-144603_1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog2_20150129-144603_1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog2_20150129-144603_1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog2_20150129-144603_1.jpg\" alt=\"b2ap3_thumbnail_blog2_20150129-144603_1.jpg\" \/><\/a><\/p>\n<p>When the file DBD-Sybase-1.15.tar.gz is downloaded, go to the download directory, uncompressed the file and go to the new directory:<br \/>\n<a class=\"easyblog-thumb-preview\" title=\"script5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script5.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_script5.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script5.jpg\" alt=\"b2ap3_thumbnail_script5.jpg\" \/><\/a><\/p>\n<p>We will now compile and install this new module:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"script6.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script6.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_script6.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script6.jpg\" alt=\"b2ap3_thumbnail_script6.jpg\" \/><\/a><\/p>\n<p>Now the module is installed. Check if you received errors.<br \/>\nCreate a symbolic link:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"script7.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/script7.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_script7.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_script7.jpg\" alt=\"b2ap3_thumbnail_script7.jpg\" \/><\/a><\/p>\n<p>We are able now to edit the Freetds.conf file to change:<\/p>\n<ul>\n<li>the tds version due to <a href=\"http:\/\/labs.consol.de\/lang\/en\/nagios\/check_mssql_health\/\">security advice<\/a> (follow the link and find the chapter Security Advice)<\/li>\n<li>add SQL Server parameters: IP Address, TCP\/IP port, instance name if not default instance<\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script81.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios_SQLServer_script81.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script81.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script81.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script81.jpg\" \/><\/a><\/p>\n<p>The Perl module is installed.<br \/>\nPrerequisites are now installed and we have to install the SQL Server plugin.<\/p>\n<h3>Nagios SQL Server plugin<\/h3>\n<h4>Installation<\/h4>\n<p>First, we have to download the SQL Server plugin of Nagios. To do it connect here and click the below link:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_blog3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_blog3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_blog3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog3.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_blog3.jpg\" \/><\/a><\/p>\n<p>When the file is downloaded:<\/p>\n<ul>\n<li>go to the download directory<\/li>\n<li>list files<\/li>\n<li>uncompressed the file<\/li>\n<li>re-list files to see the new plugin directory<\/li>\n<li>change the location to the new directory<\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script8.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script8.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script8.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script8.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script8.jpg\" \/><\/a><\/p>\n<p>The next command to type is Configure which will check that all dependencies are present and configure &amp; write a Makefile that will contain build orders.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script9.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script9.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script9.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script9.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script9.jpg\" \/><\/a><\/p>\n<p>After we will have to execute a make which will make the compilation (can be run as normal user):<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script91.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script91.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script91.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script91.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script91.jpg\" \/><\/a><\/p>\n<p>The next command to run is a Make install which will install the plugin (as to be run as root):<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script92.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script92.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script92.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script92.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script92.jpg\" \/><\/a><\/p>\n<p>The SQL Server Nagios plugin is successfully installed.<\/p>\n<h4 class=\"dbiCopy\">Set environment<\/h4>\n<p>As user root, change the permissions on file freetds.conf to be able to add server\/instance from user nagios:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script93.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script93.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script93.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script93.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script93.jpg\" \/><\/a><\/p>\n<p>Add libraries \/usr\/local\/freetds\/lib to file \/etc\/ld.so.conf:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script94.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script94.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script94.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script94.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script94.jpg\" \/><\/a><\/p>\n<p>As user nagio, export the freetds libraries to the LD_LIBRARY_PATH environment variable:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script95.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script95.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script95.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script95.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script95.jpg\" \/><\/a><\/p>\n<p>Test the connection:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script96.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios_SQLServer_script96.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script96.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script96.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script96.jpg\" \/><\/a><\/p>\n<p>Connection failed due to wrong PERLLIB path&#8230;<br \/>\nTo resolve this error, unset the PERLLIB variable.<br \/>\nWe force the plugin named check_mssql_health to use the PERLLIB libraries of the OS instead of these of the Oracle client by unsetting the PERLLIB libraries of the check_oracle_health plugin:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script97.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Nagios_SQLServer_script97.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script97.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script97.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script97.jpg\" \/><\/a><\/p>\n<p>Verification of the connection:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_script98.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios_SQLServer_script98.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_script98.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_script98.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_script98.jpg\" \/><\/a><\/p>\n<p>Verification succeeded.<\/p>\n<p>The next steps will be now to test this plugin by checking which counters can be used, how to configure them, with which thresholds, how to subscribe to alerts&#8230;<br \/>\nThose steps will be covered by a next blog.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin. I have installed this plugin to test those functionalities and I will explain here how to do it. Prerequisites installation FreeTDS installation FreeTDS is a set of libraries for Unix and Linux that allows your programs&hellip;&nbsp;<\/p>\n","protected":false},"author":21,"featured_media":4313,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[143,534,452],"class_list":["post-4312","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-monitoring","tag-nagios","tag-sql-monitoring"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server monitoring with nagios: installation - dbi services Blog<\/title>\n<meta name=\"description\" content=\"Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin check_mssql_health\" \/>\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.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server monitoring with nagios: installation\" \/>\n<meta property=\"og:description\" content=\"Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin check_mssql_health\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-15T12:37:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"233\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/adf6293d8bc8a7a26490acfe2918b6d7\"},\"headline\":\"SQL Server monitoring with nagios: installation\",\"datePublished\":\"2015-02-15T12:37:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/\"},\"wordCount\":572,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg\",\"keywords\":[\"Monitoring\",\"Nagios\",\"SQL Monitoring\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/\",\"name\":\"SQL Server monitoring with nagios: installation - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg\",\"datePublished\":\"2015-02-15T12:37:00+00:00\",\"description\":\"Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin check_mssql_health\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg\",\"width\":500,\"height\":233},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-monitoring-with-nagios-installation\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server monitoring with nagios: installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/adf6293d8bc8a7a26490acfe2918b6d7\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-savorgnano\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server monitoring with nagios: installation - dbi services Blog","description":"Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin check_mssql_health","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.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server monitoring with nagios: installation","og_description":"Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin check_mssql_health","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-02-15T12:37:00+00:00","og_image":[{"width":500,"height":233,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/adf6293d8bc8a7a26490acfe2918b6d7"},"headline":"SQL Server monitoring with nagios: installation","datePublished":"2015-02-15T12:37:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/"},"wordCount":572,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg","keywords":["Monitoring","Nagios","SQL Monitoring"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/","name":"SQL Server monitoring with nagios: installation - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg","datePublished":"2015-02-15T12:37:00+00:00","description":"Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin check_mssql_health","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_blog1_20150129-144605_1.jpg","width":500,"height":233},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server monitoring with nagios: installation"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/adf6293d8bc8a7a26490acfe2918b6d7","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4312"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4312\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4313"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}