SQL Cache Memory is decreasing

  • Guys,

    SQL Cache Memory is sinking day by day. Why does this happen ? It was around 38,000 KB last month and now it is around 4000KB. Any idea ?

    Please help..

  • What do you define as 'cache memory'? How's it measured?

    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
  • Memory needed to store the queries, i measured it using a perfmon counter.

  • And specifically which perfmon counter? Can't help without enough details.

    SQL doesn't store queries in memory. It stores data pages, it stores execution plans, not queries though.

    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
  • It's SQL Cache Memory (KB) Counter in SQL Server:Memory Manager.

Viewing 5 posts - 1 through 5 (of 5 total)

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