Issues with multiple DBs on one SQL Server instance?

Tags:
SQL Server
SQL Server Consolidation
We have multiple SQL Server instances running on different servers in our organization, each requiring maintenance and backup. We have a vendor backing up these instances that charges on a per instance basis. I am doing a review to see if I can bring all those SQL Server DBs onto just one instance of SQL Server.

What should I watch for if I run multiple SQL Server DBs on one SQL Server instance? So far, I haven't had any issues. I know there must be enough disk space to hold multiple DBs. Other than size, however, does performance pose an issue? Please share your experience.

Answer Wiki

Thanks. We'll let you know when a new response is added.

We have a single HA SQL Infrastructure where the server holds multiple databases from various of applications and various degrees of IO. We lean towards a single volume for all the databases (expandable via SAN as needed) and single volume for all the logs (expandable via SAN as needed). To keep things in control you would normally should perform backups of the databases which would normally reclaim the logs and truncate into the databases accordingly. Then on a scheduled (quarterly, semi-annually, or annual) basis, we would compact (shrink) the database.

As long as the backend SAN can handle the IO, you should be able to maintain the system. You can utilize it via iSCSI or Fibre. Just make sure you have redundant paths to the volumes.

——————

OK, first you shouldn’t ever be shrinking your databases. If your databases grow to a larger size then need the space.

If a single LUN can handle all the IO for your databases, then that is fine. Otherwise you’ll need multiple LUNs for the storage.

Some other things that you’ll need to keep in mind, is that the SQL Server has enough procedure cache, and enough buffer cache for the databases in question. You’ll need to ensure that you aren’t doing so much context switching that you are slowing down the system by simply switching contexts to much.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQL Server Ask the Experts
    [...] Issues with multiple DBs on one SQL Server instance? asked by SQL Server Ask the Experts and answered by MrDenny and [...]
    0 pointsBadges:
    report
  • SQL Server Ask the Experts
    [...] Issues with multiple DBs on one SQL Server instance? asked by a SQL Server reader and answered by MrDenny and [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following