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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2006-02-21 : 05:26:58
|
| Hi GuysWe have a database Application which has running under sql server.When inserting and saving data on the application it takes so much time...What could be the reason and how can we resolve it?cheersVic |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-02-21 : 05:45:04
|
| Look for contention.Start with sp_who2 and specifically blocking (BlkBy is the column in the output).Then, consider tracing (using SQL Profiler tool that comes with SQL server) the application to determine more details at times when the poor performance occurs.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Database Application