Best Practices for DB Maintenance

[rodegard]

It has been 3 months since we went to production with Web Help Desk.  Crossed the 6,000 ticket threshold as well.  Which got me thinking, how to check to make sure our SQL Server DB is sized correctly.  Anyone have suggestions on how to monitor, when to archive (how to archive)?

Thanks.

Rick

[rodegard]

I will re-state:  Does anyone have a suggestion how to trim or archive the WHD database?  How many months/years of ticket data do you keep in the database?

Thanks.

[henazo]

6 years of tickets, all live and accessible, we have found no need to cut away or archive any part of our db.

Again, express has a 10gb limit.  It's possible to shrink that when you get close and are too cheap for full SQL.

[rodegard]

Thanks for the info.  Good to know the number of years you have stored as a reference.

[henazo]

I should have mentioned we are up to 230,000+ sequential tickets and over 40,000 assets to give you a better idea.

[henazo]

We started out with a SQL Express version because it was free.  As we began to grow we started getting closer 10gb express db limit so we decided to go full fledged SQL.  This was also great because we can now use the SQL agent for nightly backups.

Sorry if this is not really the answer you're looking for.