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 - 2006-11-29 : 08:12:22
|
| Ankur writes "Hi, My frontend is in Visual Basic6.0 and backend in MS-SQL2000. When run the activity(taking data from one table, validate it and insert in another table) from my frontend it is taking 4-5 minutes as it should takes at max 2 minutes. For this I run the profiler and I analyze that at Audit Logout event it taking lots of time (For e.g., from below examples, it is taking 228733, 206000, 230046 miliseconds)How can I reduce this time?Ex.Audit Logout DSA sa 32 522 0 228733 3388 72 2006-11-18 15:00:44.413 Audit Logout DSA sa 0 27 0 206000 3388 66 2006-11-18 15:01:07.397 Audit Logout DSA sa 0 20 0 230046 3388 67 2006-11-18 15:00:43.350 Please do the needfull.Thnks,Ankur" |
|
|
|
|
|
About Audit Login and Logout event class taking time.