none
Sql server fall asleep after a while idle

    Question

  • Hi, I am running SQL server 2008 R2 Developer edition and when I moved my asp.net app from localhost to actual server a weird error. When my application doesn't make any sql request for some longer time, the sql server appears to be "sleeping". If I want to  open a connection after a while, every first request ends with exception. If i let the sql server about a minute to "wake up", everything works fine and all following request works like a charm. Any ideas what could be wrong? 

    Thanks


    Tuesday, June 25, 2013 6:19 PM

Answers