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:

  1. Server level roles and database level roles – since the same server may have multiple owners – possible across different teams within an organization.

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.