|
Home > Archive > MS SQL Server > May 2005 > splitting a database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
splitting a database
|
|
| Richard Cranium 2005-05-26, 8:23 pm |
| Hello,
Where can I begin to research splitting up the load for one database across
multiple servers?
We have a website in IIS that uses a SQL Server database. The website could
have up to 500 concurrent users and we want to employ multiple servers to
share the processing for this database.
Thank you!
--
| |
| Mark J. McGinty 2005-05-27, 3:23 am |
|
"Richard Cranium" <mgreco40@hotmail.com> wrote in message
news:%23bYRumjYFHA.2128@TK2MSFTNGP15.phx.gbl...
> Hello,
>
> Where can I begin to research splitting up the load for one database
> across multiple servers?
> We have a website in IIS that uses a SQL Server database. The website
> could have up to 500 concurrent users and we want to employ multiple
> servers to share the processing for this database.
>
Look for the topics under keywords "Federated Database Servers"
-Mark
> Thank you!
>
>
> --
>
>
>
| |
| Richard Cranium 2005-05-27, 8:23 pm |
| Thanks Mark
"Mark J. McGinty" < mmcginty@spamfromyou
.com> wrote in message
news:Op8x6ZmYFHA.2508@TK2MSFTNGP15.phx.gbl...
>
> "Richard Cranium" <mgreco40@hotmail.com> wrote in message
> news:%23bYRumjYFHA.2128@TK2MSFTNGP15.phx.gbl...
>
> Look for the topics under keywords "Federated Database Servers"
>
>
> -Mark
>
>
>
>
| |
| Wayne Snyder 2005-05-29, 9:23 am |
| IF the users are updating the database it is a much bigger issues than if
they are only reading... For read only, take a look at Log Shipping in the
BOL.
Going to a Federation of Servers is a big step, and I would try to avoid it,
if I could find some other options...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Richard Cranium" <mgreco40@hotmail.com> wrote in message
news:%23bYRumjYFHA.2128@TK2MSFTNGP15.phx.gbl...
> Hello,
>
> Where can I begin to research splitting up the load for one database
> across multiple servers?
> We have a website in IIS that uses a SQL Server database. The website
> could have up to 500 concurrent users and we want to employ multiple
> servers to share the processing for this database.
>
> Thank you!
>
>
> --
>
>
>
|
|
|
|
|