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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-05 : 13:54:28
|
Jason writes "Our web application is about to hit the prime time and go from a single webserver machine and single SQL database, into a web-farm with clustered SQL Server 7 databases.
Are there any issues with doing this? I understand we lose our session state by going to a web-farm, but is there a single decent scalable design for the SQL server databases? A consultant came in and told us that two machines controlling a single drive package being the cluster holding all the data, with "front-end" SQL servers being the point-of-contact for the web-farm, and that point-of-contact front set holds only current/recent database data, for speed and efficiency.
Are there pitfalls, things I should watch out for? Any help or directions to articles would be dynamite.
Thanks in advance." |
|
|
|
|
|
Clustering SQL Servers