Load balancing or seperate databases

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Load balancing or seperate databases

Author

Topic

jbezanson
Starting Member

35 Posts

Posted - 2007-10-15 : 10:10:01

We are looking at expanding our web application (C# and Sql Server). The module we are going to be adding will be far more processor intense (plotting and modeling) than any of the current code.

I need to know what the best design for this add on would be.

Would it be better to
a) Keep the new module as part of the core db (entire application on 1 database) and use loading balncing between 2 (or more) servers to handle the huge increase in demand?
b) Create the new module as a seperate database that runs on a seperate server?

If B is the best option (I am thinking it is not) is there a way to write easy and efficient queries and views of the 2 databases as 1.

Thanks

Justin

Justin Bezanson
www.justinbezanson.com
www.geekdaily.net - web development and technology blog and news
www.offsidegames.com - free online flash games
www.thrufare.com - free proxy website

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-15 : 13:10:27

There is no way for us to know which one will work better for you given the information that has been provided.

It would be best for you to spin up a performance environment where you can simulate the future workload and determine what architecture works best for you. This is how we determine how to configure things.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

jbezanson
Starting Member

35 Posts

Posted - 2007-10-15 : 13:17:17

Thanks for the input.

Our current system is dealing with thousands of records but with the addon it will jump into the millions very quickly. We will be receiving weather data every 10 minutes from weather towers.

If we were to have 2 seperate databases on different servers is it possible to create views or use TSQL between the 2 databases? I realize that constraints can't be implemented between the 2 but as long as I could query the 2 databases and return a single dataset that should be sufficient.

Justin Bezanson
www.justinbezanson.com
www.geekdaily.net - web development and technology blog and news
www.offsidegames.com - free online flash games
www.thrufare.com - free proxy website

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-15 : 13:20:10

You can use partitioned views so that to the application it acts like one database.

Check out partitioned views in BOL for more details.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

jbezanson
Starting Member

35 Posts

Posted - 2007-10-17 : 13:51:37

Thanks very much. That is exactly what I was hoping to hear.

Justin Bezanson
www.justinbezanson.com
www.geekdaily.net - web development and technology blog and news
www.offsidegames.com - free online flash games
www.thrufare.com - free proxy website

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources