December 10, 2009 at 11:22 am
I have been asked to provide a solution for the following architecture..
1) Multiple SQL Server 2005 Enterprise Edition Servers on Windows 2003 R2 Separate Disk IO.
2) Same database with same name, same data for example ReportingDB, available on all the server
3) Web Application Running Reports accessing these servers directly connected through Web Servers
Objective is to get the fastest report running queries against the SQL Servers Reporting DB.
Question:
How would I decide which server I should send my queries to?
How would I know which server is busy?
How would I know which server is Idle and ready to process SQL queries?
I appreciate your response. Thanks.
December 10, 2009 at 12:20 pm
Are you asking about load balancing? If so, the easiest way to do that in this case would be to hook all the physical servers together into a single virtual server and just load SQL on that. The virtual server software will deal with the load balancing for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 10, 2009 at 12:37 pm
Where can I read more about it?
December 11, 2009 at 7:29 am
Google/Bing/Dogpile/whatever would be a good place to start.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 11, 2009 at 12:54 pm
Thank you so much.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply