{"id":534,"date":"2025-07-28T09:36:41","date_gmt":"2025-07-28T00:36:41","guid":{"rendered":"https:\/\/sejiwon.com\/?p=534"},"modified":"2025-07-28T09:36:41","modified_gmt":"2025-07-28T00:36:41","slug":"azure%ec%97%90%ec%84%9c-trucate%ed%9b%84-%ec%95%95%ec%b6%95%ed%95%9c-%ed%9b%84-freespace-%eb%a5%bc-%ec%a4%84%ec%9d%b4%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=534","title":{"rendered":"Azure\uc5d0\uc11c Trucate\ud6c4 \uc555\ucd95\ud55c \ud6c4 Freespace \ub97c \uc904\uc774\ub294 \ubc29\ubc95"},"content":{"rendered":"\n<p>Azure SQL Database \ub610\ub294 Azure SQL Managed Instance\uc5d0\uc11c <code>TRUNCATE<\/code> \ud6c4 <strong>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc758 \uc2e4\uc81c \ud06c\uae30(Freespace)\ub97c \uc904\uc774\ub294 \uac83<\/strong>\uc740 \uc77c\ubc18\uc801\uc778 \uc628\ud504\ub808\ubbf8\uc2a4 SQL Server\uc640\ub294 \ucc28\uc774\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 \uae30\ubcf8 \uac1c\ub150 \uc694\uc57d<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc791\uc5c5<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td><code>TRUNCATE TABLE<\/code><\/td><td>\ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c <strong>\ube60\ub974\uac8c \uc0ad\uc81c<\/strong>\ud558\uc9c0\ub9cc, \ud30c\uc77c \ud06c\uae30(DB \uacf5\uac04)\ub294 \uc904\uc5b4\ub4e4\uc9c0 \uc54a\uc74c<\/td><\/tr><tr><td><code>DBCC SHRINKDATABASE<\/code> \/ <code>DBCC SHRINKFILE<\/code><\/td><td><strong>\uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uacf5\uac04\uc744 \uc904\uc784<\/strong> (\ud558\uc9c0\ub9cc Azure\uc5d0\uc11c\ub294 \uc8fc\uc758 \ud544\uc694)<\/td><\/tr><tr><td>Azure SQL<\/td><td><strong>\uc790\ub3d9 \ud06c\uae30 \uc870\uc808 \uae30\ub2a5<\/strong>\uc774 \uc788\uc9c0\ub9cc <strong>\uc790\ub3d9 \ucd95\uc18c(auto-shrink)\ub294 \uc5c6\uc74c<\/strong>. \uc218\ub3d9 \ucd95\uc18c\ub9cc \uac00\ub2a5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udccc \ubaa9\ud45c: TRUNCATE \u2192 \uc555\ucd95 \u2192 \uc2e4\uc81c \uc0ac\uc6a9 \uacf5\uac04 \uc904\uc774\uae30 (Azure \uae30\uc900)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>TRUNCATE TABLE \uc2e4\ud589<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>TRUNCATE TABLE [YourTableName];\n<\/code><\/pre>\n\n\n\n<ul>\n<li>\ub370\uc774\ud130\ub294 \ube60\ub974\uac8c \uc0ad\uc81c\ub418\uc9c0\ub9cc, \uacf5\uac04\uc740 \uc5ec\uc804\ud788 \ud560\ub2f9\ub418\uc5b4 \uc788\uc74c.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>\uc778\ub371\uc2a4 \uc7ac\uad6c\uc131 \ub610\ub294 \uc555\ucd95 (optional)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>-- \ud14c\uc774\ube14\uc5d0 \ud074\ub7ec\uc2a4\ud130\ub4dc \uc778\ub371\uc2a4\uac00 \uc788\ub2e4\uba74 \uc7ac\uad6c\uc131\nALTER INDEX ALL ON [YourTableName] REBUILD;\n<\/code><\/pre>\n\n\n\n<p>\ub610\ub294:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>-- \ub370\uc774\ud130 \uc555\ucd95 \uc801\uc6a9 (\uc608: \ud398\uc774\uc9c0 \uc555\ucd95)\nALTER TABLE [YourTableName] REBUILD PARTITION = ALL\nWITH (DATA_COMPRESSION = PAGE); -- \ub610\ub294 ROW\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>\ud83d\udccc \ubaa9\uc801: \ub0b4\ubd80\uc801\uc73c\ub85c \uacf5\uac04 \ucd5c\uc801\ud654. \uacf5\uac04 \uc904\uc774\uae30 \uc804 &#8220;\uc2e4\uc81c \uc0ac\uc6a9 \uacf5\uac04&#8221; \ucd5c\uc18c\ud654<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>DBCC SHRINKFILE \uc2e4\ud589 (Azure\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>-- \ub370\uc774\ud130 \ud30c\uc77c \uc774\ub984 \ud655\uc778\nSELECT name AS FileName, type_desc, size * 8 \/ 1024 AS SizeMB\nFROM sys.database_files;\n\n-- Shrink \uc2e4\ud589 (\uc608: 100MB\ub85c \uc904\uc774\uae30)\nDBCC SHRINKFILE (N'YourDataFileName', 100);\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>\u26a0\ufe0f \uc8fc\uc758:<\/p>\n<\/blockquote>\n\n\n\n<ul>\n<li>\ub108\ubb34 \uc790\uc8fc SHRINK\ud558\uba74 <strong>\uc778\ub371\uc2a4 \uc870\uac01\ud654 \uc99d\uac00<\/strong>, \uc131\ub2a5 \uc800\ud558 \ubc1c\uc0dd \uac00\ub2a5<\/li>\n\n\n\n<li>\uad8c\uc7a5: <strong>\ud55c \ubc88\ub9cc<\/strong>, \ub610\ub294 \uc720\uc9c0\ubcf4\uc218 \uc2dc\uac04\uc5d0 \uc2e4\ud589<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>(\uc635\uc158) DBCC SHRINKDATABASE \uc2e4\ud589<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>-- DB \uc804\uccb4\ub97c \uc9c0\uc815\ub41c %\uae4c\uc9c0 \ucd95\uc18c\nDBCC SHRINKDATABASE (YourDBName, 10); -- 10% \uc5ec\uc720\uacf5\uac04\ub9cc \ub0a8\uae30\uace0 \uc555\ucd95\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>\u26a0\ufe0f <code>DBCC SHRINKDATABASE<\/code>\ub294 \uc77c\ubd80 Azure SQL \ud658\uacbd\uc5d0\uc11c\ub294 \uc81c\ud55c\ub420 \uc218 \uc788\uc73c\ubbc0\ub85c \ubcf4\ud1b5\uc740 <code>SHRINKFILE<\/code>\uc774 \ub354 \uc548\uc804\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcc8 \uacf5\uac04 \uc0ac\uc6a9\ub7c9 \ud655\uc778 \ucffc\ub9ac<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>-- \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacf5\uac04 \uc815\ubcf4 \ubcf4\uae30\nEXEC sp_spaceused;\n\n-- \ud30c\uc77c\ubcc4 \ud06c\uae30 \ubcf4\uae30\nSELECT\n    name AS LogicalName,\n    type_desc AS FileType,\n    size * 8 \/ 1024 AS SizeMB,\n    FILEPROPERTY(name, 'SpaceUsed') * 8 \/ 1024 AS UsedSpaceMB\nFROM sys.database_files;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 Azure \ud658\uacbd \ud301<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\ud658\uacbd<\/th><th>\uc9c0\uc6d0 \uc5ec\ubd80<\/th><\/tr><\/thead><tbody><tr><td>Azure SQL Database (PaaS)<\/td><td>\u2705 <code>DBCC SHRINKFILE<\/code> \uac00\ub2a5, <code>DBCC SHRINKDATABASE<\/code> \uc77c\ubd80 \uc81c\ud55c<\/td><\/tr><tr><td>Azure SQL Managed Instance<\/td><td>\u2705 \uc628\ud504\ub808\ubbf8\uc2a4\uc640 \ub3d9\uc77c\ud558\uac8c SHRINK \uac00\ub2a5<\/td><\/tr><tr><td>\uc790\ub3d9 \ucd95\uc18c(AUTO_SHRINK)<\/td><td>\u274c \uae30\ubcf8\uc801\uc73c\ub85c \ube44\ud65c\uc131\ud654 &amp; \ube44\uad8c\uc7a5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddfc \uc815\ub9ac\ub41c \uc808\ucc28<\/h2>\n\n\n\n<ol>\n<li><code>TRUNCATE TABLE<\/code> \ub85c \ub370\uc774\ud130 \uc81c\uac70<\/li>\n\n\n\n<li><code>ALTER INDEX ... REBUILD<\/code> \ub610\ub294 <code>ALTER TABLE ... REBUILD<\/code> \ub85c \uacf5\uac04 \uc815\ub9ac<\/li>\n\n\n\n<li><code>DBCC SHRINKFILE<\/code> \ub85c \ub370\uc774\ud130 \ud30c\uc77c \ud06c\uae30 \uc904\uc784<\/li>\n\n\n\n<li><code>sp_spaceused<\/code> \ub610\ub294 <code>sys.database_files<\/code>\ub85c \uacb0\uacfc \ud655\uc778<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Azure SQL Database \ub610\ub294 Azure SQL Managed Instance\uc5d0\uc11c TRUNCATE \ud6c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc758 \uc2e4\uc81c \ud06c\uae30(Freespace)\ub97c \uc904\uc774\ub294 \uac83\uc740 \uc77c\ubc18\uc801\uc778 \uc628\ud504\ub808\ubbf8\uc2a4 SQL Server\uc640\ub294 \ucc28\uc774\uac00 \uc788\uc2b5\ub2c8\ub2e4. \u2705 \uae30\ubcf8 \uac1c\ub150 \uc694\uc57d \uc791\uc5c5 \uc124\uba85 TRUNCATE TABLE \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ube60\ub974\uac8c \uc0ad\uc81c\ud558\uc9c0\ub9cc, \ud30c\uc77c \ud06c\uae30(DB \uacf5\uac04)\ub294 \uc904\uc5b4\ub4e4\uc9c0 \uc54a\uc74c DBCC SHRINKDATABASE \/ DBCC SHRINKFILE \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uacf5\uac04\uc744 \uc904\uc784 (\ud558\uc9c0\ub9cc Azure\uc5d0\uc11c\ub294 \uc8fc\uc758 \ud544\uc694) Azure SQL \uc790\ub3d9\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=534\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/534"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=534"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":536,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/534\/revisions\/536"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}