Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine offload of cache mode
Message
 
 
To
19/04/2011 10:51:11
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01507723
Message ID:
01507888
Views:
64
This message has been marked as a message which has helped to the initial question of the thread.
Backup uses non-buffer pool memory, also known as the MemToLeave memory. Se some detail at http://www.sqlservercentral.com/articles/Administration/67192/ and http://support.microsoft.com/kb/271624

>
>Ok, so in our case, the absence of hits during the overnight was probably in cause of the caching being dropped from the related table. Then, it became fast again on the upcoming hits. Also mentioned, the backup that happened two hours before might have been a factor. I assume that it required significant usage of SQL Server engine and might have caused the same situation as well.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform