Re: procedure cache flush?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: arthur (alangham_at_gmail.com)
Date: 01/24/05 

Date: 24 Jan 2005 11:37:10 -0800

thanks guys - i'm slowly getting a clearer picture of the memory
layout. so, one question left (and recommendations):

1. has anyone seen the performance monitor buffer manager:procedure
cache counter give incorrect results? i'm showing a number larger than
is physically possible on our production box.

2. any recommendations on articles or books on the topic of sql server
memory management and configuration. i've read _microsoft sql server
2000 performance optimization and tuning handbook_, but it turns out
that it's pretty high level.

arthur

Relevant Pages

  • Re: 2003 & SQL 2000 clustering Memory
    ... The recommendations are based on the following KB article and also ... How to configure memory for more than 2 GB in SQL Server ... SQL Server Support Engineer, Microsoft ...
    (microsoft.public.sqlserver.clustering)
  • Re: P5B=VM Memory Use
    ... Oh, bye the way, with the 2 GB memory,(1 GB sticks ... in two slots) no settings or combination of settings available in the ... all hands that offered suggestions and recommendations, ...
    (alt.comp.periphs.mainboard.asus)
  • Re: Cisco Software Advisor - used for baselining software versions?
    ... I am about to go through a major upgrade program in my company as per ... "Enter your hardware configuration using show command output from your ... please upgrade your memory ... Be careful with these recommendations. ...
    (comp.dcom.sys.cisco)
  • Re: Windows XP doesnt recognize DIMM memory?
    ... recommended for adjusting in BIOS. ... As there were a lot of recommendations ... the OS doesn't recognize the additional 512MB memory as I ... BIOS recognizes the memory and SANDRA software also recognizes the new ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Tuning Question
    ... the amount of memory, class of system.) ... Are there any recommendations or ... In a previous life as an MVS (IBM mainframe) systems ... be used for paging, ...
    (freebsd-questions)