Hi,

my eventlog2.db is 90GB ! all other files are less than 1gb.

I have run a DB cleanup and a DB compress but no joy.

what is in this file and how can I clear it out.

We are getting SQL insert timeout issues.

thanks

asked 16 Sep '16, 07:10

StevenJohns's gravatar image

StevenJohns
6121013
accept rate: 0%


Hi Steven,

The Eventlog2.db is the database table where all of the event log data is stored that you are scanning for. So there could be a lot of data due to the fact that event entries have lots of text for them.

To help you reduce the amount of data in the table there are few more things that you can do.

  • You can reduce the amount of data you are collecting. Go to your monitors and cut back on the what you are scanning for.
  • Go in to your Database Cleanup and reduce the number of days that are you are keeping the data for. Go to System -> Database Settings -> Database Cleanup.

If you are getting database error messages you can send us a copy of the error message along with the zipped up service log file. Please send these to support@poweradmin.com

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 19 Sep '16, 09:55

Quinn's gravatar image

Quinn ♦♦
14.1k3925
accept rate: 37%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×19
×1

Asked: 16 Sep '16, 07:10

Seen: 1,515 times

Last updated: 19 Sep '16, 09:55