Re: Memory allocation in MS-SQL 2000 instances

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Don't cross-post to multiple groups.

Multiple SQL instances won't balance memory between each other. You must
set the memory limits for each instance independently.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"dries" <dries@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:part1of1.1.7ww8SuqQFvzkFQ@xxxxxxxx
Hi,
From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3
instances. It is a nice machine with 4 Gb of memory but the memory
allocation
is very weird:
Instance A: 1400Mb
Instance B: 1000Mb
Instance C: 80Mb (!)

Instance C is performing badly under a bit of pressure which seems not
strange
considering these allocations.

With that in mind, is there a way to check and re-allocate memory? I'd
like to
see if the instances really need these amounts of memory and if not, to
move
some over to other instances.

Thanks!
Dries Bessels


.

Relevant Pages

  • Re: How to release heap memory that is marked as free
    ... As I said, fragmentation is a very serious problem, and one of the most serious problems ... my allocator was accused of using massive amounts of memory. ... I'm going to have to re-think the memory allocation that I'm ... process's 'working set'. ...
    (microsoft.public.vc.mfc)
  • Re: [PATCH 00/28] Swap over NFS -v16
    ... memory they can consume. ... So we need the extra (skb) ... included in the reserve? ... if the allocation had to dip into emergency reserves, ...
    (Linux-Kernel)
  • Re: Memory leak with CAsyncSocket::Create
    ... read my essay on how storage allocators work. ... Create method is consuming system memory that is not released back to ... The memory consumption is either shown as "Mem Usage" on the Task ... many levels of allocation going ...
    (microsoft.public.vc.mfc)
  • Re: OT: C++ overloading operators
    ... dynamic allocation, no matter how many "clever tricks" are used... ... though there's enough memory in the system, ... all these "flexible data types" map into CPU command ... The computing environment is completely ...
    (comp.dsp)
  • Re: HLA Lib
    ... All memory allocation is freed up when the process quits. ... reduce need to resize blocks for 98% string operations. ... HLA strings already consume. ...
    (alt.lang.asm)