{"id":4334,"date":"2015-02-18T13:14:00","date_gmt":"2015-02-18T12:14:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/"},"modified":"2015-02-18T13:14:00","modified_gmt":"2015-02-18T12:14:00","slug":"sql-server-monitoring-with-nagios-utilisation","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/","title":{"rendered":"SQL Server monitoring with nagios: utilisation"},"content":{"rendered":"<p>We saw in my last blog how to install the SQL Server plugin for Nagios.<br \/>\nIn this new blog, I will explain:<\/p>\n<ul>\n<li>how to create a wrapper to avoid the unset of the PERLLIB variable<\/li>\n<li>how to create and configure a configuration file by monitoring instance<\/li>\n<li>how to create an SQL Login for nagios<\/li>\n<li>How to subscribe to an alert<\/li>\n<\/ul>\n<p>As we saw in the first nagios blog, to be able to run the check mssql plugin we have to unset the PERLLIB variable and to export library.<br \/>\nWe unset the PERLLIB libraries because there are set with the Oracle Client and there is conflicts. We force the plugin 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.<br \/>\nWe will do that in a wrapped file:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_blog_correction1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios_SQLServer_blog_correction1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\" \/><\/a><\/p>\n<p>After we are able to test our wrapper with success:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_nagios_b2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios_SQLServer_nagios_b2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_nagios_b2.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b2.jpg\" \/><\/a><\/p>\n<p>We have decided to create a configuration file per SQL Server instance to monitor.<br \/>\nThis file is as follow:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_nagios_b3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios_SQLServer_nagios_b3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_nagios_b3.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b3.jpg\" \/><\/a><\/p>\n<p>The important things to see here is:<\/p>\n<p>In the host definition line:<\/p>\n<ul>\n<li>mssql_sid with the name of the instance given in the freetds.conf file (see first nagios blog)<\/li>\n<li>mssql_usr with the user name used for the SQL Server connection<\/li>\n<li>address with the IP Address of the SQL Server host<\/li>\n<\/ul>\n<p>In the command line:<\/p>\n<ul>\n<li>the call to the check_mssql_health_wrapped file<\/li>\n<li>the counter used in this call, here cpu-busy<\/li>\n<li>the warning threshold fixed at 80% of cpu used<\/li>\n<li>the alert threshold fixed to 90% of cpu used<\/li>\n<\/ul>\n<p>In the service line:<\/p>\n<ul>\n<li>normal_check_interval which defines the interval to check the service under normal conditions, here 10 minutes<\/li>\n<li>retry_check_interval which determines the number of minutes to wait before scheduling a re-check when service has changed to non-OK state, here 2 minutes<\/li>\n<li>max_check_attempts which checks if the service has been retried max_check_attempts time without a change in its status, it will revert to being scheduled at normal_check_interval rate and a mail is sent to the contact_group, here 3 times<\/li>\n<li>contact_groups which will receive alerts<\/li>\n<li>notification_interval which determines every how many minutes alerts will be send<\/li>\n<\/ul>\n<p>It means that the cpu-busy counter will be check every 10 minutes by nagios, in case of non-OK state the next check will be scheduled after 2 minutes and after 3 checks without change, an alert will be send to the contact group and another check will be scheduled 10 minutes later.\u00a0 If the status stays non-ok a next alert will be sent after 6 hours.<\/p>\n<p>A lots of counters are available for this plugin, to have a list, please go <a href=\"http:\/\/labs.consol.de\/lang\/en\/nagios\/check_mssql_health\/\">here<\/a>.<\/p>\n<p>An SQL Login can be created to connect to the SQL Server instance and databases to avoid to use sa user for example.<br \/>\nFirst create a windows domain account:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_Account1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Blog2\/Nagios_SQLServer_Account1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_Account1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_Account1.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_Account1.jpg\" \/><\/a><\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_Account2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Blog2\/Nagios_SQLServer_Account2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_Account2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_Account2.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_Account2.jpg\" \/><\/a><\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_Account2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Blog2\/Nagios_SQLServer_Account2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_Account2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_Account2.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_Account2.jpg\" \/><\/a><br \/>\nExecute the following script in SSMS in a query window to create the new logins and grand permissions:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"><span style=\"color: #0000ff;\">USE [master]<\/span>\n<span style=\"color: #0000ff;\">GO<\/span>\n<span style=\"color: #0000ff;\">CREATE LOGIN [DBITESTnagios_mssql_health] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<\/span>\n<span style=\"color: #0000ff;\">GO<\/span>\n<span style=\"color: #0000ff;\">GRANT VIEW SERVER STATE to [DBITESTnagios_mssql_health]<\/span>\n<span style=\"color: #0000ff;\">USE [model]<\/span>\n<span style=\"color: #0000ff;\">GO<\/span>\n<span style=\"color: #0000ff;\">CREATE ROLE db_nagios_mssql_health<\/span>\n<span style=\"color: #0000ff;\">GRANT EXECUTE TO db_nagios_mssql_health<\/span>\n<span style=\"color: #0000ff;\">GRANT VIEW DATABASE STATE TO db_nagios_mssql_health<\/span>\n<span style=\"color: #0000ff;\">GRANT VIEW DEFINITION TO db_nagios_mssql_health<\/span>\n<span style=\"color: #0000ff;\">CREATE USER [DBITESTnagios_mssql_health] FOR LOGIN [DBITESTnagios_mssql_health]<\/span>\n<span style=\"color: #0000ff;\">EXEC<\/span> <span style=\"color: #800080;\">sp_addrolemember<\/span><span style=\"color: #ff0000;\">'db_nagios_mssql_health'<\/span>, <span style=\"color: #999999;\">[DBITESTnagios_mssql_health]<\/span><\/pre>\n<p>After execute the following script to grand permission on database level, take care if a new database is installed later this script has to be run for this new db.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"><span style=\"color: #0000ff;\">execute<\/span> <span style=\"color: #800080;\">sp_MSforeachdb<\/span> <span style=\"color: #ff0000;\">'use [?]<\/span>\n<span style=\"color: #ff0000;\">print ''?''<\/span>\n<span style=\"color: #ff0000;\">USE [?]<\/span>\n<span style=\"color: #ff0000;\">CREATE ROLE db_nagios_mssql_health<\/span>\n<span style=\"color: #ff0000;\">GRANT EXECUTE TO db_nagios_mssql_health<\/span>\n<span style=\"color: #ff0000;\">GRANT VIEW DATABASE STATE TO db_nagios_mssql_health<\/span>\n<span style=\"color: #ff0000;\">GRANT VIEW DEFINITION TO db_nagios_mssql_health<\/span>\n<span style=\"color: #ff0000;\">CREATE USER [DBITESTnagios_mssql_health] FOR LOGIN [DBITESTnagios_mssql_health]<\/span>\n<span style=\"color: #ff0000;\">EXEC sp_addrolemember ''db_nagios_mssql_health'', [DBITESTnagios_mssql_health]'<\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>To subscribe to an alert, new groups and contact can be defined.<br \/>\nThose objects will be created in a contact configuration file which will be added to the config.cfg file of nagios with this line:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># dbi-services contacts and contactgroups\ncfg_file=\/usr\/local\/nagios\/etc\/objects\/DBI_contacts.cfg<\/pre>\n<p>The contact configuration file have the following structure:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_nagios_b4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Blog2\/Nagios_SQLServer_nagios_b4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_nagios_b4.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b4.jpg\" \/><\/a><\/p>\n<p>I hope those information will help you to configure the SQL Server plugin for nagios and will give you service status details as the picture below:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Nagios_SQLServer_nagios_b5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/Nagios\/Blog2\/Nagios_SQLServer_nagios_b5.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b5.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_nagios_b5.jpg\" alt=\"b2ap3_thumbnail_Nagios_SQLServer_nagios_b5.jpg\" \/><\/a><\/p>\n<p>See You.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":4335,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[143,534,452,51],"type_dbi":[],"class_list":["post-4334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-monitoring","tag-nagios","tag-sql-monitoring","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server monitoring with nagios: utilisation - dbi Blog<\/title>\n<meta name=\"description\" content=\"We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alertNagios Monitoring SQL Server Freetds alert group counter\" \/>\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-utilisation\/\" \/>\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: utilisation\" \/>\n<meta property=\"og:description\" content=\"We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alertNagios Monitoring SQL Server Freetds alert group counter\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-18T12:14:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"499\" \/>\n\t<meta property=\"og:image:height\" content=\"274\" \/>\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: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=\"4 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-utilisation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server monitoring with nagios: utilisation\",\"datePublished\":\"2015-02-18T12:14:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/\"},\"wordCount\":603,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\",\"keywords\":[\"Monitoring\",\"Nagios\",\"SQL Monitoring\",\"SQL Server\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/\",\"name\":\"SQL Server monitoring with nagios: utilisation - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\",\"datePublished\":\"2015-02-18T12:14:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alertNagios Monitoring SQL Server Freetds alert group counter\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg\",\"width\":499,\"height\":274},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server monitoring with nagios: utilisation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"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: utilisation - dbi Blog","description":"We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alertNagios Monitoring SQL Server Freetds alert group counter","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-utilisation\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server monitoring with nagios: utilisation","og_description":"We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alertNagios Monitoring SQL Server Freetds alert group counter","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/","og_site_name":"dbi Blog","article_published_time":"2015-02-18T12:14:00+00:00","og_image":[{"width":499,"height":274,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server monitoring with nagios: utilisation","datePublished":"2015-02-18T12:14:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/"},"wordCount":603,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg","keywords":["Monitoring","Nagios","SQL Monitoring","SQL Server"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/","name":"SQL Server monitoring with nagios: utilisation - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg","datePublished":"2015-02-18T12:14:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alertNagios Monitoring SQL Server Freetds alert group counter","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Nagios_SQLServer_blog_correction1.jpg","width":499,"height":274},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-monitoring-with-nagios-utilisation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server monitoring with nagios: utilisation"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4334","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=4334"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4334\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4335"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4334"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}