Home Forums SQL Server 2008 SQL Server Newbies Understanding Memory Clerks RE: Understanding Memory Clerks
KylesWay
Old Hand
Points: 369
More actions
November 7, 2012 at 10:37 am
#1556864
CACHESTORE_SQLCP
These are cached SQL statements or batches that aren't in stored procedures, functions and triggers. This includes any dynamic SQL or raw SELECT statements sent to the server