Results 1 to 4 of 4

Thread: memory time?

  1. 04-04-2007, 03:58 PM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    memory time?

    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
    Reply With Quote Reply With Quote
  2. 04-05-2007, 07:55 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    How about buffer cache hit ratio? That's data cache and should be above 95%.
    Reply With Quote Reply With Quote
  3. 04-05-2007, 08:24 AM #3
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    It's about 95-96, I have not seen this kind of a large disparity between these 2 before
    Reply With Quote Reply With Quote
  4. 04-05-2007, 11:15 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Cache hit ratio is for sql procedures, not for data. I'll add more memory on it since I like to see above 99% of buffer cache hit ratio.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules