Share

Read next article:

"Enable SNMP on Windows Server 2003/2003R2"

Read previous article:

"Change Alert Center Threshold Description"

Reduce WUG Database Size

In Default | 0 comments

If you have a problem with WhatsUp Gold database size, you can use Database Tools to Purge expired rows. But if you have non expired data and you need to delete, so you should delete them directly from database.

Tables that have an unexpectedly large number of rows in them may indicate a problem. You can either DELETE or TRUNCATE the table. DELETE option is a more measured approach, whereas the TRUNCATE option empties the table. For DELETE you can do so in small chunks, by date; however, this process will be slower.

For example: if one of your large tables is dbo.PassiveMonitorActivityLog then you can select a date, where all entries prior to that date will be deleted. Let us say you want to delete all entries in the dbo.PassiveMonitorActivityLog table prior to 1/1/2012 then run the following command:

DELETE FROM dbo.PassiveMonitorActivityLog WHERE dEventTime < '1/1/2012'

If the Statistical tables are the ones that happen to be large, then choose to either DELETE or TRUNCATE.

DELETE FROM dbo.StatisticalPing WHERE dPollTime < '1/1/2012'

Alternatively, you can empty a table’s contents by running this query:

TRUNCATE Table dbo.StatisticalPing

Notes:

  1. You have made a backup before performing Delete or Truncate.
  2. You can change the time to the required one.
  3. Make sure that if you are collecting SNMP Traps or Syslogs, that “Accept Unsolicited” is not enabled under the Passive Monitor Listeners (WhatsUp Gold Server Console > Configure > Program Options > Passive Monitor Listeners).

[huge_it_share]

Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

13 + 11 =

Facebook

Unable to display Facebook posts.
Show error

Error: Unsupported get request. Object with ID 'orchtechsoftwarehouse' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api
Type: GraphMethodException
Code: 100
Please refer to our Error Message Reference.