SQL Cache Memory is decreasing

Question

SQL Cache Memory is decreasing

Surii

Default port

Points: 1497
More actions
February 27, 2012 at 3:00 pm

#252203

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..

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

Surii Default port Points: 1497 More actions · Answer 2

Memory needed to store the queries, i measured it using a perfmon counter.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

Surii Default port Points: 1497 More actions · Answer 4

It's SQL Cache Memory (KB) Counter in SQL Server:Memory Manager.