Clear cache memory in Microsoft SQL 2005

Hi,

How do you clear cache memory in MSSQL 2005?

I did this once in MSSQL 2000 but I forgot how to.

Thank you very much! :)
EndelmAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
DBCC dropcleanbuffers
DBCC freeproccache
0
 
PresageSolutionsCEOCommented:
I have executed above SQL but it is still not clearing cache.  In order to clear cache I have to restart SQL services.
Here is the server information.

Microsoft SQL Server Management Studio                                    10.0.2531.0
Microsoft Analysis Services Client Tools                                    10.0.1600.22
Microsoft Data Access Components (MDAC)                                    6.1.7600.16385
Microsoft MSXML                                    3.0 6.0

Is there any different SQL for clearing cache in SQL server 2008?  We appreciate any help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.