Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL2012 caching behaviour Expand / Collapse
Author
Message
Posted Sunday, November 4, 2012 9:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 9:54 PM
Points: 21, Visits: 236
I found out that it seems flush from memory very soon make it unable to use the cache data, results in slow to getting results.

1) How long will it cache the data?
2) Any setting can be set for the interval of caching?
3)Any hot fix /patches in SQL2012 to solve this issue?
Post #1380868
Posted Monday, November 5, 2012 9:01 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 5:22 AM
Points: 709, Visits: 1,412
This is a SQL Server 2000 forum that is buried at the bottom of the forums page. You may want to post your question to the SQL Server 2012 forum:

SQL 2012 - General


Joie Andrew
"Since 1982"
Post #1381139
Posted Monday, November 5, 2012 6:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 9:54 PM
Points: 21, Visits: 236
ok, thanks, will re-post it again.
Post #1381338
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse