Monday, July 4, 2011

What is procedure cache in SQL Server ?

The part of SQL server memory pool that is used to store execution plans is refered to as procedure cache in SQL Server.

DBCC FREEPROCCACHE
OR
DBCC FREEPROCCACHE WITH NO_INFOMSGS

is used to free procedure caches.

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

 using Microsoft.AspNetCore.Mvc; using System.Xml.Linq; using System.Xml.XPath; //<table class="common-table medium js-table js-stre...