• Rechana Rajan (10/17/2014)


    Thanks a lot BrainDonor,

    Can high CPU usage over 95% for hours will bring SQL Server down??

    It depends on what is causing the high cpu. If you have profiler running and a couple people running activity monitor - sure that can bring down sql server to where it causes connection timeouts.

    More than likely you have some queries running amuck. Queries that have triangular joins, high io, or are just poorly written in general can cause high cpu.

    Think of the high CPU as more of a Symptom than a root cause.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events