Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

If I have 50k hits per day on a site using SQL Server express, is that an issue?

How easy is it to schedule backup and other tasks? I know it's all doable, but is it more of a pain?

EDIT: I would also like to add that I will use the same installation for multiple websites.

share|improve this question
add comment

3 Answers

up vote 1 down vote accepted

"How easy is it to schedule backup and other tasks? I know it's all doable, but is it more of a pain?"

Nope, pretty easy actually, you can use ExpressMaint.exe for SQL Express backups and maintenance: http://expressmaint.codeplex.com/

And as Siim K and Nick said, as far as the stress and load on SQL Express, out of those 50k hits, how many of those hits do you think are requesting data, or writing data to the DBs? If it's only a section or two of the site, I think you would be fine, but if the site is heavy on DB calls, then you are going to need to look at expanded options.

share|improve this answer
add comment

You can either write something manually in t-sql using BACKUP DATABASE, then schedule it to run using the windows task scheduler and SQLCMD.

If you're not that way inclined there are several people who have written apps such as SQL Scheduler that give you nice GUI front-ends.

Is SQL Express good enough? You're the best person to answer that question. It depends on what your site is doing, how database intense it is & how big the database is.

share|improve this answer
add comment

SQL server express 2008 can only use limited amounts of system resources:

1 CPU, 1 GB Memory, 4 GB of user data per database

So if you're expecting 50k hits a day and it's a database-heavy site then performance might become an issue.

This question on stackoverflow has some useful information as well

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.