timscronin
MIS
I have sql 2000 Ent running on Win 2003. My Cache hit ratio is running around 66%. TIme for more memory. Also, is there a way to show what specific objects are chewing up memory? This is 3rd party apps so changing app not an option
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
memory time
- Thread starter timscronin
- Start date
- Status
ptheriault
IS-IT--Management
You definetly need more memory. Some other counters to look at. MAX PAGE LIFE EXPECTANCY. This is how long a page stays in memory in seconds. It should be about 300. Also,
You should make sure you don't have any tables pinned in memory.
Use DBCC CACHESTATS to find objects chached.
- Paul![[batman]](/data/assets/smilies/batman.gif "[batman] [batman]")
- If at first you don't succeed, find out if the loser gets anything.
You should make sure you don't have any tables pinned in memory.
Use DBCC CACHESTATS to find objects chached.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Status
Similar threads
- Locked
- Question
- Locked
- Question