CloudON for SQL Migration : 2wk Assessment

์”จ์•คํ† ํŠธ

Azure SQL์€ Azure ํด๋ผ์šฐ๋“œ์—์„œ SQL Server ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์—”์ง„์— ๊ธฐ๋ฐ˜ํ•œ ์•ˆ์ „ํ•œ ๊ด€๋ฆฌํ˜• ์ง€๋Šฅํ˜• ์ œํ’ˆ๋“ค์„ ์•„์šฐ๋ฅด๋Š” ์ œํ’ˆ๊ตฐ์ž…๋‹ˆ๋‹ค. ์”จ์•คํ† ํŠธ๋งŒ์˜ ๋งค๋‹ˆ์ง€๋“œ ์„œ๋น„์Šค CloudON์„ ํ†ตํ•ด ๋งž์ถคํ˜• SQL Migration ํ™˜๊ฒฝ ๋ถ„์„ ๋ฐ ๊ตฌ์ถ• ๊ด€๋ฆฌ๋ฐฉ์•ˆ์„ ์ œ์‹œํ•ฉ๋‹ˆ๋‹ค.

"This offer is only available in Korean Language"

์”จ์•คํ† ํŠธ์˜ ๋…ธํ•˜์šฐ๊ฐ€ ๊ฒฐ์ง‘๋œ ๋งค๋‹ˆ์ง€๋“œ ์„œ๋น„์Šค CloudON ์„œ๋น„์Šค๋Š” IT ํ™˜๊ฒฝ ๋ถ„์„ํ•˜๊ณ  ๊ฒ€์ฆ/๋ถ„์„/์„ฑ๋Šฅ ํ…Œ์ŠคํŠธ๋ฅผ ํ†ตํ•ด ๊ณ ๊ฐ์ด ๋งŒ์กฑํ•˜๋Š” ์ตœ์ ์˜ ๊ตฌ์„ฑ์„ ๊ตฌํ˜„ํ•ฉ๋‹ˆ๋‹ค.

Azure SQL ASP์ธ ์”จ์•คํ† ํŠธ์˜ ์ „๋ฌธ DBA ๋“ค์ด ์ง์ ‘ ๊ธฐ์—…๋ณ„๋กœ ๋ถ„์„ํ•˜์—ฌ ์ปจ์„คํŒ… ํ•ด๋“œ๋ฆฌ๊ณ , ์ตœ์ ์˜ ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜ ๋ฐ ๊ด€๋ฆฌ๋ฐฉ์•ˆ์— ๋Œ€ํ•ด ์•Œ๋ ค๋“œ๋ฆฝ๋‹ˆ๋‹ค. ์”จ์•คํ† ํŠธ๋Š” ๊ณ ๊ฐ์‚ฌ์˜ Vision๊ณผ ๋ชฉํ‘œ๋ฅผ ๋ช…ํ™•ํ•˜๊ฒŒ ์ดํ•ดํ•˜๊ณ  ์žˆ์œผ๋ฉฐ, ๊ณ ๊ฐ์‚ฌ์˜ ์‹œ์Šคํ…œ์„ ์„ฑ๊ณต์ ์œผ๋กœ ๊ตฌ์ถ•ํ•˜๊ธฐ ์œ„ํ•ด ์ค€๋น„๋œ ์‚ฌ์—…์ˆ˜ํ–‰ ์—ญ๋Ÿ‰๊ณผ ์œ ์‚ฌ ํ”„๋กœ์ ํŠธ ์ˆ˜ํ–‰ ๊ฒฝํ—˜์„ ๋ฐ”ํƒ•์œผ๋กœ ์ปจ์„คํŒ…ํ•ด ๋“œ๋ฆฌ๊ฒ ์Šต๋‹ˆ๋‹ค.

๋ณด๋‹ค ์ž์„ธํ•œ ๋‚ด์šฉ์€ ์ฒจ๋ถ€ํ•œ ์†Œ๊ฐœ ๋ฌธ์„œ๋ฅผ ํ™•์ธํ•ด์ฃผ์‹œ๊ธฐ ๋ฐ”๋ž๋‹ˆ๋‹ค.

<<Azure SQL ์ •์˜ ๋ฐ ์ข…๋ฅ˜>>

  1. Server (IaaS)
  • SQL Server ์›Œํฌ๋กœ๋“œ๋ฅผ ์‰ฝ๊ฒŒ ๋ฆฌํ”„ํŠธ & ์‰ฌํ”„ํŠธ ๋ฐฉ์‹์„ ํ†ตํ•ด ์ „ํ™˜ ๊ฐ€๋Šฅํ•˜๋ฉฐ, SQL Server์™€์˜ ์™„๋ฒฝํ•œ ํ˜ธํ™˜์„ฑ ๋ฐ ์šด์˜์ฒด์ œ ์ˆ˜์ค€์˜ ์•ก์„ธ์Šค๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค.
  1. Database (Paas)
  • ์„œ๋ฒ„๋ฆฌ์Šค ์ปดํ“จํŒ…์ด ํฌํ•จ๋œ ์™„์ „๊ด€๋ฆฌํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋น„์Šค์ด๋ฉฐ, SQL Server ์—”์ง„์„ ๊ธฐ๋ฐ˜์œผ๋กœ ํ•˜๋Š” ์ตœ์‹  ํด๋ผ์šฐ๋“œ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์˜ ๊ตฌ์ถ•์— ์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค.
  1. Managed Instance (MI)
  • ์™„์ „๊ด€๋ฆฌํ˜• ์„œ๋น„์Šค ํŠน์ง•๊ณผ SQL Server ์—”์ง„ ํ˜ธํ™˜์„ฑ์„ ๊ฒฐํ•ฉํ•˜์—ฌ ํ™•์žฅ ๊ฐ€๋Šฅํ•˜๋„๋ก ๊ตฌํ˜„๋œ ์ง€๋Šฅํ˜• ํด๋ผ์šฐ๋“œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋น„์Šค์ž…๋‹ˆ๋‹ค. ๊ธฐ์กด SQL ๊ณ ๊ฐ์€ ๋ณ€๊ฒฝ์„ ์ตœ์†Œํ™”ํ•˜์—ฌ ํด๋ผ์šฐ๋“œ๋กœ ์›Œํฌ๋กœ๋“œ๋ฅผ ์ „ํ™˜ํ•˜์‹ค ์ˆ˜ ์žˆ์œผ๋ฉฐ, ๋Œ€๋ถ€๋ถ„์˜ ํด๋ผ์šฐ๋“œ ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜์— ๊ฐ€์žฅ ์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค.

<<๊ฐ ์œ ํ˜•๋ณ„ ์žฅ์ >>

  1. Server (IaaS)
  • ์˜จํ”„๋ ˆ๋ฏธ์Šค SQL Server์™€ ๊ฑฐ์˜ ๋™์ผํ•œ OS ๊ธฐ๋ฐ˜ ํ™˜๊ฒฝ ๊ตฌ์ถ•
  • ๊ฐ„ํŽธํ•œ Disk ํ™•์žฅ (Scale Up, Scale Out)
  • Windows Server Failover Cluster ๊ธฐ๋ฐ˜์˜ SQL ์ด์ค‘ํ™” ๊ตฌ์ถ• ๊ฐ€๋Šฅ
  1. Database (Paas)
  • OS ์ˆ˜์ค€์˜ ๊ด€๋ฆฌ๊ฐ€ ๋ถˆํ•„์š”ํ•œ ์™„์ „ ๊ด€๋ฆฌํ˜• PaaS Single Database
  • ์ตœ์‹ ์˜ SQL ๋ฒ„์ „ ์œ ์ง€, ์ž๋™ํ™”๋œ ๋ฐฑ์—…, 99.99% ๊ณ ๊ฐ€์šฉ์„ฑ ๋ณด์žฅ
  • ์ „์„ธ๊ณ„ ์ง€์—ญ์œผ๋กœ์˜ ๊ฐ„ํŽธํ•œ ์ง€์—ญ ๋ณต์ œ (Read-Only, DR ์šฉ๋„)
  • Auto Tuning ๋ฐ Query performance insights ๊ธฐ๋Šฅ
  1. Managed Instance (MI)
  • Enterprise ์ˆ˜์ค€์˜ ์™„์ „ ๊ด€๋ฆฌํ˜• PaaS Multi Database
  • SQL Server์™€ ๋™์ผํ•œ ๋Œ€๋ถ€๋ถ„์˜ ๊ธฐ๋Šฅ ์ œ๊ณต (SQL Agent, Linked Server, DTC ๋“ฑ)
  • Managed Instance์— ๋ณด์•ˆ ์†”๋ฃจ์…˜ ์„ค์น˜ ๊ฐ€๋Šฅ
  • OLTP์— ์˜ํ–ฅ์„ ์ฃผ์ง€ ์•Š๋Š” Read-Only ๋ณต์ œ๋ณธ ์„œ๋ฒ„ ๊ธฐ๋ณธ ์ œ๊ณต (DW ํ™œ์šฉ, Business Critical ๊ณ„์ธต)
  • Backup File์„ 2์ฐจ, 3์ฐจ ๋ณต์‚ฌํ•˜์—ฌ ์ž์ฒด ๋ณด๊ด€ ๊ฐ€๋Šฅ

<>

  1. Assessment
  • SQL ์„œ๋ฒ„ ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜์„ ์œ„ํ•œ ์‚ฌ์ „ ์ง„๋‹จ ์„œ๋น„์Šค ์ œ๊ณต (1~3์ผ)
  1. ๋ฌด์ƒ PoC
  • ํด๋ผ์šฐ๋“œ์ƒ์˜ SQL ์„œ๋ฒ„ ํ…Œ์ŠคํŠธ๋ฅผ ์œ„ํ•œ PoC ์ œ๊ณต (3~5์ผ)
  1. Azure ํฌ๋ ˆ๋”ง ์ œ๊ณต
  • PoC ๋ฐ ํ…Œ์ŠคํŠธ๋ฅผ ์œ„ํ•œ USD 1,500 ์ƒ๋‹น์˜ Azure ํฌ๋ ˆ๋”ง ์ œ๊ณต
  1. Azure ์›Œํฌ์ƒต
  • ํด๋ผ์šฐ๋“œ ํ™˜๊ฒฝ์— ๋Œ€ํ•œ ์ดํ•ด๋„๋ฅผ ํ–ฅ์ƒ์‹œํ‚ค๊ธฐ ์œ„ํ•œ ๋งž์ถคํ˜• ์‹ค๋ฌด์ž ์›Œํฌ์ƒต ์ œ๊ณต (1~2์ผ)
  1. CloudON 50% ํ• ์ธ
  • ์”จ์•คํ† ํŠธ๊ฐ€ ์ œ๊ณตํ•˜๋Š” ๋งค๋‹ˆ์ง€๋“œ ์„œ๋น„์Šค์— ๋Œ€ํ•œ ์ตœ์ดˆ 1๋…„ 50% ํ• ์ธ ํ˜œํƒ
https://store-images.s-microsoft.com/image/apps.43253.a966ae32-995f-4554-be93-4a73829dd8c0.56143b80-de7c-4b38-ac77-ec4984e231fe.17ae5767-b9d5-4f18-b11a-2bc1ea82331c
https://store-images.s-microsoft.com/image/apps.43253.a966ae32-995f-4554-be93-4a73829dd8c0.56143b80-de7c-4b38-ac77-ec4984e231fe.17ae5767-b9d5-4f18-b11a-2bc1ea82331c
https://store-images.s-microsoft.com/image/apps.24129.a966ae32-995f-4554-be93-4a73829dd8c0.56143b80-de7c-4b38-ac77-ec4984e231fe.edefd896-f2ef-4447-be75-5b75ca4fdf9b
https://store-images.s-microsoft.com/image/apps.20722.a966ae32-995f-4554-be93-4a73829dd8c0.56143b80-de7c-4b38-ac77-ec4984e231fe.3f1a0ac2-8d20-4101-81fa-8070d4022a8a