Home Forums SQL Server 2005 Administering Server Puke, CPU Pressure, or Something else? RE: Server Puke, CPU Pressure, or Something else?

  • April 23, 2013 at 12:10 pm

    #1609214

    DevDB (4/23/2013)

    I think you must already have checked all these before but just wanted to ask?

    Have you checked the execution plan for long running sqls/ stored procedures? It may be good case for execution plans going bad.

    Have you tried re-compiling Sproc ?

    Are the stats are being updated?

    How TVF is being used in query/SP?

    Yes, we actually tried flushing the entire cache a couple of times to no effect.

    Fraggle