question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked Cathyji-msft answered

adding of databases to exisiting instances

Experts,

I need to add some databases from some instances to an existing instance. Is there a way to define upto what extent can the databases be migrated to the existing instances after which it would not be viable to migrate it any more.

Probably would need to be defined from compute perspective/storage or anything else to consider

sql-server-general
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.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

Capacity planning is not about the number of databases on a server, but the usage and size of the databases. I have put 100s of tiny databases on a single instance (don't ask) or one multi-terabyte database on a server.

The bottom line is you are going to need to try it and test it for your workload and see what works for you.

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.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @Vishu-2318,

Is there a way to define upto what extent can the databases be migrated to the existing instances after which it would not be viable to migrate it any more.

Technically the limit of databases per instance in SQL Server is 32,767, the real answer to how many databases (and how much data) you can put into SQL Server isn’t a software limitation: it’s a business limitation. The RPO and RTO from the business.

Refer to MS document Maximum capacity specifications for SQL Server and the blog How Many Databases Can I Put on One SQL Server?


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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.

Vishu-2318 avatar image
0 Votes"
Vishu-2318 answered

Sorry , the query was not about how many databases can be put on to an instance but what we need to check from compute/memory/storage perspective to be able to ascertain that it can be migrated to the existing instance.

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.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered
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.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @Vishu-2318,

but what we need to check from compute/memory/storage perspective to be able to ascertain that it can be migrated to the existing instance.

There are some steps which should be taken which can enhance the database performance after the migration;

Database Pre-Migration Checklist

  1. Analyze the disk space of the target server for the new database, if the disk space is not enough add more space on the target server

  2. Confirm the data and log file location for the target server

  3. Collect the information about the Database properties (Auto Stats, DB Owner, Recovery Model, Compatibility level, Trustworthy option etc)

  4. Collect the information of dependent applications, make sure application services will be stopped during the database migration

  5. Collect the information of database logins, users and their permissions. (Optional)

  6. Check the database for the Orphan users if any

  7. Check the SQL Server for any dependent objects (SQL Agent Jobs and Linked Servers)

  8. Check, if the database is part of any maintenance plan

Please refer to the blog SQL Server Database Migration Checklist.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.



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.