-
- Enthusiast
- Posts: 58
- Liked: never
- Joined: Jan 01, 2006 1:01 am
- Contact:
Database maintenance
Hey guys is there anyway to do maintenance on the collector database? I've had it storing data for 6 months now and it's gotten really big. 97 Gb big. What are my options to shrink this?
-
- Chief Product Officer
- Posts: 31748
- Liked: 7251 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Database maintenance
Hello, you can try to execute the following command in SQL Server manager:
Right-click Monitor database > Tasks > Shrink > Database
Right-click Monitor database > Tasks > Shrink > Database
-
- Enthusiast
- Posts: 58
- Liked: never
- Joined: Jan 01, 2006 1:01 am
- Contact:
Re: Database maintenance
Should I shut the monitor down before I do this or is it ok to run while it's still collecting data? Thanks!
-
- Enthusiast
- Posts: 58
- Liked: never
- Joined: Jan 01, 2006 1:01 am
- Contact:
Re: Database maintenance
Ok we just figured out some specifics here. It wasn't our database that was 97 Gb it was the transaction log. We set up jobs to commit the transaction log based on a percentage of the size of the actual database. That fixed the problem. A suggestion here would be for the software to set up a similar condition on the database creation, or include in the documentation, for the user to set similar conditions. The transaction log, for us, was growing pretty fast. Just FYI.
-
- Chief Product Officer
- Posts: 31748
- Liked: 7251 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Database maintenance
OK, thanks - this is useful information.
Who is online
Users browsing this forum: No registered users and 1 guest