Does the server cache get wiped (similarly to when you restart the SQL instance / machine) when you only restart the SQL Services themselves?
Sql-server – Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)
cacheplan-cachesql serversql-server-2008-r2statistics
Related Question
- Sql-server – Change SQL Server settings without restarting services
- Sql-server – Does restoring database clear buffer cache and stored proc cache
- Sql-server – SQL Server 2016 All Queries recompile all the time (plan cache corruption?)
- Sql-server – How does SQL Server determine how much memory to allocate to Data cache
- Sql-server – Can we set the fixed size for both plan cache and data cache
Best Answer
Yes it does. Since SQL Server is in charge of maintaining those caches, when you shut down SQL server's services, it releases the memory back to the operating system.