 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
lorellan
Joined: 13 Jun 2011
Posts: 124
Country: Ecuador |
|
 Db_audit processes are blocked by the audit itself Sybase |
 |
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 |
  |
 |
lorellan
Joined: 13 Jun 2011
Posts: 124
Country: Ecuador |
|
| |
|
The 2 processes do select sybsecurity.dbo.sysaudits_01
|
|
| Fri Jul 08, 2011 12:46 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
lorellan
Joined: 13 Jun 2011
Posts: 124
Country: Ecuador |
|
| |
|
It is running the job of archiving of sybase.
Yesterday, delayed more of 1 hour.
|
|
| Fri Jul 08, 2011 2:36 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
|
|
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
|
|
|
