Website down but db usage is not high


  • 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.

    Tuesday, August 02, 2011 4:02 AM


All replies