December 1, 2009 at 2:56 am
Load balancing feature has not the SQLServer.Now we have a critical time when 1500 users insert the data simultaneously at evening and morning.So what should I do I have empty servers but SQL Server not supporting Load balancing.
And they all hit to one singledatabase???
What the other companies does..in this case???
Thanks
December 23, 2009 at 12:37 pm
We had to build it into our application, and then sync the databases at nite.
The first thing that the application did was get the number of SQL connections on serverA. If that number exceeded a threshold, then the app would use a different server name in the connection string.
Then we had jobs that ran at nite to sync the databases between the two servers. In our case, it was ok for the data to be out of sync for 1 day.
In other words, the 'server=' parameter in the connection string changed based on the load on each server.
December 23, 2009 at 1:26 pm
AFAIK If the current sqlserver would have distributed databases to support your load balancing, only a single one would be in read-write state, the others would be in read-only mode (and only be updated by the sync program of sqlserver).
So the only option left is a single instance of sqlserver hosting the database, but splitting in filegroups / multiple files / multiple spindles and maybe even supported with partitioning.
You can also use staging databases or tables to speed up your import process.
Depending on the functionality you aim for (online feedback or not) this may enlarge your options.
For the moment, splitting disks , io chanels , and only use high speed raid levels (raid 1(0)) will be the advise.
Off course optimizing your objects and SSIS streams (loads) will also be very important.
I haven't played with SQL2008 R2 regarding this topic.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply