{"id":35,"date":"2011-05-31T12:34:22","date_gmt":"2011-05-31T07:04:22","guid":{"rendered":"http:\/\/pramodsingla.wordpress.com\/?p=35"},"modified":"2011-05-31T12:34:22","modified_gmt":"2011-05-31T07:04:22","slug":"sql-server-get-sql-server-statistics-using-sp_monitor","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=35","title":{"rendered":"SQL Server- Get SQL server Statistics using SP_Monitor"},"content":{"rendered":"<p style=\"text-align:justify;\"><span style=\"color:#003366;\"><strong>Sp_Monitor :\u00a0<\/strong><\/span>It is a useful system function used to <strong>see the statistics of the SQL Server<\/strong>.<\/p>\n<p style=\"text-align:justify;\">Following image shows the result sets returned when sp_monitor is executed:<\/p>\n<p style=\"text-align:justify;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-45\" title=\"abc\" src=\"http:\/\/pramodsingla.files.wordpress.com\/2011\/05\/abc.jpg\" alt=\"sp_monitor\" width=\"750\" height=\"583\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2011\/05\/abc.jpg 1016w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2011\/05\/abc-300x233.jpg 300w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2011\/05\/abc-768x597.jpg 768w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align:justify;\"><strong>The packet size is defined at the server level. See server properties for packet size:<\/strong><\/p>\n<p style=\"text-align:justify;\"><a href=\"http:\/\/pramodsingla.files.wordpress.com\/2011\/05\/networkpacketsize2.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-67\" title=\"NetworkPacketSize\" src=\"http:\/\/pramodsingla.files.wordpress.com\/2011\/05\/networkpacketsize2.jpg\" alt=\"NetworkPacketSize\" width=\"699\" height=\"597\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2011\/05\/networkpacketsize2.jpg 699w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2011\/05\/networkpacketsize2-300x256.jpg 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sp_Monitor :\u00a0It is a useful system function used to see the statistics of the SQL Server. Following image shows the[&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[157,169],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/35"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=35"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/35\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}