This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Best Practices for DB Maintenance

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