Creating a cluster across two MS SQL 2008 database accounts

Discussion in 'Databases' started by letterstocrushes, Jul 14, 2011.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hello lovely DiscountASP staff and community,

    My site has grown too big for it's database, so I am trying to figure out what is the best way to get a larger database.

    I currently have two MS SQL 2008 databases at DiscountASP that I am able to utilize fully for this project. I would like to create a 'cluster' out of these two databases that I could access through an Entity Framework / MVC 3 website. It is a medium sized website, so it can receive a decent amount of load (and I'm caching as well), but it gets about 30 to 60 requests a minute at the peak. So I need a fast solution, as well.

    I can access the server through SQL Server Management Studio, and I believe the answer lies somewhere in that direction, but my newbie system administration skills and feverish googling have not lead me get much farther than that. If you have any links to resources on how to do this, or alternate suggestions to solving my problem (i.e. use JOINs across the two databases), I would be very happy. My users would be too.

    Many thanks,
    Seth
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page