{"id":2776,"date":"2013-08-02T09:02:36","date_gmt":"2013-08-02T09:02:36","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2776"},"modified":"2013-08-02T09:02:36","modified_gmt":"2013-08-02T09:02:36","slug":"%e7%a3%81%e7%9b%98%e7%a9%ba%e9%97%b4%e6%9f%a5%e7%9c%8b","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/08\/02\/%e7%a3%81%e7%9b%98%e7%a9%ba%e9%97%b4%e6%9f%a5%e7%9c%8b\/","title":{"rendered":"\u78c1\u76d8\u7a7a\u95f4\u67e5\u770b"},"content":{"rendered":"<h3 style=\"border: 0px; font-family: 'Droid Serif', Georgia, 'Times New Roman', serif; font-size: 1.8rem; font-weight: inherit; margin: 0px 0px 0.8em; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; transition: 0ms; -webkit-transition: 0ms; opacity: 1; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255); text-align: justify;\">\n\tMethod 1:<\/h3>\n<p style=\"border: 0px; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; margin: 0px 0px 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; transition: 0ms; -webkit-transition: 0ms; opacity: 1; color: rgb(68, 68, 68); line-height: 23px; background-color: rgb(255, 255, 255);\">\n\t<code style=\"border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 12px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; line-height: normal; transition: 0ms; -webkit-transition: 0ms; opacity: 1;\"><span style=\"border: 0px; font-family: inherit; font-size: 16px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">EXEC MASTER<\/span><span style=\"border: 0px; font-family: inherit; font-size: 16px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: black;\">..<\/span><span style=\"border: 0px; font-family: inherit; font-size: 16px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: rgb(139, 0, 0);\">xp_fixeddrives<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; font-family: inherit; font-size: 16px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: black;\">GO<\/span><\/code><\/p>\n<p>\t&nbsp;<\/p>\n<h3 style=\"border: 0px; font-family: 'Droid Serif', Georgia, 'Times New Roman', serif; font-size: 1.8rem; font-weight: inherit; margin: 0px 0px 0.8em; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; transition: 0ms; -webkit-transition: 0ms; opacity: 1; color: rgb(68, 68, 68); background-color: rgb(255, 255, 255); text-align: justify;\">\n\tMethod 2:<\/h3>\n<p style=\"border: 0px; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; margin: 0px 0px 1.5em; outline: 0px; padding: 0px; vertical-align: baseline; transition: 0ms; -webkit-transition: 0ms; opacity: 1; color: rgb(68, 68, 68); line-height: 23px; background-color: rgb(255, 255, 255);\">\n\t<code style=\"border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 12px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; line-height: normal; transition: 0ms; -webkit-transition: 0ms; opacity: 1;\"><span style=\"border: 0px; font-family: inherit; font-size: 16px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: black;\"><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">SELECT DISTINCT&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: rgb(255, 0, 255);\">DB_NAME<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">(<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">dovs.database_id<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">)&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">DBName<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">,<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">mf.physical_name PhysicalFileLocation<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">,<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">dovs.logical_volume_name&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">AS&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">LogicalName<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">,<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">dovs.volume_mount_point&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">AS&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">Drive<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">,<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: rgb(255, 0, 255);\">CONVERT<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">(<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">INT<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">,<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">dovs.available_bytes<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">\/<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">1048576.0<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">)&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">AS&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">FreeSpaceInMB<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">FROM&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">sys.master_files mf<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">CROSS&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">APPLY sys.dm_os_volume_stats<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">(<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">mf.database_id<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">,&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">mf.<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: rgb(255, 0, 255);\">FILE_ID<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: gray;\">)&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">dovs<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">ORDER BY&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">FreeSpaceInMB&nbsp;<\/span><span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1; color: blue;\">ASC<\/span><br style=\"-webkit-transition: 0ms; transition: 0ms; opacity: 1;\" \/><br \/>\n\t<span style=\"border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; -webkit-transition: 0ms; transition: 0ms; opacity: 1;\">GO<\/p>\n<p>\t\u5f15\u81ea\uff1a<a href=\"http:\/\/blog.sqlauthority.com\/2013\/08\/02\/sql-server-disk-space-monitoring-detecting-low-disk-space-on-server\/\">SQL SERVER &ndash; Disk Space Monitoring &ndash; Detecting Low Disk Space on Server<\/a><\/span><\/span><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Method 1: EXEC MASTER..xp_fixeddrives GO &nbsp; Method  [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2776","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2776"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2776\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}