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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Lock: Timeout

Author  Topic 

san43
Starting Member

1 Post

Posted - 2007-09-21 : 10:32:55
I enabled SQL Server Profiler Trace to findout performance issue for one of the application. And I am seeing Lock: Timeout eventclass with duration of 0 on tempdb with objectID 0. Does this mean anything or need to be worried about? As this is happening lot of times in a 20 min trace.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-22 : 00:13:36
Shouldn't unless you see longer duration.
Go to Top of Page
   

- Advertisement -