{"id":3610,"date":"2013-06-12T09:12:17","date_gmt":"2013-06-12T07:12:17","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=3610"},"modified":"2013-06-13T11:55:55","modified_gmt":"2013-06-13T09:55:55","slug":"last-30-minutes-performance-data","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=3610","title":{"rendered":"Last 30 Minutes Performance Data"},"content":{"rendered":"<p>I wrote a SQL query that I thought I could share. This SQL query will show collected performance data for a specific machine for the last 30 minutes. I was working with a issue where some agents stopped sending performance data. Before we found the root cause and a fix, we\u00c2\u00a0configured this script in a monitor to give us an alert if the agent was not sending performance data. Info how to configure a monitor to run a SQL query can be found <a title=\"Query a database with a monitor \u00e2\u20ac\u201c part two\" href=\"http:\/\/contoso.se\/blog\/?p=1346\">here<\/a>.<\/p>\n<pre>select Path, ObjectName, CounterName, InstanceName, SampleValue, TimeSampled \r\nfrom PerformanceDataAllView pdv with (NOLOCK)\r\ninner join PerformanceCounterView pcv on pdv.performancesourceinternalid = pcv.performancesourceinternalid\r\ninner join BaseManagedEntity bme on pcv.ManagedEntityId = bme.BaseManagedEntityId\r\nwhere path = 'dc01.contoso.local' AND (TimeSampled &lt; GETUTCDATE() AND TimeSampled &gt; DATEADD(MINUTE,-30, GETUTCDATE()))\r\norder by timesampled DESC<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I wrote a SQL query that I thought I could share. This SQL query will show collected performance data for a specific machine for the last 30 minutes. I was working with a issue where some agents stopped sending performance data. Before we found the root cause and a fix, we\u00c2\u00a0configured this script in a &hellip; <a href=\"http:\/\/contoso.se\/blog\/?p=3610\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[61,19],"tags":[],"class_list":["post-3610","post","type-post","status-publish","format-standard","hentry","category-operations-manager-2012","category-operations-manager-2007"],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3610"}],"version-history":[{"count":2,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3610\/revisions"}],"predecessor-version":[{"id":3614,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3610\/revisions\/3614"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3610"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}