{"id":2113,"date":"2016-09-05T12:23:18","date_gmt":"2016-09-05T03:23:18","guid":{"rendered":"http:\/\/ocworld.net\/?p=2113"},"modified":"2024-12-13T15:02:35","modified_gmt":"2024-12-13T06:02:35","slug":"%ed%8e%8csql-server%ec%97%90%ec%84%9c-tempdb-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4%eb%a5%bc-%ec%b6%95%ec%86%8c%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.ocworld.net\/?p=2113","title":{"rendered":"(\ud38c)SQL Server\uc5d0\uc11c tempdb \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"<div class=\"section-header\">\n<h5 class=\"section-title\">\uc694\uc57d<\/h5>\n<\/div>\n<p>\uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 <span class=\"text-base\">tempdb <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud558\uc5ec \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uad6c\uc131\ud55c \ud06c\uae30\ubcf4\ub2e4 \uc791\uac8c \ub9cc\ub4dc\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4. \uccab \ubc88\uc9f8 \ubc29\ubc95\uc740 <span class=\"text-base\">tempdb<\/span> \ud30c\uc77c\uc758 \ud06c\uae30\ub97c \uc644\ubcbd\ud558\uac8c \uc81c\uc5b4\ud560 \uc218 \uc788\uc9c0\ub9cc SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud569\ub2c8\ub2e4. \ub450 \ubc88\uc9f8 \ubc29\ubc95\uc740 \uba87 \uac00\uc9c0 \uc81c\ud55c\uc740 \uc788\uc9c0\ub9cc <span class=\"text-base\">tempdb<\/span>\ub97c \uc804\uccb4\uc801\uc73c\ub85c \ucd95\uc18c\ud558\uba70 SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc138 \ubc88\uc9f8 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uba74 <span class=\"text-base\">tempdb<\/span>\uc758 \uac1c\ubcc4 \ud30c\uc77c\uc744 \ucd95\uc18c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9 \ub450 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 \ucd95\uc18c \uc791\uc5c5 \uc911 <span class=\"text-base\">tempdb<\/span> \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \ub9d0\uc544\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p><span class=\"text-base\">\ucc38\uace0<\/span> SQL Server 2005\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub3c4 \uc774\ub7ec\ud55c \ubc29\ubc95\uc744 \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uad00\ub9ac\uc790\ub098 \ucffc\ub9ac \ubd84\uc11d\uae30 \ub300\uc2e0 SQL Server Management Studio\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774\ub7ec\ud55c \uc791\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<div id=\"bookmark-2\"><\/div>\n<h3 class=\"sbody-h3\">Tempdb \uc815\ubcf4<\/h3>\n<p><span class=\"text-base\">tempdb<\/span>\ub294 \uc784\uc2dc \uc791\uc5c5 \uc601\uc5ed\uc785\ub2c8\ub2e4. \uc5ec\ub7ec \uc6a9\ub3c4 \uc911\uc5d0\uc11c\ub3c4 SQL Server\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6a9\ub3c4\ub85c <span class=\"text-base\">tempdb<\/span>\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<ul class=\"sbody-free_list\">\n<li>\uba85\uc2dc\uc801\uc73c\ub85c \ub9cc\ub4e0 \uc784\uc2dc \ud14c\uc774\ube14\uc758 \uc800\uc7a5\uc18c<\/li>\n<li>\ucffc\ub9ac \ucc98\ub9ac\uc640 \uc800\uc7a5 \uc911 \ub9cc\ub4e4\uc5b4\uc9c4 \uc911\uac04 \uacb0\uacfc\ub97c \uc800\uc7a5\ud558\ub294 \uc791\uc5c5 \ud14c\uc774\ube14<\/li>\n<li>\uad6c\uccb4\ud654\ub41c \uc815\uc801 \ucee4\uc11c<\/li>\n<\/ul>\n<p>SQL Server\ub294 tempdb \ud2b8\ub79c\uc7ad\uc158 \ub85c\uadf8\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubcf5\uad6c\ud558\ub294 \ub3d9\uc548 \ud2b8\ub79c\uc7ad\uc158\uc744 \ub864\ubc31\ud558\ub294 \ub370\ub294 \ucda9\ubd84\ud558\uc9c0\ub9cc \ud2b8\ub79c\uc7ad\uc158\uc744 \ub2e4\uc2dc \uc2e4\ud589\ud558\uc9c0\ub294 \uc54a\ub294 \uc815\ubcf4\ub9cc \uae30\ub85d\ud569\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 tempdb\uc5d0\uc11c INSERT \ubb38\uc758 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4. \ub610\ud55c SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud560 \ub54c\ub9c8\ub2e4 tempdb\ub97c \ub2e4\uc2dc \ub9cc\ub4e4\uae30 \ub54c\ubb38\uc5d0 \ud2b8\ub79c\uc7ad\uc158\uc744 \ub2e4\uc2dc \uc218\ud589\ud558\ub294 \uc815\ubcf4\ub294 \uae30\ub85d\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub864\ud3ec\uc6cc\ub4dc \ub610\ub294 \ub864\ubc31\uc744 \uc704\ud55c \ud2b8\ub79c\uc7ad\uc158\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. SQL Server\ub97c \uc2dc\uc791\ud558\uba74 \ubaa8\ub378 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc0ac\ubcf8\uc744 \uc0ac\uc6a9\ud558\uc5ec tempdb\uac00 \ub2e4\uc2dc \ub9cc\ub4e4\uc5b4\uc9c0\uace0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uad6c\uc131\ud55c \ud06c\uae30\ub85c \ub2e4\uc2dc \uc124\uc815\ub429\ub2c8\ub2e4.<\/p>\n<p>\uae30\ubcf8\uc801\uc73c\ub85c tempdb \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud544\uc694\uc5d0 \ub530\ub77c \uc790\ub3d9\uc73c\ub85c \uc99d\uac00\ud558\ub3c4\ub85d \uad6c\uc131\ub429\ub2c8\ub2e4. \uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5b8\uc820\uac00\ub294 \uc6d0\ud558\ub294 \ud06c\uae30\ubcf4\ub2e4 \ub354 \ucee4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud558\uba74 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uad6c\uc131\ud55c \ud06c\uae30\ub85c tempdb \ud06c\uae30\uac00 \ub2e4\uc2dc \uc124\uc815\ub429\ub2c8\ub2e4. \uad6c\uc131\ub41c \ud06c\uae30\ub294 MODIFY FILE \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c ALTER DATABASE \ub610\ub294 DBCC SHRINKFILE \ubb38 \uac19\uc740 \ud30c\uc77c \ud06c\uae30 \ubcc0\uacbd \uc791\uc5c5\uc744 \ud1b5\ud574 \uba85\uc2dc\uc801\uc73c\ub85c \uc124\uc815\ud55c \ub9c8\uc9c0\ub9c9 \ud06c\uae30\uc785\ub2c8\ub2e4. \uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 tempdb\ub97c \ucd95\uc18c\ud558\uc5ec \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uad6c\uc131\ud55c \ud06c\uae30\ubcf4\ub2e4 \uc791\uac8c \ub9cc\ub4dc\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<div id=\"bookmark-3\"><\/div>\n<h3 class=\"sbody-h3\">Tempdb\ub97c \ucd95\uc18c\ud558\ub294 \ubc29\ubc95 1<\/h3>\n<p>\uc774 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<ol class=\"sbody-num_list\">\n<li>SQL Server\ub97c \uc911\uc9c0\ud569\ub2c8\ub2e4. \uba85\ub839 \ud504\ub86c\ud504\ud2b8\ub97c \uc5f4\uace0 \ub2e4\uc74c \uba85\ub839\uc744 \uc785\ub825\ud558\uc5ec SQL Server\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4.\n<p><span class=\"sbody-userinput\">sqlservr -c -f <\/span><\/p>\n<p><span class=\"sbody-italic\">-c<\/span> \ubc0f <span class=\"sbody-italic\">-f<\/span> \ub9e4\uac1c \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 SQL Server\uac00 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc704\ud574 1MB, \ub85c\uadf8 \ud30c\uc77c\uc744 \uc704\ud574 0.5MB\uc758 <span class=\"text-base\">tempdb<\/span>\ud06c\uae30\ub97c \uac16\ub294 \ucd5c\uc18c \uad6c\uc131 \ubaa8\ub4dc\ub85c \uc2dc\uc791\ub429\ub2c8\ub2e4.<\/p>\n<p><span class=\"text-base\">\ucc38\uace0<\/span>: SQL Server \uba85\ub839 \uc778\uc2a4\ud134\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc801\uc808\ud55c \ud3f4\ub354(<span class=\"text-base\">Program Files\\Microsoft SQL Server\\MSSQL$instance name\\Binn<\/span>)\ub85c \ubcc0\uacbd\ud558\uace0 <span class=\"sbody-italic\">-s<\/span> \uc2a4\uc704\uce58(-s%instance_name%)\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li>\ucffc\ub9ac \ubd84\uc11d\uae30\uac00 \uc788\ub294 SQL Server\uc5d0 \uc5f0\uacb0\ud558\uace0 \ub2e4\uc74c Transact-SQL \uba85\ub839\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4.\n<div class=\"sbody-code\">\n<pre><code>\r\n   ALTER DATABASE tempdb MODIFY FILE\r\n   (NAME = 'tempdev', SIZE = target_size_in_MB) \r\n   --Desired target size for the data file\r\n\r\n   ALTER DATABASE tempdb MODIFY FILE\r\n   (NAME = 'templog', SIZE = target_size_in_MB)\r\n   --Desired target size for the log file\r\n\t\t\t\t\t<\/code><\/pre>\n<\/div>\n<\/li>\n<li>\uba85\ub839 \ud504\ub86c\ud504\ud2b8 \ucc3d\uc5d0\uc11c <span class=\"text-base\">Ctrl-C<\/span>\ub97c \ub20c\ub7ec SQL Server\ub97c \uc911\uc9c0\ud558\uace0 SQL Server\ub97c \uc11c\ube44\uc2a4\ub85c \ub2e4\uc2dc \uc2dc\uc791\ud55c \ub2e4\uc74c Tempdb.mdf \ubc0f Templog.ldf \ud30c\uc77c \ud06c\uae30\ub97c \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc774 \ubc29\ubc95\uc758 \ud55c\uacc4\ub294 \uae30\ubcf8 <span class=\"text-base\">tempdb<\/span> \ub17c\ub9ac \ud30c\uc77c\uc778 <span class=\"text-base\">tempdev<\/span> \ubc0f <span class=\"text-base\">templog<\/span>\uc5d0\uc11c\ub9cc \uc791\ub3d9\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <span class=\"text-base\">tempdb<\/span>\uc5d0 \ud30c\uc77c\uc744 \ucd94\uac00\ud55c \uacbd\uc6b0 SQL Server\ub97c \uc11c\ube44\uc2a4\ub85c \ub2e4\uc2dc \uc2dc\uc791\ud55c \ud6c4\uc5d0 \ucd95\uc18c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2dc\uc791\ud558\ub294 \ub3d9\uc548 \ubaa8\ub4e0 <span class=\"text-base\">tempdb<\/span> \ud30c\uc77c\uc774 \ub2e4\uc2dc \ub9cc\ub4e4\uc5b4\uc9d1\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud30c\uc77c\uc5d0\ub294 \uc544\ubb34\ub7f0 \ub0b4\uc6a9\uc774 \uc5c6\uc73c\ubbc0\ub85c \ucd94\uac00\ub41c \ud30c\uc77c\uc744 \uc81c\uac70\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <span class=\"text-base\">tempdb<\/span>\uc5d0\uc11c \ucd94\uac00 \ud30c\uc77c\uc744 \uc81c\uac70\ud558\ub824\uba74 ALTER DATABASE \uba85\ub839\uc744 REMOVE FILE \uc635\uc158\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud558\uc2ed\uc2dc\uc624.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<div id=\"bookmark-4\"><\/div>\n<h3 class=\"sbody-h3\">Tempdb\ub97c \ucd95\uc18c\ud558\ub294 \ubc29\ubc95 2<\/h3>\n<p>DBCC SHRINKDATABASE \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec <span class=\"text-base\">tempdb<\/span> \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \ucd95\uc18c\ud569\ub2c8\ub2e4. DBCC SHRINKDATABASE\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud55c \ud6c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc5d0 \ub0a8\ub294 \uc5ec\uc720 \uacf5\uac04\uc758 \uc6d0\ud558\ub294 \ubc31\ubd84\uc728\uc778 \ub9e4\uac1c \ubcc0\uc218 <span class=\"sbody-italic\">target_percent<\/span>\ub97c \ubc1b\uc2b5\ub2c8\ub2e4. DBCC SHRINKDATABASE\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><span class=\"text-base\">\uc911\uc694<\/span>: DBCC SHRINKDATABASE\ub97c \uc2e4\ud589\ud558\uba74 <span class=\"text-base\">tempdb<\/span> \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\ub978 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. DBCC SHRINKDATABASE\ub97c \uc2e4\ud589\ud558\ub294 \ub3d9\uc548 \ub2e4\ub978 \ud504\ub85c\uc138\uc2a4\uc5d0\uc11c <span class=\"text-base\">tempdb<\/span>\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub3c4\ub85d \ud558\ub824\uba74 SQL Server\ub97c \ub2e8\uc77c \uc0ac\uc6a9\uc790 \ubaa8\ub4dc\uc5d0\uc11c \uc2dc\uc791\ud574\uc57c \ud569\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ubcf8 \ubb38\uc11c\uc758 <a id=\"kb-link-8\" class=\"sbody-bookref\" href=\"https:\/\/support.microsoft.com\/\">Tempdb\ub97c \uc0ac\uc6a9\ud558\ub294 \ub3d9\uc548 DBCC SHRINKDATABASE \ub610\ub294 DBCCSHRINKFILE\uc758 \uc2e4\ud589 \ud6a8\uacfc<\/a> \uc808\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624.<\/p>\n<ol class=\"sbody-num_list\">\n<li><span class=\"text-base\">sp_spaceused<\/span> \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc0ac\uc6a9\ud558\uc5ec <span class=\"text-base\">tempdb<\/span>\uc5d0\uc11c \ud604\uc7ac \uc0ac\uc6a9\ub418\ub294 \uacf5\uac04\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c DBCC SHRINKDATABASE\uc5d0 \ub300\ud55c \ub9e4\uac1c \ubcc0\uc218\ub85c \uc0ac\uc6a9\ud560 \ub0a8\uc740 \uc5ec\uc720 \uacf5\uac04\uc758 \ubc31\ubd84\uc728\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4. \uc774 \uacc4\uc0b0\uc740 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud06c\uae30\uc758 \uae30\uc900\uc774 \ub429\ub2c8\ub2e4.\n<p><span class=\"text-base\">\ucc38\uace0<\/span>: \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc0ac\uc6a9\ub418\ub294 \uacf5\uac04\uc744 \ub2e4\uc2dc \uacc4\uc0b0\ud558\uace0 \uc5c5\ub370\uc774\ud2b8\ub41c \ubcf4\uace0\uc11c\ub97c \uc5bb\uc73c\ub824\uba74 <span class=\"text-base\">sp_spaceused @updateusage=true<\/span>\ub97c \uc2e4\ud589\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <span class=\"text-base\">sp_spaceused<\/span> \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 SQL Server \uc628\ub77c\uc778 \uc124\uba85\uc11c\ub97c \ucc38\uc870\ud558\uc2ed\uc2dc\uc624.<\/p>\n<p>\ub2e4\uc74c \uc608\uc81c\ub97c \uace0\ub824\ud558\uc2ed\uc2dc\uc624.<\/p>\n<div class=\"indent\"><span class=\"text-base\">tempdb<\/span>\uc5d0 100MB \ud06c\uae30\uc758 \uc8fc \ub370\uc774\ud130 \ud30c\uc77c(Tempdb.mdf)\uacfc 30MB \ud06c\uae30\uc758 \ub85c\uadf8 \ud30c\uc77c(Tempdb.ldf)\uc774 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4. <span class=\"text-base\">sp_spaceused<\/span>\uac00 \uc8fc \ub370\uc774\ud130 \ud30c\uc77c\uc5d0 60MB\uc758 \ub370\uc774\ud130\uac00 \ub4e4\uc5b4 \uc788\ub2e4\uace0 \ubcf4\uace0\ud558\ub294 \uac83\uc73c\ub85c \uac00\uc815\ud569\ub2c8\ub2e4. \ub610\ud55c \uc8fc \ub370\uc774\ud130 \ud30c\uc77c\uc744 80MB\ub85c \ucd95\uc18c\ud558\uae38 \uc6d0\ud55c\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4. \ucd95\uc18c\ud55c \ud6c4\uc5d0 \ub0a8\uc740 \uc5ec\uc720 \uacf5\uac04\uc758 \uc6d0\ud558\ub294 \ubc31\ubd84\uc728\uc744 \uacc4\uc0b0\ud558\uba74, 80MB &#8211; 60MB = 20MB\uc774\uace0 \uc774\uc81c 80MB\ub97c 20MB\ub85c \ub098\ub204\uba74 25%\uc774\uba70 \uc774\uac83\uc774 <span class=\"sbody-italic\">target_percent<\/span>\uc785\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158 \ub85c\uadf8 \ud30c\uc77c\uc740 \uc774\uc5d0 \ub530\ub77c \ucd95\uc18c\ub418\uc5b4, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud55c \ud6c4\uc5d0\ub294 25% \ub610\ub294 20MB\uc758 \uc5ec\uc720 \uacf5\uac04\uc774 \ub0a8\uc2b5\ub2c8\ub2e4.<\/div>\n<\/li>\n<li>\ucffc\ub9ac \ubd84\uc11d\uae30\uac00 \uc788\ub294 SQL Server\uc5d0 \uc5f0\uacb0\ud558\uace0 \ub2e4\uc74c Transact-SQL \uba85\ub839\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4.\n<div class=\"sbody-code\">\n<pre><code>\r\n   dbcc shrinkdatabase (tempdb, 'target percent') \r\n   -- This command shrinks the tempdb database as a whole\r\n\t\t\t\t\t<\/code><\/pre>\n<\/div>\n<\/li>\n<\/ol>\n<p><span class=\"text-base\">tempdb<\/span> \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c DBCC SHRINKDATABASE \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\ub294 \ub370\ub294 \uc81c\ud55c\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\uc640 \ub85c\uadf8 \ud30c\uc77c\uc758 \ub300\uc0c1 \ud06c\uae30\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e4 \ub54c \uc9c0\uc815\ud55c \ud06c\uae30 \ub610\ub294 MODIFY FILE \uc635\uc158\uc744 \uc0ac\uc6a9\ud55c ALTER DATABASE \ub610\ub294 DBCC SHRINKFILE \uba85\ub839 \uac19\uc740 \ud30c\uc77c \ud06c\uae30 \ubcc0\uacbd \uc791\uc5c5\uc73c\ub85c \uba85\uc2dc\uc801\uc73c\ub85c \uc124\uc815\ud55c \ub9c8\uc9c0\ub9c9 \ud06c\uae30\ubcf4\ub2e4 \uc791\uac8c \ub9cc\ub4e4 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. DBCC SHRINKDATABASE\uc758 \ub610 \ub2e4\ub978 \uc81c\ud55c\uc740 <span class=\"sbody-italic\">target_percentage<\/span> \ub9e4\uac1c \ubcc0\uc218\uc758 \uacc4\uc0b0\uacfc \ud604\uc7ac \uc0ac\uc6a9\ub41c \uacf5\uac04\uc5d0 \ub300\ud55c \uc885\uc18d\uc131\uc785\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<div id=\"bookmark-5\"><\/div>\n<h3 class=\"sbody-h3\">Tempdb\ub97c \ucd95\uc18c\ud558\ub294 \ubc29\ubc95 3<\/h3>\n<p>\uba85\ub839 DBCC SHRINKFILE\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac1c\ubcc4 <span class=\"text-base\">tempdb<\/span> \ud30c\uc77c\uc744 \ucd95\uc18c\ud569\ub2c8\ub2e4. DBCC SHRINKFILE\uc740 \uac19\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc18d\ud558\ub294 \ub2e4\ub978 \ud30c\uc77c\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uace0 \ub2e8\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 DBCC SHRINKDATABASE\ubcf4\ub2e4 \uc720\uc5f0\uc131\uc774 \ub6f0\uc5b4\ub0a9\ub2c8\ub2e4. DBCC SHRINKFILE\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc758 \uc6d0\ud558\ub294 \ucd5c\uc885 \ud06c\uae30\uc778 <span class=\"sbody-italic\">\ub300\uc0c1 \ud06c\uae30<\/span> \ub9e4\uac1c \ubcc0\uc218\ub97c \ubc1b\uc2b5\ub2c8\ub2e4.<\/p>\n<p><span class=\"text-base\">\uc911\uc694<\/span>: DBCC SHRINKFILE \uba85\ub839\uc744 \uc2e4\ud589\ud558\ub294 \ub3d9\uc548\uc5d0\ub294 <span class=\"text-base\">tempdb<\/span> \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc544\ubb34\ub7f0 \uc791\uc5c5\ub3c4 \ud558\uc9c0 \ub9d0\uc544\uc57c \ud569\ub2c8\ub2e4. DBCC SHRINKFILE\uc744 \uc2e4\ud589\ud558\ub294 \ub3d9\uc548 \ub2e4\ub978 \ud504\ub85c\uc138\uc2a4\uac00 <span class=\"text-base\">tempdb<\/span>\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub3c4\ub85d \ud558\ub824\uba74 SQL Server\ub97c \ub2e8\uc77c \uc0ac\uc6a9\uc790 \ubaa8\ub4dc\uc5d0\uc11c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud569\ub2c8\ub2e4. DBCC SHRINKFILE\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ubcf8 \ubb38\uc11c\uc758 <a id=\"kb-link-9\" class=\"sbody-bookref\" href=\"https:\/\/support.microsoft.com\/\">Tempdb\ub97c \uc0ac\uc6a9\ud558\ub294 \ub3d9\uc548 DBCC SHRINKDATABASE \ub610\ub294 DBCCSHRINKFILE\uc758 \uc2e4\ud589 \ud6a8\uacfc<\/a> \uc808\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624.<\/p>\n<ol class=\"sbody-num_list\">\n<li>\uc8fc \ub370\uc774\ud130 \ud30c\uc77c(tempdb.mdf), \ub85c\uadf8 \ud30c\uc77c(templog.ldf) \ubc0f\/\ub610\ub294 <span class=\"text-base\">tempdb<\/span>\uc5d0 \ucd94\uac00\ud55c \ud30c\uc77c\uc5d0 \ub300\ud574 \uc6d0\ud558\ub294 \ud06c\uae30\ub97c \uacb0\uc815\ud569\ub2c8\ub2e4. \ud30c\uc77c\uc5d0 \uc0ac\uc6a9\ub418\ub294 \uacf5\uac04\uc740 \uc6d0\ud558\ub294 \ub300\uc0c1 \ud06c\uae30\ubcf4\ub2e4 \uc791\uac70\ub098 \uac19\uc544\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li>\ucffc\ub9ac \ubd84\uc11d\uae30\uac00 \uc788\ub294 SQL Server\uc5d0 \uc5f0\uacb0\ud558\uace0 \ucd95\uc18c\ud560 \ud544\uc694\uac00 \uc788\ub294 \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc5d0 \ub300\ud574 \ub2e4\uc74c Transact-SQL \uba85\ub839\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4.\n<div class=\"sbody-code\">\n<pre><code>\r\n   use tempdb\r\n   go\r\n\r\n   dbcc shrinkfile (tempdev, 'target size in MB')\r\n   go\r\n   -- this command shrinks the primary data file\r\n\r\n   dbcc shrinkfile (templog, 'target size in MB')\r\n   go\r\n   -- this command shrinks the log file, look at the last paragraph.\r\n\t\t\t\t\t\t<\/code><\/pre>\n<\/div>\n<\/li>\n<\/ol>\n<p>DBCC SHRINKFILE\uc758 \uc7a5\uc810\uc740 \ud30c\uc77c \ud06c\uae30\ub97c \uc6d0\ub798 \ud06c\uae30\ubcf4\ub2e4 \uc791\uac8c \uc904\uc77c \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \ub610\ub294 \ub85c\uadf8 \ud30c\uc77c\uc5d0\uc11c DBCC SHRINKFILE\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 . DBCC SHRINKFILE\uc758 \ud55c\uacc4\ub294 \ubaa8\ub378 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud06c\uae30\ubcf4\ub2e4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub354 \uc791\uac8c \ub9cc\ub4e4 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>SQL Server 7.0\uc5d0\uc11c \ud2b8\ub79c\uc7ad\uc158 \ub85c\uadf8 \ucd95\uc18c\ub294 \uc9c0\uc5f0\ub418\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ucd95\uc18c \uc791\uc5c5\uc744 \uc6a9\uc774\ud558\uac8c \ud558\ub824\uba74 \ub85c\uadf8 \uc798\ub77c\ub0b4\uae30 \ubc0f \ubc31\uc5c5\uc744 \uc2e4\ud589\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uae30\ubcf8\uc801\uc73c\ub85c <span class=\"text-base\">tempdb<\/span>\uc5d0\ub294 <span class=\"text-base\">trunc log on chkpt<\/span> \uc635\uc158\uc774 ON\uc73c\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ud574\ub2f9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574\uc11c\ub294 \ub85c\uadf8 \uc798\ub77c\ub0b4\uae30\ub97c \uc2e4\ud589\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. SQL Server 7.0\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud2b8\ub79c\uc7ad\uc158 \ub85c\uadf8\ub97c \ucd95\uc18c\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 Microsoft \uae30\uc220 \uc790\ub8cc\uc758 \ub2e4\uc74c \ubb38\uc11c\ub97c \ucc38\uc870\ud558\uc2ed\uc2dc\uc624.<\/p>\n<div class=\"indent\"><a id=\"kb-link-10\" href=\"https:\/\/support.microsoft.com\/ko-kr\/kb\/256650\">256650<\/a> INF: SQL Server 7.0 \ud2b8\ub79c\uc7ad\uc158 \ub85c\uadf8\ub97c \uc904\uc774\ub294 \ubc29\ubc95<\/div>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<div id=\"bookmark-6\"><\/div>\n<h3 class=\"sbody-h3\">Tempdb\ub97c \uc0ac\uc6a9\ud558\ub294 \ub3d9\uc548 DBCC SHRINKDATABASE \ub610\ub294 DBCCSHRINKFILE\uc758 \uc2e4\ud589 \ud6a8\uacfc<\/h3>\n<p><span class=\"text-base\">tempdb<\/span>\ub97c \uc0ac\uc6a9 \uc911\uc774\uace0 DBCC SHRINKDATABASE \ub610\ub294 DBCC SHRINKFILE \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucd95\uc18c\ub97c \uc2dc\ub3c4\ud558\ub294 \uacbd\uc6b0 \ub2e4\uc74c \uc720\ud615\uacfc \ube44\uc2b7\ud55c \uc5ec\ub7ec \uac00\uc9c0 \uc77c\uad00\uc131 \uc624\ub958\uac00 \ub098\ud0c0\ub0a0 \uc218 \uc788\uc73c\uba70 \ucd95\uc18c \uc791\uc5c5\uc774 \uc2e4\ud328\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"sbody-error\">Server: Msg 2501, Level 16, State 1, Line 1 Could not find table named &#8216;1525580473&#8217;. Check sysobjects.<\/div>\n<div class=\"indent\">\ub610\ub294<\/div>\n<div class=\"sbody-error\">Server: Msg 8909, Level 16, State 1, Line 0 Table Corrupt: Object ID 1, index ID 0, page ID %S_PGID. The PageId in the page header = %S_PGID.<\/div>\n<p>\uc624\ub958 2501\uc740 <span class=\"text-base\">tempdb<\/span>\uc758 \uc190\uc0c1\uc744 \ub098\ud0c0\ub0b4\ub294 \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc \ucd95\uc18c \uc791\uc5c5\uc744 \uc2e4\ud328\ud558\uac8c \ub9cc\ub4ed\ub2c8\ub2e4. \ubc18\uba74\uc5d0 \uc624\ub958 8909\ub294<span class=\"text-base\">tempdb<\/span> \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc190\uc0c1\uc744 \ub098\ud0c0\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud558\uc5ec <span class=\"text-base\">tempdb<\/span>\ub97c \ub2e4\uc2dc \ub9cc\ub4e4\uace0 \uc77c\uad00\uc131 \uc624\ub958\ub97c \ud574\uacb0\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc624\ub958 8909 \uac19\uc740 \uc2e4\uc81c \ub370\uc774\ud130 \uc190\uc0c1 \uc624\ub958\uc5d0\ub294 \ub2e4\ub978 \uc6d0\uc778\uc774 \uc788\uc744 \uc218 \uc788\uc73c\uba70 \uc5ec\uae30\uc5d0\ub294 \uc785\/\ucd9c\ub825 \ud558\uc704 \uc2dc\uc2a4\ud15c \ubb38\uc81c\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<div id=\"bookmark-7\"><\/div>\n<h3 class=\"sbody-h3\">\ucc38\uc870<\/h3>\n<p>SQL \uc11c\ubc84 \uc628\ub77c\uc778 \uc124\uba85\uc11c \ud56d\ubaa9: &#8220;DBCC SHRINKFILE&#8221;; &#8220;DBCC SHRINKDATABASE&#8221;<\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/#toc\" name=\"bottom\">\ub9e8 \uc704\ub85c<\/a><\/p>\n<p><span class=\"text-base\">Microsoft \uc81c\ud488 \uad00\ub828 \uae30\uc220 \uc804\ubb38\uac00\ub4e4\uacfc \uc628\ub77c\uc778\uc73c\ub85c \uc815\ubcf4\ub97c \uad50\ud658\ud558\uc2dc\ub824\uba74 <a id=\"kb-link-11\" href=\"http:\/\/support.microsoft.com\/newsgroups\/default.aspx\" target=\"_self\">Microsoft \ub274\uc2a4 \uadf8\ub8f9<\/a>\uc5d0 \ucc38\uc5ec\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\ucc38\uace0)\u00a0https:\/\/support.microsoft.com\/ko-kr\/kb\/307487<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc694\uc57d \uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 tempdb \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud558\uc5ec \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uad6c\uc131\ud55c \ud06c\uae30\ubcf4\ub2e4 \uc791\uac8c \ub9cc\ub4dc\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4. \uccab \ubc88\uc9f8 \ubc29\ubc95\uc740 tempdb \ud30c\uc77c\uc758 \ud06c\uae30\ub97c \uc644\ubcbd\ud558\uac8c \uc81c\uc5b4\ud560 \uc218 \uc788\uc9c0\ub9cc SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud569\ub2c8\ub2e4. \ub450 \ubc88\uc9f8 \ubc29\ubc95\uc740 \uba87 \uac00\uc9c0 \uc81c\ud55c\uc740 \uc788\uc9c0\ub9cc tempdb\ub97c \uc804\uccb4\uc801\uc73c\ub85c \ucd95\uc18c\ud558\uba70 SQL Server\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc138 \ubc88\uc9f8 \ubc29\ubc95\uc744 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[176],"class_list":["post-2113","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-ms-sql"],"_links":{"self":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/2113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2113"}],"version-history":[{"count":1,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/2113\/revisions"}],"predecessor-version":[{"id":2114,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/2113\/revisions\/2114"}],"wp:attachment":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}