Re: Memory and performance issues

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 12:48:27 -0500

Memory use above 2GB for an application requires some special OS and SQL
settings beyond just changing the memory settings in Enterprise Mangler.
That was why I asked the specific questions about AWE and PAE. The symptoms
you describe could be caused by improper memory settings. Again,
Performance Monitor is your friend when troubleshooting these issues. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Paul Williams" <fairfacts_msg@hotmail.com> wrote in message
news:%231G3piT$DHA.1464@tk2msftngp13.phx.gbl...
>
> 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: Allocating hardware resource to SQL instances
    ... SQL 2005 already allows for some setting of that thru CPU affinity and Memory settings. ... But Windows 2003 has WSRM that can allow you to set some restrictions and limits etc. on an app by app basis. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Config - Memory
    ... Perhaps you are logging into sql server with a user without sufficient ... kgboles a earthlink dt net ... min and max memory settings were grayed out? ... Windows 2003 Ent x32 SP2 ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Config - Memory
    ... If you have permission on the server sql server mangement ... "Chris" wrote: ... and max memory settings were grayed out? ... Windows 2003 Ent x32 SP2 ...
    (microsoft.public.sqlserver.server)
  • SQL Config - Memory
    ... Has anyone come accross a SQL Server 2005 configuration screen where the min ... and max memory settings were grayed out? ... Windows 2003 Ent x32 SP2 ...
    (microsoft.public.sqlserver.server)