April 4, 2014 at 3:39 am
I would like to know if it is possible to split a database across different servers, in the same manner you can split it over multiple drives on the same server?
And then, if it is possible, is it a good idea?
We are trying to balance the load cause we are finding that the current server can't handle the load
April 4, 2014 at 3:59 am
If you do have multiple databases/applications on server you can move some of the application to other server to reduce the load.
If load on the server is more the only ideal option is to upgrade the hardware.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 4, 2014 at 4:13 am
A database is attached to a single SQL instance only. To scale out, you'd have to work out how to split the database into multiple databases and change the applications to connect to the correct database for the data they want. It's a lot of work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 4, 2014 at 4:22 am
Thanks Gail,
So you would advise against it?
The better solution would rather be hardware and SQL tuning?
April 4, 2014 at 4:56 am
Casper101 (4/4/2014)
So you would advise against it?
I would say it's a lot of work, a lot of design required, easy to get wrong.
The better solution would rather be hardware and SQL tuning?
Tuning should always be the first step. no point in buying hardware to support inefficient queries
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply