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 ««12

Clear cache after big job? Expand / Collapse
Author
Message
Posted Saturday, August 17, 2013 3:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:02 AM
Points: 823, Visits: 753
Boris Pazin (8/17/2013)
[quote]Biggest table has about 76 millions of rows. So, I guess deleting and re-creating 76M of rows could be harmful for all queries which use that table?


As Gail says, no.

If I bring out my crystal ball, my guess is this: once the job has completed, the web app runs queries to update a cache, and in the wee hours of morning it flushes the cache and reads all data. During the day it runs the queries to update the cache to get the recent changes. The plans to get all from the cache are not good for getting the updates.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1485466
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse