Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning stored proc taking time for first run every 30 mins RE: stored proc taking time for first run every 30 mins
mxy
SSCarpal Tunnel
Points: 4034
More actions
February 25, 2014 at 9:20 pm
#1692124
i notice physical reads for first time to keep in cache and next executions are fast.
but after some time again it is doing physical reads. how to avaid this is there any best option