SQL Server Performance

Just want to share 2 problmes /resln

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by SQLDBAS, Mar 27, 2007.

  1. SQLDBAS New Member

    Today 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.
  2. MohammedU New Member

    Thanks for sharing the info...

    What is the SQL build?

  3. SQLDBAS New Member

    SQL 2K5 SP2..

Share This Page