Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-24 : 08:49:51
|
| Prashant writes "Hi,I am working with a finacial company and had problem about maintaining the audit trails of the database.I have a desing about audit trails which works on triggers ,every time any modification is done on the row by the userthat row is inserted into logtable which is identical to the original table.I used the inserted and deleted tables in SQL server to store the original and modified state of the table. This was working fine for normal updates going into system.But same table is also used for processing in which lot of inserts and deletes happen. The problem arised here as lot of processing happening on the table and thus the Server becomes slow. Can you suggest any other design apart from above?Thanks and Regards,Prashant" |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-07-25 : 04:49:47
|
Prashant ... first what i can suggest it try creating indexes on the table and time to time truncate ur log and if still it doesnt help try spliting the process sa u said... quote:
But same table is also used for processing in which lot of inserts and deletes happen. The problem arised here as lot of processing happening on the table and thus the Server becomes slow.
======================================Ask to your self before u ask someone |
 |
|
|
|
|
|
Maintaining Audit Trails In a Database