SQL Server Consolidation–issues to consider
It is natural for an enterprise to end up with a large number of sql server databases – each hosted on its own silo server. This is an obvious waste of server resources – and usually, is the starting point for considering consolidation (placing multiple databases on the same server).
A SQL Server Instance (sqlserver.exe process) can support a maximum of 32,767 databases. However, typically, you would host a much smaller number within one instance. You could host a larger number if they were set to Auto Close when not being used.
Before Consolidating, some challenges that need to be figured out include:
- Server level roles and database level roles – since the same server may have multiple owners – possible across different teams within an organization.
Leave a Reply