Re: Memory and performance issues

From: Paul Williams (fairfacts_msg_at_hotmail.com)
Date: 02/27/04


Date: Fri, 27 Feb 2004 05:50:28 -0800


I agree. The DBA was getting an error message from the maintenance plan
and so disabled the dbcc step reporting the error rather than fixing the
issue - so we (the external cnsults) found it by running dbcc checks
manually).

Still ... corruption was of a single record in the index and did not
noticeably impact performance for months so difficult to say why it
suddenly would.

They also applied Sp3 which has some noted issues with 'wide' result
sets (many columns returned) to their live environment (not test
first)....

Just wanted to find out depth of experience with changing memory
settings and performance impairment. Memory settings were changed
through the enterprise manager MMC. (properties / Memory page on the
Server)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Relevant Pages

  • Re: Software will not run with more than 512MB RAM installed
    ... > The following error message appears every time I attempt to open a ... > Windows ME, Windows XP ... > Total Physical Memory 1,024.00 MB ... > with 64MB RAM, no error. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Blue Screen of Death HELP
    ... I have now disabled automatic restart and await the next recurrence. ... The memory stick DDR2 was replaced when the problem arose but it was a 'pre-owned' stick which functioned after install and well before the problem. ... the My Computer icon on the Desktop and select Properties, Advanced, ... Same question applies to the other error message. ...
    (microsoft.public.windowsxp.general)
  • Re: PAGE_FAULT_IN_NONPAGE_AREA
    ... In Device Manager the Network Card appears under Network Adapter. ... Don't forget the problem could be hardware not software. ... Background information on Stop Error message ... Requested data was not in memory. ...
    (microsoft.public.windowsxp.general)
  • Re: cant stop xp pro reboot loop
    ... You receive a "Stop 0x0000000A" error message in Windows XP ... Requested data was not in memory. ... How many sticks of RAM memory does the computer have? ... Disable automatic restart on system failure. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: PAGE_FAULT_IN_NONPAGE_AREA
    ... Background information on Stop Error message ... Requested data was not in memory. ... and the Virtual Memory settings are other than the original ...
    (microsoft.public.windowsxp.general)