Problem with v8 collecting SQL logs

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

Problem with v8 collecting SQL logs

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Networking & Security] >> GFI EventsManager >> Problem with v8 collecting SQL logs

Page: [1]

Message

<< Older Topic Newer Topic >>

Problem with v8 collecting SQL logs - 12.Feb.2009 6:14:24 AM

adboshoff

Posts: 19
Score: 0
Joined: 24.Oct.2005
From: South Africa
Status: offline

Eventsmanager v 8.1.0
Build 20080902

We collect logs from two SQL database servers (one DB per SQL server), 3 Windows DCs and 1 Windows standalone server.

The collection of Windows security and system logs always worked fine but the SQL not. It intermittently stops collecting logs from the database servers. It then requires a restart of the SELM service to make it wake up again.

Under the Status-General windows under Activity overview it shows the last activity for the 2 servers are current but if you look under Job Activity-Server Message History there's nothing there. To confirm I've queried the SELM SQL database where the logs are stored (sql_server_audit Table) and for sure the latest entry is not current.

Post #: 1

RE: Problem with v8 collecting SQL logs - 30.Jul.2009 1:00:51 PM

ogobetse

Posts: 2
Score: 0
Joined: 30.Jul.2009
Status: offline

Sorry to bump an old post, but we're having the exact same issue with our environment monitoring SQL2000 database servers.

Info to add:
Both monitored SQL2000 servers are as above
A single SQL2008 server is uneffected and collects logs as expected.
EM v 8.2.0 (20090302)

Any news on this?

< Message edited by ogobetse -- 30.Jul.2009 1:07:12 PM >

(in reply to adboshoff)

Post #: 2

RE: Problem with v8 collecting SQL logs - 30.Jul.2009 1:46:30 PM

DrewE

Posts: 1058
Score: 0
Joined: 28.Apr.2008
From: Cary, NC
Status: offline

Are there any errors under the Status -> Job Activity page?

_____________________________

Drew Easley - Technical Support Representative
GFI Software - www.gfi.com

(in reply to ogobetse)

Post #: 3

RE: Problem with v8 collecting SQL logs - 30.Jul.2009 2:10:53 PM

ogobetse

Posts: 2
Score: 0
Joined: 30.Jul.2009
Status: offline

The only errors i see consistently are 'rejected count' messages. The last message from either SQL2000 server is such a line where Message Count = 100 and Rejected Count = 100.

After this last message entry there are continued entries from the SQL2008 but no more from either SQL2000 server.

(in reply to DrewE)

Post #: 4