{"id":6361,"date":"2021-09-13T12:09:02","date_gmt":"2021-09-13T10:09:02","guid":{"rendered":"https:\/\/pandorafms.com\/library\/?p=6361"},"modified":"2024-08-19T15:04:32","modified_gmt":"2024-08-19T13:04:32","slug":"policy-sql-server","status":"publish","type":"post","link":"https:\/\/pandorafms.com\/library\/policy-sql-server\/","title":{"rendered":"Policy SQL Server                                                   <img src=\"https:\/\/pandorafms.com\/library\/wp-content\/uploads\/2017\/12\/icono-modulo-enterprise.png\" alt=\"enterprise\" \/>"},"content":{"rendered":"<p>This is a policy for monitoring SQL Servers.<\/p>\n<p>Modules generated by the policy:<\/p>\n<ul>\n<li>Avg. Disk sec\/Read<\/li>\n<li>Avg. Disk sec\/Write<\/li>\n<li>MS SQL Server status<\/li>\n<li>SQL_% Used Paging File<\/li>\n<li>SQL_Batch Requests\/sec<\/li>\n<li>SQL_Buffer cache hit ratio<\/li>\n<li>SQL_Checkpoint pages\/sec<\/li>\n<li>SQL_Compilations\/sec<\/li>\n<li>SQL_Locks Waits\/sec<\/li>\n<li>SQL_Memory Grants Pending<\/li>\n<li>SQL_Page life expectancy<\/li>\n<li>SQL_Page reads\/sec<\/li>\n<li>SQL_Page writes\/sec<\/li>\n<li>SQL_Percent Log Used<\/li>\n<li>SQL_Processes blocked<\/li>\n<li>SQL_Recompilations\/sec<\/li>\n<li>SQL_Target Server Memory (KB)<\/li>\n<li>SQL_User Connections<\/li>\n<\/ul>\n<br\/><p class=\"no-enterprise\">Only enterprise users can view the download links.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a policy for monitoring SQL Servers. Modules generated by the policy: Avg. Disk sec\/Read Avg. Disk sec\/Write MS SQL Server status SQL_% Used Paging File SQL_Batch Requests\/sec SQL_Buffer cache hit ratio SQL_Checkpoint pages\/sec SQL_Compilations\/sec SQL_Locks Waits\/sec SQL_Memory Grants Pending SQL_Page life expectancy SQL_Page reads\/sec SQL_Page writes\/sec SQL_Percent Log Used SQL_Processes blocked SQL_Recompilations\/sec SQL_Target [&hellip;]<\/p>\n","protected":false},"author":4032,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[45,24],"tags":[1038,1040,773],"_links":{"self":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/6361"}],"collection":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/users\/4032"}],"replies":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/comments?post=6361"}],"version-history":[{"count":2,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/6361\/revisions"}],"predecessor-version":[{"id":8956,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/6361\/revisions\/8956"}],"wp:attachment":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/media?parent=6361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/categories?post=6361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/tags?post=6361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}