7

Our team is currently brainstorming a product idea that's been on the tip of our tongues for a couple of years now.

It'll most probably be an ASP.NET MVC web application hosted on the WISC stack (Windows, IIS, SQL Server, C#)...

Ideally we'd love to follow a similar route to the guys at fog-creek did with fogbugz offering both hosted and "run on your server" style solutions.

Naturally we want to keep the code and database schema practically identical (for maintenance purposes) so we can compile for both in one go.

So having "one big database for all users" seems like it'd add developer overhead maintaining the difference in schema etc..

I remember listening to the stack overflow podcast from back in 2008 where joel spolskey mentioned that his instance of SQL Server had thousands of databases on as they provide each user with a dedicated database, but had scaling issues with SQL server 2000 managing that many databases.

So my question is:

  1. Is this solution easily manageable?
  2. Does SS2008 manage thousands of databases any better?
  3. Can IIS handle that many applications & pools?
  4. Are there any more success stories of this kinda setup working?
  5. Is this possible on vanilla WISC infrastructure?
Erix
  • 7,059
  • 2
  • 35
  • 61
Daniel Upton
  • 5,561
  • 8
  • 41
  • 64

1 Answers1

2

I think SQL Server 2008 would not have any specific issue with this approach.

Anyway if you look for high availability, reliability and scalable solution you should consider having multiple Web Servers and multiple database servers. Just to make sure that in case one machine fails, not everything for your thousand users/customers gets unavailable at once.

Davide Piras
  • 43,984
  • 10
  • 98
  • 147
  • Yep, thanks! Had a bit of a butchers at msdn and supposedly SQL Server supports up to 32,767 databases, which should tide us over :P – Daniel Upton Oct 25 '11 at 14:24