AXISHK
asked on
Clean up memory for SQL Server
CHECKPOINT;
DBCC FREEPROCCACHE;
DBCC DROPCLEANBUFFERS;
Is there any impact if I issues the above three command on my SQL server where there are several running query running on the SQL server?
DBCC FREEPROCCACHE;
DBCC DROPCLEANBUFFERS;
Is there any impact if I issues the above three command on my SQL server where there are several running query running on the SQL server?
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
Guy Hengel [angelIII / a3]
no impact on the running processes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Seem like the slow performance issue can be solved when we issues the command. Providing we have sufficient memory, what does it indicate ?
Tks
Tks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks
I'd be curious to know why you feel that those commands would have "no impact on the running processes". Am I overlooking something here??
no impact in the send of the command "working"
sure it will impact on the performance, but not on the fact if they actually run;
and running the commands will, if any, have only a "short impact" on the commands in a production environment.
sure it will impact on the performance, but not on the fact if they actually run;
and running the commands will, if any, have only a "short impact" on the commands in a production environment.
>> and running the commands will, if any, have only a "short impact" on the commands in a production environment. <<
Probably, if the environment is not already constrained and/or it's a moderate size. If already constrained, though, this could cause quite a delay as the buffers are reloaded. Similarly, if you had 96GB of buffers allocated, it could take quite a while to refill those buffers!
Probably, if the environment is not already constrained and/or it's a moderate size. If already constrained, though, this could cause quite a delay as the buffers are reloaded. Similarly, if you had 96GB of buffers allocated, it could take quite a while to refill those buffers!