Post reply

Where are the operation being done in SQL Server?

  • 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

  • December 12, 2010 at 9:26 pm

    #1261505

    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.

  • December 12, 2010 at 9:52 pm

    #1261510

    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

  • December 12, 2010 at 9:54 pm

    #1261511

    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?

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

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