|
|
Subject:
Hosting Database Best-Practice
Category: Computers > Software Asked by: ikehat-ga List Price: $25.00 |
Posted:
20 May 2006 00:34 PDT
Expires: 19 Jun 2006 00:34 PDT Question ID: 730652 |
We want to know the industry best-practice number of maximum databases hosted on a single server with SQL Server, MySQL and Oracle. A link to online source where this information is derived from is a real advantage. |
|
There is no answer at this time. |
|
Subject:
Re: Hosting Database Best-Practice
From: exms-ga on 30 May 2006 06:07 PDT |
There is no "limit" for number of databases for SQL. It all depends on your hardware and what type of preformance you want for each. |
Subject:
Re: Hosting Database Best-Practice
From: xenouk-ga on 02 Jun 2006 04:19 PDT |
I can only speak for SQL Server where the limit is 32,767. As exms-ga stated it does depend on hardware and not only disk access. I would monitor each of your databases and try to achieve a constant flow of disk access. If a database isn't needed for say 30-60 minutes you should set the auto close flag to cut down on SQL Server overheads. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |