Post reply

are tables cached in the same location as procedure cache?

  • June 3, 2011 at 9:15 pm

    #252262

    I have a sproc in which there are bunch of select statements...now if i just run the select statement..i know the data is cached...would the same cache be used when the procedures runs? I mean when i run the procedure would it take benefit of the tables that are cached by running the select statement?

  • June 4, 2011 at 5:33 am

    #1334023

    The data cache just caches pages from tables, it doesn't care what query ran to get those pages into cache, it just cares that the page is there. Anything that queries the table will read from cache

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 4, 2011 at 8:10 am

    #1334038

    Thanks Gail. Gail do you know of any good article which explain different types of cache in memory for sql server?

  • June 4, 2011 at 10:01 am

    #1334045

    Books Online?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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