• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2795
  • Last Modified:

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! :)
0
Endelm
Asked:
Endelm
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
DBCC dropcleanbuffers
DBCC freeproccache
0
 
PresageSolutionsCommented:
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now