RE: Memory Problems
- From: "John F." <juantana@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 4 Apr 2005 12:07:04 -0700
Hey Steven - also you may want to start a Profiler Trace & capture that info
there to get to what is happening inside SQL that may be causing you pain. I
agree with Brant too about giving it the extra gig by using the /3gb switch.
"Brant" wrote:
> Steven-
> a) when SQL server reaches its 2 gig memory limit, sql will have to
> reevaluate the way it is using memory, and make adjustments accordingly.
> Performance could degrade, but it shouldnt bring the server to its knees
> b) in PerfMon, look under SQL Server:Memory Manager. here you will find
> counters such as connection memory, lock memory, SQL cache memory, optimizer
> memory. It is a good idea to baseline your server with Perfmon before your
> issue occurs, so that you have something to compare the results to.
> c) i would hold off on upgrading to EE until you have an understanding of
> how SQL is currently using your memory.
>
> It might benefit you to use the /3gb switch in your boot.ini to gain an
> extra gig of memory that sql can use.
>
>
> Hope this helps,
>
> Brant
>
>
> "Steven Clark" wrote:
>
> > I have a server which is running with 4 gig ram, quad xeon on windows 2000
> > server with SQL Standard edition. It appears that SQL is taking all the
> > memory it possibly can (approx 2gig) from the system and then when it cant
> > take any more, it slows down its functioning almost to a stop.
> >
> > Can anyone answer any of these questions I have:
> >
> > a) I know standard edition has a 2 gig memory limit, what happens when it
> > reaches that point?
> > b) Is there anyway I can try and diagnose why SQL is doing this? I have
> > tried looking at performance monitor but i'm not sure what to look for.
> > c) Would upgrading to Enterprise edition possibly fix these problems or
> > would that just cause SQL to take even more system memory?
> >
> >
> > Thank you
> >
> >
> > Steven
> >
> >
> >
.
- Prev by Date: Problem installing SQL Server 2000 Developer Edition on Windows XP
- Next by Date: Access SQL server from Unix computers?
- Previous by thread: Problem installing SQL Server 2000 Developer Edition on Windows XP
- Next by thread: Access SQL server from Unix computers?
- Index(es):
Relevant Pages
|
