Home Forums SQL Server 2005 Administering very high CPU, 0 I/O, no blocking, NULL in wait type? What could be possibly going wrong? RE: very high CPU, 0 I/O, no blocking, NULL in wait type? What could be possibly going wrong?

  • October 31, 2012 at 11:02 am

    #1554713

    Has this query been regularly as OK? or is it a new query?

    Are the statistics up to date?

    Have you checked sys.dm_exec_requests for more detailed information?

    Jack Vamvas
    sqlserver-dba.com