question

MichalisTsimettas-9823 avatar image
0 Votes"
MichalisTsimettas-9823 asked CarrinWu-MSFT edited

Microsoft SQL Server Database Consolidation

Good mornig to everyone. I am working to a hotels company as Information Technology Administrator. In company we have virtual servers and some of them running different versions of Microsoft SQL Server . Our plan is buy a new Physical Machine , install a Microsoft SQL Standard and consolidate all the database of virtual server in Microsoft SQL Standard on Physical Machine. I want like to ask some information about this plan:
1) How i must configure the hardware of Physical Machine?
2)Will i have a performance problem(example Speed)?
3)Is correct strategy to have one SQL Server instance for all Databases ?
4) The number of databases is 13 , what specifications i will have to carefull for each database?
Thank you very much for your time .

sql-server-generalsql-server-transact-sqlsql-server-migration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MichalisTsimettas-9823, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

These questions are impossible to answer without more detailed knowledge about the databases and the applications using the databases.

What I can say is that it sounds a little odd to me that someone would do this in 2021. Many organizations would rather look into migrate the databases to the cloud, for instance Azure SQL Database. Now, since the feature set is not fully one-to-one between Azure SQL and the box version of SQL Server, this is not always easily achieve by just moving the databases to the cloud.

Maybe you have already considered the cloud and dismissed that option, and with good reasons. Still this is a step that surprises me.

But as I said, there is a lot of "it depends" here. Do these applications/databases talk with each other? What are the security considerations? Are all users expected to have access to all databases? Or are some databases very sensitive?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
1 Vote"
CarrinWu-MSFT answered

Hi @MichalisTsimettas-9823,

After researched, I found some information may help you, the infromation as below:

1) How i must configure the hardware of Physical Machine?

I think you can estimate the hardware configuration of the physical machine through the hardware requirements of SQL Server. Please refer to SQL Server 2019: Hardware and software requirements get more information about hardware and software requirements of SQL server

2

)Will i have a performance problem(example Speed)?

About the performance of SQL Server, please refer to 11 Incredibly Effective SQL Server Performance Tuning Tips. There have some tips will enhance the performance of SQL Server

3

)Is correct strategy to have one SQL Server instance for all Databases ?

For SQL Server, the max number of databases you can have on a single SQL Server instance is 32,767. Consolidating SQL Server databases or even full instances is a way of not only cutting licensing and possibly hardware costs, but also a way of easier enforcing different policies such as high availability and disaster recovery for large sets of databases. However, if not properly designed, consolidation might cause serious performance problems or even service disruptions on the centralized system. Please refer to SQL Server consolidation – Hosting multiple databases on a single SQL Server instance to get more information.

4

) The number of databases is 13 , what specifications i will have to carefull for each database?

when choosing one of the consolidations strategies each of which has its cons and pros, in the below checklist im trying to list the main concerns to take care of , these concerns can be captured from different views as the following :
• Security
• High availability and disaster recovery
• Resource management
• Density
• Manageability
Please refer to SQL Consolidation Planning and recommended practices to get more information



Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.