SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Audit client High CPU 4.0

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Audit client High CPU 4.0
Author Message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post DB Audit client High CPU 4.0 Reply with quote
We installed your 4.0 DBAudit product. I created a new repository db and new definitions. I did this on mulitple clients pointing to local and network SQL Servers. After a trigger is created the application goes high CPU. The triggers and definitons are created. When you come back on and re-log in the table is not recognized as having triggers created for it. Please advise...

Patrick
Fri Jan 18, 2008 3:50 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Weird... By application going high CPU, which application do you mean? DB Audit or your business application?
If you have system auditing also enabled, can you see in the system audit reports/logs what the application is doing?

Anything turning up in the data-change audit-trail?

Are you using any audit-time filters? If yes, which filters?

Which version of SQL Server? Which version/build of DB Audit (see Help/About box)?
Fri Jan 18, 2008 6:45 pm View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
I am still looking for some resolution for this. I don't know if you want me to download your latest version from the web site or if you have the ability to test what CD was shipped to us.
Mon Jan 21, 2008 11:10 am View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Please answer questions asked in the previous post
Mon Jan 21, 2008 11:32 am View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
My mistake....the DB Audit client is going high CPU. System Auditing is not enabled. I will see if the audting actually would work for updates but I can tell you that DBAudit does not recognize the prevously defiened tables. We are using SQL Server 2005 and 4.015 of DB Audit. I tried to download your latest version from the site, but I received HTTP errors trying to do the download.
Mon Jan 21, 2008 11:49 am View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
This should be a lot easier to troubleshoot. My first guess, you have selected some bad driver for the connection.

Let's start here.
1. If you have SQL 2000 client installed, switch to MSS driver - this is most reliable. If you don't have it and you picked OLE/ADO switch to ODBC. OLE/ADO is the worst choice and should be used if no other methods are available.

2. If the above doesn't help, check if in DB Audit directory you got db_audit.err file. If yes, take a look what kind of errors are reported in that file. If errors are database based, than driver is likely cause. If not, email the entire file to the support email (see Help/About box for details)

3. If none of the above, please let us know too. I will provide instructions on how to turn on and use tracing options to troubleshoot this issue.


By the way, the most recent version is 4.0.17. It can be downloaded and installed on top of the existing installation; this takes only a few seconds to do.
Mon Jan 21, 2008 12:34 pm View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
I tried all of your drivers and nothing worked. With your 3.21 verison, the ADO driver method did work. I do not see a .err file in your program folder. What is the next way to proceed? Thanks...
Mon Jan 21, 2008 1:40 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
To the best of my knowledge there are no differences for ADO driver usage between versions 3.2 and 4.0. What could happen is that you could have some Microsoft MDAC/ADO/NET update installed or let the system installed it automatically that affected the behavior.

But before we talk about that, let's find out what is going on. In the driver field on the Connect to Database dialog insert word TRACE in the beginning, for example for ODBC, it should look like TRACE ODBC, for OLE/ADO it should look like TRACE OLE. Connect to the database and install the auditing on one or 2 tables. Please send the resulting pbtrace.log file to our support account
Mon Jan 21, 2008 1:52 pm View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
Trace Sent.........
Mon Jan 21, 2008 2:12 pm View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Thank you.
Tue Jan 22, 2008 2:42 am View user's profile Send private message
pboor



Joined: 03 Jan 2008
Posts: 19
Country: United States Minor Outlying Islands

Post Reply with quote
I downloaded the latest version and problem fixed.....
Tue Jan 22, 2008 11:29 am View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Reply with quote
Great. Thanks for the status update.
Tue Jan 22, 2008 12:42 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.