SQL Server Performance Forum – Threads Archive
Just want to share 2 problmes /reslnToday I have found the following problems.
1./ possible infinite recompile was detected for SQLHANDLE 0x030005000D989E70A11AFF00F79800000100000000000000, PlanHandle 0x050005000D989E70402302E0010000000000000000000000, starting offset 30146, ending offset 31160. The last recompile reason was 6. These errors are poring Error log all my jobs are in waiting state.
Answer: I have run DBCC FREEPROCCACHE /sp_updatestats on the database after that it is started working. 2. Cosmetic bug in sql 2005 If you opening Activity Monitor the processID field persist while you moving your horizantal bar. However , If you open job Activity window move horizantal bar and try to move Activity Monitor horizantal bar now process ID fiels also moves. While researching issue #1 I found this one.
Thanks for sharing the info… What is the SQL build? MohammedU.
SQL 2K5 SP2..