Home Forums SQL Server 2005 Administering Communications to SQL server "freeze", then resume. RE: Communications to SQL server "freeze", then resume.

  • At 9 am, I could run sp_who2 and get query results. CPU was at 40ish percent and nothing I don't see often when no blocking was occurring (file attached)

    At 9:30 am I could NOT run sp_who2 (query froze until the server was done doing whatever it was doing - finally returned results when it was done). The CPU level dropped to about 5% on all cores. When the connection came back there was a CPU spike, but with the spike was actual movement.

    Sometimes the CPU spike is there and that causes a block. I just had a "freeze" at 9:50 which I have never had a freeze at 9:50 before, and watching task manager and all my other alert mechanism, nothing was any different from 9:49 or 9:48, visibly.