Home Forums SQL Server 2008 SQL Server Newbies retrieving 1 record takes 5 times longer than before PC went into sleep and woke up RE: retrieving 1 record takes 5 times longer than before PC went into sleep and woke up

  • Lowell (6/30/2014)


    well, first, 26 milliseconds is fast. the difference is pretty minimal for things under 50 milliseconds, i don't know if it's worth investigating much.

    also, how are you measuring this? is this a one time "it takes 26 milliseconds" after wakeup, and thereafter it takes the normal 5?

    or is it every time it's measured after sleeping, it's 26 milliseconds?

    could there be other resources hitting the server, that causes the tiny amount of slowdown?

    could it be that because the laptop went to sleep,the data was paged out of memory because it's not being used, nad s it had to be loaded from disk?

    Hi and Thanks

    No I leave it running for hours and it stays the same 26ms which as you say is not really a worry just interesting 😉

    I haven't tried it yet but I wonder what happens when it goes to sleep again? does it take longer (pops off to try it !) no it stays at 26ms . 😉