How can a cached query take 2500 ms on a Sql Server 2008?

Posted by Lieven Cardoen on Server Fault See other posts from Server Fault or by Lieven Cardoen
Published on 2010-03-19T13:46:37Z Indexed on 2010/03/19 13:51 UTC
Read the original article Hit count: 205

Filed under:

How is it possible that a cached query could take that long. With cache cleared it takes 25000 ms (I know that's just way too long but that's not the issue here). Once it is cached, it takes 2500 ms. What could be the problem here? If it's cached, I assume Sql Server gets it out of the RAM. So, again, 2500ms???

© Server Fault or respective owner

Related posts about sql-server