Scaling the Database

Apr 30, 2009 at 8:19 PM
Good Afternoon,

We are looking at implementing the SSO/Luminous integration here at our campus.  My question comes to the size of the DB used by SQL Server Express.  How does the number of users compare to the size of the database compare?   We are curious as the limits on DB size that SQL Server express has.  Any guidance in this regard would be most helpful.

Also,

Is anyone clustering there SQL servers? And if so, have they found this to be beneficial?

Thanks
Developer
May 1, 2009 at 2:51 PM
Edited May 1, 2009 at 3:07 PM
The database size is not typically a major concern given the only persisted data is statistical in nature.  It captures every click-through, but even millions of records will consume relatively little space.  You would want to allocate several gigabytes to be safe, but much more would be overkill.  In addition, you can choose to report and purge the records at any time.

That said, you should certainly perform regular maintence on the database, such as backups, to ensure the log files stay healty and small.  It couldn't hurt to shrink on a schedule, either.

You could certainly benefit from clustering for high availability.  For example, if you configure two or more front-end Windows Web Servers with NLB, all connecting to a single back-end SQL Server cluster, you could achieve a very high level of fault tolerance.
May 26, 2009 at 3:19 PM

Thanks!