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)?
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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.