Home Forums SQL Server 7,2000 In The Enterprise Insufficient Buffer Space issues RE: Insufficient Buffer Space issues
Roy Ernest
SSC-Dedicated
Points: 38780
More actions
May 27, 2009 at 8:19 am
#1000639
Pradyothana Shastry (5/19/2009)Try thisDBCC freeproccacheDbcc dropcleanbuffers
Pradyothana Shastry (5/19/2009)
DBCC freeproccache
Dbcc dropcleanbuffers
By doing this, you know that you are clearing all the caches execution plans... Right? That will have a performance impact...
-Roy