SQL容量规划 [英] SQL Capacity planning

问题描述

我被指派将数据库从SQL Standard 2012/2014迁移到SQL Enterprise 2016.

大约20个生产具有不同数据库大小的数据库全部达到500gb。在这20个dbs中，只有3个数据库具有最大IO。 在这3个dbs中，一个是大约300gb，其他2个dbs是100gb和50gb。其余的数据库大小在
MB&没有这样的IO操作。

要构建新服务器，我需要将所有CPU，硬盘，内存等详细信息提供给我的老板。这样他就可以创建新的VM了。一旦他创建了新的VM，我将安装SQL 2016.接下来我将逐个备份并将其恢复到目标新服务器。

为此，我应该如何计算容量规划（核心，cpu） ，硬盘，存储等。）

请指导我遵循一些最佳实践来构建新服务器。在建议服务器和SQL容量规划时我需要注意什么？



提前付款。

---

pols

Hi,

I am assigned to migrate the databases from SQL Standard 2012 /2014 to SQL Enterprise 2016.
Around 20 production databases with different database sizes comes all togther 500gb. In these 20 dbs only 3 databases are having maximum IO.  In these 3 dbs one is around 300gb and other 2 dbs are 100gb and 50 gb. And rest of the database sizes are in MB & no such IO operations.
To build the new server i need to give all CPU,HardDisk,Memory, etc details to my boss. so that he will create new VM. Once he creates the new VM then i will install SQL 2016. next i will take backups one by one and restore it in destination new server.
For this how should i calculate capacity planning like (core,cpu,harddisk,storage etc.)
Pls guide me follow some best practice to build new server. What are the things i need to takecare while suggesting the server and SQL capacity planning?

Thanks in advance.

---

pols

推荐答案

此处 你去，从这里开始

Here  you go, start here

https://sqlperformance.com/2016/11/sql-performance/capacity-planning-using-performance-data

https://sqlperformance.com/2016/11/sql-performance/capacity-planning-using-performance-data

这篇关于SQL容量规划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！