Database maintenance

Real-time performance monitoring and troubleshooting

Database maintenance

Veeam Logoby elwappo » Mon Apr 27, 2009 5:58 pm

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?
elwappo
Enthusiast
 
Posts: 65
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Re: Database maintenance

Veeam Logoby Gostev » Wed Apr 29, 2009 11:24 am

Hello, you can try to execute the following command in SQL Server manager:
Right-click Monitor database > Tasks > Shrink > Database
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Database maintenance

Veeam Logoby elwappo » Wed Apr 29, 2009 4:44 pm

Should I shut the monitor down before I do this or is it ok to run while it's still collecting data? Thanks!
elwappo
Enthusiast
 
Posts: 65
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Re: Database maintenance

Veeam Logoby elwappo » Wed Apr 29, 2009 7:16 pm

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.
elwappo
Enthusiast
 
Posts: 65
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Re: Database maintenance

Veeam Logoby Gostev » Wed Apr 29, 2009 7:53 pm

OK, thanks - this is useful information.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 2 guests