2 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
source | link

SQL Server is kind of a memory hog. You could try clearing the cache, BUT I would highly recommend doing some reading on these commands first before you using them. From what I hear, their can be negative side effects when using these especially in a production environment.

DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE

Here are some links I found useful:

http://dba.stackexchange.com/questions/56852/difference-between-freeproccache-and-freesystemcacheDifference between FreeProcCache and FreeSystemCache

https://sqlserverperformance.wordpress.com/2009/12/28/fun-with-dbcc-freeproccache/

http://jamessql.blogspot.com/2012/04/clean-sql-server-cache.html

SQL Server is kind of a memory hog. You could try clearing the cache, BUT I would highly recommend doing some reading on these commands first before you using them. From what I hear, their can be negative side effects when using these especially in a production environment.

DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE

Here are some links I found useful:

http://dba.stackexchange.com/questions/56852/difference-between-freeproccache-and-freesystemcache

https://sqlserverperformance.wordpress.com/2009/12/28/fun-with-dbcc-freeproccache/

http://jamessql.blogspot.com/2012/04/clean-sql-server-cache.html

SQL Server is kind of a memory hog. You could try clearing the cache, BUT I would highly recommend doing some reading on these commands first before you using them. From what I hear, their can be negative side effects when using these especially in a production environment.

DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE

Here are some links I found useful:

Difference between FreeProcCache and FreeSystemCache

https://sqlserverperformance.wordpress.com/2009/12/28/fun-with-dbcc-freeproccache/

http://jamessql.blogspot.com/2012/04/clean-sql-server-cache.html

    Post Migrated Here from stackoverflow.com
1
source | link

SQL Server is kind of a memory hog. You could try clearing the cache, BUT I would highly recommend doing some reading on these commands first before you using them. From what I hear, their can be negative side effects when using these especially in a production environment.

DBCC FREESYSTEMCACHE ('ALL')
DBCC FREEPROCCACHE

Here are some links I found useful:

http://dba.stackexchange.com/questions/56852/difference-between-freeproccache-and-freesystemcache

https://sqlserverperformance.wordpress.com/2009/12/28/fun-with-dbcc-freeproccache/

http://jamessql.blogspot.com/2012/04/clean-sql-server-cache.html