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

  • The box is a dedicated machine and other processes are checked with no variance seen on the box when the problem occurs. The box has 36 GB of mem total where I allocated 20 GB for the SQL Server service. SSAS is also on the box, but very minimally used and our cube is re-processed once nightly. No one is touching it during the day on anything other than selectivity to query the cube.

    Since day 2 there was suspect of domain controller pass through authentication, internal firewalls, and our switches.

    Each of these have been checked as well as system and application event logs to nothing conclusive.

    I had also started to monitor our DR server which has log shipping going to it. I have been looking at perfMon collections from our file servers and other servers to nothing that pops out to say those servers are having any issues at the same time (though not as thoroughly as the SQL server since I really need my Net Admin to be doing that).

    The machine itself does not have any other processes taking any additional resources I can see (though admit I could very well be missing something).

    However this all also has me now leading that I think it's pass through authentication... but I have nothing to prove at this time that it's not the SQL server as the SQL box has such inconsistent data captures in results when a freeze occurs.