SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Db_audit processes are blocked by the audit itself Sybase

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Db_audit processes are blocked by the audit itself Sybase
Author Message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Db_audit processes are blocked by the audit itself Sybase Reply with quote
Why are blocked?
Why are there 2 processes of db_audit? If only there is a job of archiving?


Fri Jul 08, 2011 12:38 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
The 2 processes do select sybsecurity.dbo.sysaudits_01


Fri Jul 08, 2011 12:46 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Reply with quote
Can you find out what these processes are doing exactly and from which report or alert job they have been started?
Fri Jul 08, 2011 2:01 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
It is running the job of archiving of sybase.

Yesterday, delayed more of 1 hour.


Fri Jul 08, 2011 2:36 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Reply with quote
It took 1 hour for the processing because the system generated over 200K audit records since the previous replication run. That looks pretty normal to me. The replication performance isn't thrilling, it could run much faster if the repository server was a faster machine, but still seems to be ok. On a commodity windows server with sufficient RAM and CPUs replicating 200K records should typically take from 5 to 15 minutes.

By the way, how many Sybase audit trail tables do you have/ do you see other tables being replicated?
Fri Jul 08, 2011 5:33 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.