none
Website down but db usage is not high

    Question

  • Hi,

    I got an issue here. my website keep on down but when i see the log from sql server database, cpu is most time idle, db usage is not high, the hit ratio is 100%. but the wait is high..and got few sql process block. any idea what should i check if got this issue. i've check the sql statement each time got this issue, and it shows different sql statement. so could not be the sql statement. can please advice me what to do.


    kneeah
    Tuesday, August 02, 2011 4:02 AM

Answers

All replies