Where are the operation being done in SQL Server?

Question

Where are the operation being done in SQL Server?

latheesh.jaya

SSChasing Mays

Points: 644
More actions
December 12, 2010 at 9:25 pm

#242391

Hi Experts,
I would like to know where are the operations, say, "my select statement does the operation on memory rather than spilling the temp DB", being taken place? I can see the below area in memory:
CACHESTORE_PHDR
CACHESTORE_CLRPROC
CACHESTORE_XPROC
CACHESTORE_OBJCP
CACHESTORE_SQLCP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

latheesh.jaya SSChasing Mays Points: 644 More actions · Answer 1

one more note, if the data is being cached means, where is the part in the above been stored?Please help out in the same.

latheesh.jaya SSChasing Mays Points: 644 More actions · Answer 2

Okei, I found the answer as it stores in buffer pool, not in cache.

http://www.sqlteam.com/article/what-data-is-in-sql-server-memory

latheesh.jaya SSChasing Mays Points: 644 More actions · Answer 3

I wanna ask a question again as if I could free some space from the cache(by changing the adhoc query plans to prepared compiled, would it be useful for the buffer? How the memory allocation being happened in this case?