SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Single Database or Multiple Databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 11/22/2000 :  20:08:33  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Richard writes "Which is the way to better performance with Microsoft SQL Server 7.0: using a single database with lots and lots of tables or logically grouping data into multiple databases each with a significantly fewer number of tables? The system is comprised of one server with two hard drives that are mirrored. With multiple databases come multiple log files. Does having multiple transaction log files impair a recovery if needed? Also, is there any benefit in using file groups with this configuration?"

Article Link.

Anonymous
Starting Member

0 Posts

Posted - 01/04/2001 :  07:16:25  Show Profile  Reply with Quote
key reference across tables

In the response about seperating the HR, Order and Fullfillment functions across 3 dbs, what are your thoughts about maintaining key references across dbs?

An example would be if you have a db that has a user table with a int as the UserID. And then you have a "Help Desk" type of problem tracking db that has a field with a reference to the owner of the problem using the UserID from the "User" db.

Are there any design issues that should be taken into consideration in this type of situation?

Go to Top of Page

Anonymous
Starting Member

0 Posts

Posted - 01/04/2001 :  13:05:48  Show Profile  Reply with Quote
Fault Tolerance

Suppose you are expecting 10,000 clients.

1) Would you still recommend a database instance per client?

2) Suppose you have a couple of client database instances spread across a couple of servers. I am not very familiar with clustering capabilities in Win2K. Is providing a fault-tolerant solution still possible without much effort?

I think with a single database instance implementation, servers could be clustered in an active-to-active configuration providing a fault-tolerant and load-balanced solution in the ASP industry. When creating client database instances and spreading them across a couple of servers, providing a fault-tolerant solution may get more difficult because each server does not look identical. Is this true?

Go to Top of Page

imei
Starting Member

3 Posts

Posted - 04/11/2007 :  17:33:46  Show Profile  Reply with Quote
It works well for OLTP applications to break down one single database into small databases to preserve the data and maintain the on-going transactions. I'm not sure the benefits would be significant for OLAP applications and the extra work required in the maintenance and integration would be worth of the trade-off.
Especially in the situation when the size of the database is considered to be small (in this case) and the data is mostly RO.

Any comments?

Thanks,
IChen
Go to Top of Page

imei
Starting Member

3 Posts

Posted - 04/11/2007 :  17:35:23  Show Profile  Reply with Quote
quote:
Originally posted by Anonymous

Fault Tolerance <P>Suppose you are expecting 10,000 clients.

1) Would you still recommend a database instance per client?

2) Suppose you have a couple of client database instances spread across a couple of servers. I am not very familiar with clustering capabilities in Win2K. Is providing a fault-tolerant solution still possible without much effort?

I think with a single database instance implementation, servers could be clustered in an active-to-active configuration providing a fault-tolerant and load-balanced solution in the ASP industry. When creating client database instances and spreading them across a couple of servers, providing a fault-tolerant solution may get more difficult because each server does not look identical. Is this true?

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000