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: BSOD minidumps... HELP!
    ... You can rely on the Windows Firewall and do not have to ... Background information on Stop Error message 0x50http://msdn2.microsoft.com/en-us/library/ms793437.aspx ... Requested data was not in memory. ... Any suggestion for an alternate firewall that has ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: ERROR BAD BLOCK CDROM
    ... What were you doing when you got this error message? ... I have seen this with a defective CD/DVD drive and with defective media. ... Message Details said this device has a bad block of memory, which Windows ...
    (microsoft.public.windowsxp.general)
  • Re: Blue screen, memory dump
    ... >are seeing this message for the first time, reboot. ... >memory, Service Pack 2, and replaced the video card. ... content of a STOP error message: ... In memory of a dear friend Alex Nichol MVP ...
    (microsoft.public.windowsxp.help_and_support)