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 database with objectID 0. Does this mean anything or need to be worried about?
Because I am seeing this many times in 20 mins trace.
Please check whether you or application is generating static cursor. Static cursors create table in tempdb
No comments:
Post a Comment