Real-time performance monitoring and troubleshooting
Post Reply
elwappo
Enthusiast
Posts: 65
Liked: never
Joined: Jan 01, 2006 1:01 am
Contact:

Database maintenance

Post by elwappo » 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?

Gostev
SVP, Product Management
Posts: 23860
Liked: 3209 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Database maintenance

Post by Gostev » 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

elwappo
Enthusiast
Posts: 65
Liked: never
Joined: Jan 01, 2006 1:01 am
Contact:

Re: Database maintenance

Post by elwappo » 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: Jan 01, 2006 1:01 am
Contact:

Re: Database maintenance

Post by elwappo » 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.

Gostev
SVP, Product Management
Posts: 23860
Liked: 3209 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Database maintenance

Post by Gostev » Apr 29, 2009 7:53 pm

OK, thanks - this is useful information.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests