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 |
|
Pankaj Garg
Starting Member
2 Posts |
 Posted - 2009-01-30 : 07:38:28
|
| I have a stored procedure , that imports the data to sql server 2005, For that I send the XML to database, there I extract the data and insert/update it in one query.I am operating the same thing at multi user level and starts multi users start the import for the central localized database, there I am watching the execution in sql profiler, and now my problem is The Audit logout/login takes lot of time to execute, Suppose two users are simultaneously doing the import process, if the first user reaches the database first, there after the completion of the import for the first user, still the request of first user does not complete , it remains there for several minutes until audit logs out.and due to this the second user keep waiting for the import execution.please provide suggestion for this performance issue. |
|
|
|
|
|
Multi user Import Audit Logout - VB.net 2005