{"id":484,"date":"2025-07-16T12:34:57","date_gmt":"2025-07-16T03:34:57","guid":{"rendered":"https:\/\/sejiwon.com\/?p=484"},"modified":"2025-07-16T12:41:39","modified_gmt":"2025-07-16T03:41:39","slug":"mssql%ec%97%90%ec%84%9c-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%95%95%ec%b6%95%ec%8b%9c-%ed%8e%98%ec%9d%b4%ec%a7%80%eb%8b%a8%ec%9c%84%ec%99%80-%eb%a1%9c%ec%9a%b0%eb%8b%a8%ec%9c%84-%ec%96%b4%eb%8a%90%ea%b2%8c","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=484","title":{"rendered":"MSSQL\uc5d0\uc11c \ud14c\uc774\ube14\uc555\ucd95\uc2dc \ud398\uc774\uc9c0\ub2e8\uc704\uc640 \ub85c\uc6b0\ub2e8\uc704 \uc5b4\ub290\uac8c \ub354 \uc720\ub9ac\ud55c\uac00?"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u2705 1. Row Compression (\ub85c\uc6b0 \uc555\ucd95)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 \uc791\ub3d9 \ubc29\uc2dd<\/h3>\n\n\n\n<ul>\n<li>\uace0\uc815 \uae38\uc774 \ub370\uc774\ud130\ub97c \uac00\ubcc0 \uae38\uc774\ub85c \uc800\uc7a5\ud558\uc5ec \uacf5\uac04 \uc808\uc57d<\/li>\n\n\n\n<li>\uc608: <code>CHAR(100)<\/code> \u2192 \uc2e4\uc81c \uac12\uc774 10\uc790\uc77c \uacbd\uc6b0, 10\uc790\ub9cc \uc800\uc7a5<\/li>\n\n\n\n<li>NULL \ubc0f 0 \uac12\uc744 \ub354 \uac04\ub2e8\ud558\uac8c \uc800\uc7a5<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 \uc7a5\uc810<\/h3>\n\n\n\n<ul>\n<li>CPU \ubd80\ud558\uac00 \uc801\uc74c<\/li>\n\n\n\n<li>\uc131\ub2a5\uc5d0 \uac70\uc758 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uc74c<\/li>\n\n\n\n<li>\uc77d\uae30\/\uc4f0\uae30 \uc18d\ub3c4 \uc800\ud558\uac00 \ud06c\uc9c0 \uc54a\uc74c<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 \ub2e8\uc810<\/h3>\n\n\n\n<ul>\n<li>\uc555\ucd95\ub960\uc774 \ub0ae\uc74c (\ubcf4\ud1b5 10~25%)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 2. Page Compression (\ud398\uc774\uc9c0 \uc555\ucd95)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 \uc791\ub3d9 \ubc29\uc2dd<\/h3>\n\n\n\n<ul>\n<li>Row \uc555\ucd95 + \ucd94\uac00\ub85c <strong>\ud328\ud134 \uc778\uc2dd(Dictionary encoding, Prefix compression \ub4f1)<\/strong> \uc744 \ud1b5\ud574 \uc911\ubcf5 \uc81c\uac70<\/li>\n\n\n\n<li>\ud558\ub098\uc758 \ud398\uc774\uc9c0 \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\uc758 \uacf5\ud1b5 \ubd80\ubd84\uc744 \ucc3e\uc544 \uc555\ucd95<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 \uc7a5\uc810<\/h3>\n\n\n\n<ul>\n<li>\uc555\ucd95\ub960\uc774 \ub192\uc74c (\ubcf4\ud1b5 30~70%)<\/li>\n\n\n\n<li>\uc800\uc7a5 \uacf5\uac04 \ud06c\uac8c \uc808\uc57d<\/li>\n\n\n\n<li>IO \uc904\uc5b4\ub4e4\uc5b4 \uc77d\uae30 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub418\ub294 \uacbd\uc6b0 \uc788\uc74c<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 \ub2e8\uc810<\/h3>\n\n\n\n<ul>\n<li>CPU \ubd80\ud558 \ud07c (\uc77d\uae30\/\uc4f0\uae30\/\uc555\ucd95 \uc2dc \ubaa8\ub450)<\/li>\n\n\n\n<li>INSERT\/UPDATE\uac00 \ube48\ubc88\ud55c \uacbd\uc6b0 \uc131\ub2a5 \uc800\ud558 \uac00\ub2a5<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udd9a \uc5b8\uc81c \ubb34\uc5c7\uc744 \uc120\ud0dd\ud560\uae4c?<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc0c1\ud669<\/th><th>\uad8c\uc7a5 \uc555\ucd95 \ubc29\uc2dd<\/th><\/tr><\/thead><tbody><tr><td>\uc77d\uae30 \uc704\uc8fc\uc758 \ud14c\uc774\ube14 (OLAP, DW)<\/td><td>\u2705 Page \uc555\ucd95<\/td><\/tr><tr><td>\uc790\uc8fc \uac31\uc2e0\ub418\uac70\ub098 \uc4f0\uae30\uac00 \ub9ce\uc740 \ud14c\uc774\ube14 (OLTP)<\/td><td>\u2705 Row \uc555\ucd95 \ub610\ub294 \uc555\ucd95 \uc5c6\uc74c<\/td><\/tr><tr><td>\uacf5\uac04 \uc808\uc57d\uc774 \ucd5c\uc6b0\uc120<\/td><td>\u2705 Page \uc555\ucd95<\/td><\/tr><tr><td>\uc131\ub2a5\uc774 \ucd5c\uc6b0\uc120<\/td><td>\u2705 Row \uc555\ucd95 \ub610\ub294 \uc555\ucd95 \uc5c6\uc74c<\/td><\/tr><tr><td>\ud14c\uc2a4\ud2b8 \uc6a9\ub3c4\ub85c \uc810\uc9c4\uc801 \uc801\uc6a9<\/td><td>\u2705 Row \uc555\ucd95\ubd80\ud130 \uc2dc\ub3c4 \ud6c4 \ubd84\uc11d<\/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\">\ud83c\udfaf \uc2e4\uc804 \ud301<\/h2>\n\n\n\n<ul>\n<li><strong><code>sp_estimate_data_compression_savings<\/code><\/strong> \uc2dc\uc2a4\ud15c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc0ac\uc6a9\ud558\uba74 Row, Page \uc555\ucd95\uc744 \uc801\uc6a9\ud588\uc744 \ub54c \uc608\uc0c1\ub418\ub294 \uacf5\uac04 \uc808\uc57d\ub7c9\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>EXEC sp_estimate_data_compression_savings \n    @schema_name = 'dbo', \n    @object_name = 'YourTableName',\n    @index_id = NULL, \n    @partition_number = NULL, \n    @data_compression = 'PAGE';\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\">\ud83d\udd1a \uacb0\ub860<\/h2>\n\n\n\n<ul>\n<li><strong>\uc77d\uae30 \uc704\uc8fc, \ub300\ub7c9 \ub370\uc774\ud130 \u2192 Page \uc555\ucd95 \uc720\ub9ac<\/strong><\/li>\n\n\n\n<li><strong>\uc4f0\uae30\/\uac31\uc2e0 \ub9ce\uc740 OLTP \ud14c\uc774\ube14 \u2192 Row \uc555\ucd95 \ub610\ub294 \uc555\ucd95 \uc5c6\uc774 \uc6b4\uc601<\/strong><\/li>\n\n\n\n<li>\ud14c\uc2a4\ud2b8\ub85c \uc555\ucd95 \uc774\uc810 \ud655\uc778 \ud6c4 \uc801\uc6a9\uc774 \uac00\uc7a5 \uc548\uc804<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u2705 1. Row Compression (\ub85c\uc6b0 \uc555\ucd95) \ud83d\udd39 \uc791\ub3d9 \ubc29\uc2dd \ud83d\udd39 \uc7a5\uc810 \ud83d\udd39 \ub2e8\uc810 \u2705 2. Page Compression (\ud398\uc774\uc9c0 \uc555\ucd95) \ud83d\udd39 \uc791\ub3d9 \ubc29\uc2dd \ud83d\udd39 \uc7a5\uc810 \ud83d\udd39 \ub2e8\uc810 \ud83c\udd9a \uc5b8\uc81c \ubb34\uc5c7\uc744 \uc120\ud0dd\ud560\uae4c? \uc0c1\ud669 \uad8c\uc7a5 \uc555\ucd95 \ubc29\uc2dd \uc77d\uae30 \uc704\uc8fc\uc758 \ud14c\uc774\ube14 (OLAP, DW) \u2705 Page \uc555\ucd95 \uc790\uc8fc \uac31\uc2e0\ub418\uac70\ub098 \uc4f0\uae30\uac00 \ub9ce\uc740 \ud14c\uc774\ube14 (OLTP) \u2705 Row \uc555\ucd95 \ub610\ub294 \uc555\ucd95 \uc5c6\uc74c \uacf5\uac04\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=484\">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\/484"}],"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=484"}],"version-history":[{"count":2,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/484\/revisions"}],"predecessor-version":[{"id":490,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/484\/revisions\/490"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}