{"id":255,"date":"2018-07-21T11:13:54","date_gmt":"2018-07-21T01:13:54","guid":{"rendered":"http:\/\/kswp01.azurewebsites.net\/?p=255"},"modified":"2018-07-22T20:01:23","modified_gmt":"2018-07-22T10:01:23","slug":"255","status":"publish","type":"post","link":"https:\/\/kswp01.azurewebsites.net\/?p=255","title":{"rendered":"Check fragmentation level in AirWatch DB"},"content":{"rendered":"<h3>How to check fragmentation level in AirWatch DB<\/h3>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<pre>SELECT OBJECT_NAME(object_id), index_id, index_type_desc, index_level, avg_fragmentation_in_percent,\r\navg_Page_space_used_in_percent, page_count\r\nFROM sys.dm_db_index_physical_stats(DB_ID(N'AirWatch'), null, null, null, 'SAMPLED')\r\nORDER BY avg_fragmentation_in_percent DESC\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h3>References<\/h3>\n<p><a href=\"https:\/\/docs.vmware.com\/en\/VMware-Workspace-ONE-UEM\/9.5\/vmware-airwatch-guides-95\/GUID-AW95-Monitor_AW_DB.html\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.vmware.com\/en\/VMware-Workspace-ONE-UEM\/9.5\/vmware-airwatch-guides-95\/GUID-AW95-Monitor_AW_DB.html<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to check fragmentation level in AirWatch DB<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,12],"tags":[],"_links":{"self":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts\/255"}],"collection":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=255"}],"version-history":[{"count":4,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions"}],"predecessor-version":[{"id":259,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions\/259"}],"wp:attachment":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}