Memory Management on cluster

I have an active/active two node cluster, each node runs Windows 2000
Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB
of memory. The 3GB switch is enabled on both nodes.
When SQL Server on nodeA fails over to nodeB, will this instance only
have .7 GB of memory to use? Or can the two SQL instances share the 3
GB?<emnova@.gmail.com> wrote in message
news:1149780738.792282.241150@.j55g2000cwa.googlegroups.com...
>I have an active/active two node cluster, each node runs Windows 2000
> Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB
> of memory. The 3GB switch is enabled on both nodes.
> When SQL Server on nodeA fails over to nodeB, will this instance only
> have .7 GB of memory to use? Or can the two SQL instances share the 3
> GB?
>
SQL Server will yield memory when the system is under memory pressrure.
However the process is slow, and will be painful in case of a failover. If
you really want to guarantee good performance on failover, you should add
memory or trim the max memory size of each virtual server.
David|||<emnova@.gmail.com> wrote in message
news:1149780738.792282.241150@.j55g2000cwa.googlegroups.com...
> I have an active/active two node cluster, each node runs Windows 2000
> Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB
> of memory. The 3GB switch is enabled on both nodes.
> When SQL Server on nodeA fails over to nodeB, will this instance only
> have .7 GB of memory to use? Or can the two SQL instances share the 3
> GB?
They're share it (I'm assuming you don't have PAE enabled also, which you
shouldn't in this case.)
I'd probably test this though and see if I could limit say nodeB to 1.5 gig
and see what that does to performance.
Ideally, if you can, upgrade the RAM in both machines.

>

Memory management

I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
of the 4 gb installed in the server. How do I reduce the amount of memory
SQL is using?
MBS
Set the MAx Memory setting to the amount you want minus about 300MB and you
should be all set. You can do this via sp_configure or ssms.
Andrew J. Kelly SQL MVP
"MBS" <who@.nowhere.com> wrote in message
news:H8CdnbIX_t1gHsvYnZ2dnUVZ_uednZ2d@.suscom.com.. .
>I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
>databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
>of the 4 gb installed in the server. How do I reduce the amount of memory
>SQL is using?
> MBS
>

Memory management

I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
of the 4 gb installed in the server. How do I reduce the amount of memory
SQL is using?
MBSSet the MAx Memory setting to the amount you want minus about 300MB and you
should be all set. You can do this via sp_configure or ssms.
Andrew J. Kelly SQL MVP
"MBS" <who@.nowhere.com> wrote in message
news:H8CdnbIX_t1gHsvYnZ2dnUVZ_uednZ2d@.su
scom.com...
>I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
>databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
>of the 4 gb installed in the server. How do I reduce the amount of memory
>SQL is using?
> MBS
>

Memory limited to 1.24 GB

HI,
My config is Windows 2000 entreprise, sqlserver 2000 standard, 2 cpu, 2 GB
of ram
The memory is configuring as dynamic, no max, no min
So, my question is :
Why the sql server use only 1.24 GB of ram et no 2 GB ?
Thanks a lot
Regards
Thierry
First off what are you using to determine the memory? DOn't use task
manager use Perfmon and the proper SQL Server memory counters. SQL Server
will only use memory if it needs to. It simply may not need all 2GB. Even
so with 2GB you likely to only see about 1.75GB's used for SQL Server
anyway.
Andrew J. Kelly SQL MVP
"Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
news:3EDFDC58-470E-40DE-A970-21BC3ADEC1A4@.microsoft.com...
> HI,
> My config is Windows 2000 entreprise, sqlserver 2000 standard, 2 cpu, 2 GB
> of ram
> The memory is configuring as dynamic, no max, no min
> So, my question is :
> Why the sql server use only 1.24 GB of ram et no 2 GB ?
> Thanks a lot
> Regards
> Thierry
>
|||Thanks,
But I use SpotLigth to monitor my server and if I limit the sql server
memory to 500 MB, It use 500 MB, afterv that I set no limit and the memory
grow up to 1.24 GB never upper.
Why ?
Thanks
"Andrew J. Kelly" wrote:

> First off what are you using to determine the memory? DOn't use task
> manager use Perfmon and the proper SQL Server memory counters. SQL Server
> will only use memory if it needs to. It simply may not need all 2GB. Even
> so with 2GB you likely to only see about 1.75GB's used for SQL Server
> anyway.
> --
> Andrew J. Kelly SQL MVP
>
> "Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
> news:3EDFDC58-470E-40DE-A970-21BC3ADEC1A4@.microsoft.com...
>
>
|||Are you absolutely sure you have as much memory as you think? I don't know
for sure how Spotlight is measuring memory so I can't comment on that part.
My guess you have other apps runing on that server that take up a certain
amount of ram as well or SQL just does not need more than that.
Andrew J. Kelly SQL MVP
"Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...[vbcol=seagreen]
> Thanks,
> But I use SpotLigth to monitor my server and if I limit the sql server
> memory to 500 MB, It use 500 MB, afterv that I set no limit and the memory
> grow up to 1.24 GB never upper.
> Why ?
> Thanks
> "Andrew J. Kelly" wrote:
Server[vbcol=seagreen]
Even[vbcol=seagreen]
message[vbcol=seagreen]
2 GB[vbcol=seagreen]
|||Andrew J. Kelly wrote:[vbcol=seagreen]
> Are you absolutely sure you have as much memory as you think? I
> don't know for sure how Spotlight is measuring memory so I can't
> comment on that part. My guess you have other apps runing on that
> server that take up a certain amount of ram as well or SQL just does
> not need more than that.
>
> "Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in
> message news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...
I agree with Andrew. Whatever algorithm SQL Server uses to determine how
much system memory it can grab is probably coming up the 1.24GB number
on that particular server.
For a server, having 700MB or so dedicated to server functions doesn't
sound unreasonable.
David G.
|||use Perfmon / Process / Private Bytes to see if there are any other non-sql
processes using a large amount of memory.
cheers,
Andy.
"Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...[vbcol=seagreen]
> Thanks,
> But I use SpotLigth to monitor my server and if I limit the sql server
> memory to 500 MB, It use 500 MB, afterv that I set no limit and the memory
> grow up to 1.24 GB never upper.
> Why ?
> Thanks
> "Andrew J. Kelly" wrote:
Server[vbcol=seagreen]
Even[vbcol=seagreen]
message[vbcol=seagreen]
2 GB[vbcol=seagreen]
|||Hi,
Thanks a lot all for your response.
In fact, the server have 500 MB RAM free in all times, sqlserver reserved
1.24 GB and the other process reserved 250 MB.
Why ?
"Andy Ball" wrote:

> use Perfmon / Process / Private Bytes to see if there are any other non-sql
> processes using a large amount of memory.
> cheers,
> Andy.
> "Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
> news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...
> Server
> Even
> message
> 2 GB
>
>

Memory limited to 1.24 GB

HI,
My config is Windows 2000 entreprise, sqlserver 2000 standard, 2 cpu, 2 GB
of ram
The memory is configuring as dynamic, no max, no min
So, my question is :
Why the sql server use only 1.24 GB of ram et no 2 GB ?
Thanks a lot
Regards
ThierryFirst off what are you using to determine the memory? DOn't use task
manager use Perfmon and the proper SQL Server memory counters. SQL Server
will only use memory if it needs to. It simply may not need all 2GB. Even
so with 2GB you likely to only see about 1.75GB's used for SQL Server
anyway.
Andrew J. Kelly SQL MVP
"Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
news:3EDFDC58-470E-40DE-A970-21BC3ADEC1A4@.microsoft.com...
> HI,
> My config is Windows 2000 entreprise, sqlserver 2000 standard, 2 cpu, 2 GB
> of ram
> The memory is configuring as dynamic, no max, no min
> So, my question is :
> Why the sql server use only 1.24 GB of ram et no 2 GB ?
> Thanks a lot
> Regards
> Thierry
>|||Thanks,
But I use SpotLigth to monitor my server and if I limit the sql server
memory to 500 MB, It use 500 MB, afterv that I set no limit and the memory
grow up to 1.24 GB never upper.
Why ?
Thanks
"Andrew J. Kelly" wrote:

> First off what are you using to determine the memory? DOn't use task
> manager use Perfmon and the proper SQL Server memory counters. SQL Server
> will only use memory if it needs to. It simply may not need all 2GB. Eve
n
> so with 2GB you likely to only see about 1.75GB's used for SQL Server
> anyway.
> --
> Andrew J. Kelly SQL MVP
>
> "Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in messag
e
> news:3EDFDC58-470E-40DE-A970-21BC3ADEC1A4@.microsoft.com...
>
>|||Are you absolutely sure you have as much memory as you think? I don't know
for sure how Spotlight is measuring memory so I can't comment on that part.
My guess you have other apps runing on that server that take up a certain
amount of ram as well or SQL just does not need more than that.
Andrew J. Kelly SQL MVP
"Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...[vbcol=seagreen]
> Thanks,
> But I use SpotLigth to monitor my server and if I limit the sql server
> memory to 500 MB, It use 500 MB, afterv that I set no limit and the memory
> grow up to 1.24 GB never upper.
> Why ?
> Thanks
> "Andrew J. Kelly" wrote:
>
Server[vbcol=seagreen]
Even[vbcol=seagreen]
message[vbcol=seagreen]
2 GB[vbcol=seagreen]|||Andrew J. Kelly wrote:[vbcol=seagreen]
> Are you absolutely sure you have as much memory as you think? I
> don't know for sure how Spotlight is measuring memory so I can't
> comment on that part. My guess you have other apps runing on that
> server that take up a certain amount of ram as well or SQL just does
> not need more than that.
>
> "Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in
> message news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...
I agree with Andrew. Whatever algorithm SQL Server uses to determine how
much system memory it can grab is probably coming up the 1.24GB number
on that particular server.
For a server, having 700MB or so dedicated to server functions doesn't
sound unreasonable.
David G.|||use Perfmon / Process / Private Bytes to see if there are any other non-sql
processes using a large amount of memory.
cheers,
Andy.
"Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in message
news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...[vbcol=seagreen]
> Thanks,
> But I use SpotLigth to monitor my server and if I limit the sql server
> memory to 500 MB, It use 500 MB, afterv that I set no limit and the memory
> grow up to 1.24 GB never upper.
> Why ?
> Thanks
> "Andrew J. Kelly" wrote:
>
Server[vbcol=seagreen]
Even[vbcol=seagreen]
message[vbcol=seagreen]
2 GB[vbcol=seagreen]|||Hi,
Thanks a lot all for your response.
In fact, the server have 500 MB RAM free in all times, sqlserver reserved
1.24 GB and the other process reserved 250 MB.
Why ?
"Andy Ball" wrote:

> use Perfmon / Process / Private Bytes to see if there are any other non-sq
l
> processes using a large amount of memory.
> cheers,
> Andy.
> "Thierry Bertin" <ThierryBertin@.discussions.microsoft.com> wrote in messag
e
> news:3C20EE66-E1F2-4DC7-85A9-DC101FE57E77@.microsoft.com...
> Server
> Even
> message
> 2 GB
>
>