Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 7,2000 » Performance Tuning » SQL2012 caching behaviour
Add to briefcase

SQL2012 caching behaviour Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
angel.wong 72408
Posted Sunday, November 04, 2012 9:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 12:40 AM
Points: 12, Visits: 100
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
Joie Andrew
Posted Monday, November 05, 2012 9:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:19 PM
Points: 547, Visits: 1,021
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
angel.wong 72408
Posted Monday, November 05, 2012 6:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 12:40 AM
Points: 12, Visits: 100
ok, thanks, will re-post it again.
Post #1381338
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.