Guys,
I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
can use the whole memory for the SQL Server service...
Just as a 2GB server that I had before, monitoring with Task Manager I see
that the memory utilization don't grow up more than 1,84gb... Even with huge
processing and disk reading... So my question is, is there any kind of
special configuration that you must set to let server use the whole memory?
I know about AWE, but I thought AWE is just for servers who break the 4GB
boundary... Would like to know why the memory utilization don't go upper than
1,84gb, even setting this as a fixed value in Server configuration...
Thx,
Rafa
Hi,
What edition of SQL Server you are using? Only Enterprise or Developer
editions of SQL server supports more than 2 GB memory.
Sheck the version of SQL Server using
Select @.@.version
Thanks
Hari
SQL Server MVP
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa
|||According to Books Online
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\architec.chm::/8_ar_ts_8dbn.htm)
the Standard Edition of SQL Server will not use more than 2GB of RAM.
Keith
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa
|||Take a look at the following URL
http://support.microsoft.com/default...b;en-us;274750
There is a \3GB switch
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa
|||Hi,
Try /3gb switch in boot.ini
"Rafa?" wrote:
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa
|||Well, it's the Enterprise Edition...
What does /3gb in boot.ini?
"Wayne Snyder" wrote:
> Take a look at the following URL
> http://support.microsoft.com/default...b;en-us;274750
> There is a \3GB switch
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Rafa?" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Dual-Xeon
> huge
> memory?
> than
>
>
|||Since you are running on Enterprise Edition you could try using /3GB and or
/PAE within boot.ini.
You will then probably want to specify the memory usage within SQL Server
Using AWE Memory on Windows 2000
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
Managing AWE Memory
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\adminsql.chm::/ad_1_server_1fnd.htm
Keith
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa
|||Keith,
Why would you use the /PAE and AWE switches if his server only has 4 GB RAM.
Those settings are for servers with more than 4GB.
"Keith Kratochvil" wrote:
> Since you are running on Enterprise Edition you could try using /3GB and or
> /PAE within boot.ini.
> You will then probably want to specify the memory usage within SQL Server
> Using AWE Memory on Windows 2000
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
> Managing AWE Memory
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\adminsql.chm::/ad_1_server_1fnd.htm
> --
> Keith
>
> "Rafa?" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
>
>
Showing posts with label reserved. Show all posts
Showing posts with label reserved. Show all posts
Wednesday, March 21, 2012
Memory Utilization
Guys,
I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
can use the whole memory for the SQL Server service...
Just as a 2GB server that I had before, monitoring with Task Manager I see
that the memory utilization don't grow up more than 1,84gb... Even with huge
processing and disk reading... So my question is, is there any kind of
special configuration that you must set to let server use the whole memory?
I know about AWE, but I thought AWE is just for servers who break the 4GB
boundary... Would like to know why the memory utilization don't go upper tha
n
1,84gb, even setting this as a fixed value in Server configuration...
Thx,
RafaHi,
What edition of SQL Server you are using? Only Enterprise or Developer
editions of SQL server supports more than 2 GB memory.
Sheck the version of SQL Server using
Select @.@.version
Thanks
Hari
SQL Server MVP
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||According to Books Online
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\ar
chitec.chm::/8_ar_ts_8dbn.htm)
the Standard Edition of SQL Server will not use more than 2GB of RAM.
Keith
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Take a look at the following URL
http://support.microsoft.com/defaul...kb;en-us;274750
There is a \3GB switch
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Hi,
Try /3gb switch in boot.ini
"Rafa?" wrote:
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a Dual-Xeo
n
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with hu
ge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole memory
?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper t
han
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Well, it's the Enterprise Edition...
What does /3gb in boot.ini?
"Wayne Snyder" wrote:
> Take a look at the following URL
> http://support.microsoft.com/defaul...kb;en-us;274750
> There is a \3GB switch
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Rafa?" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Dual-Xeon
> huge
> memory?
> than
>
>|||Since you are running on Enterprise Edition you could try using /3GB and or
/PAE within boot.ini.
You will then probably want to specify the memory usage within SQL Server
Using AWE Memory on Windows 2000
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\arc
hitec.chm::/8_ar_sa_6b3k.htm
Managing AWE Memory
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\adm
insql.chm::/ad_1_server_1fnd.htm
Keith
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Keith,
Why would you use the /PAE and AWE switches if his server only has 4 GB RAM.
Those settings are for servers with more than 4GB.
"Keith Kratochvil" wrote:
> Since you are running on Enterprise Edition you could try using /3GB and
or
> /PAE within boot.ini.
> You will then probably want to specify the memory usage within SQL Server
> Using AWE Memory on Windows 2000
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\a
rchitec.chm::/8_ar_sa_6b3k.htm
> Managing AWE Memory
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\a
dminsql.chm::/ad_1_server_1fnd.htm
> --
> Keith
>
> "Rafa?" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
>
>
I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
can use the whole memory for the SQL Server service...
Just as a 2GB server that I had before, monitoring with Task Manager I see
that the memory utilization don't grow up more than 1,84gb... Even with huge
processing and disk reading... So my question is, is there any kind of
special configuration that you must set to let server use the whole memory?
I know about AWE, but I thought AWE is just for servers who break the 4GB
boundary... Would like to know why the memory utilization don't go upper tha
n
1,84gb, even setting this as a fixed value in Server configuration...
Thx,
RafaHi,
What edition of SQL Server you are using? Only Enterprise or Developer
editions of SQL server supports more than 2 GB memory.
Sheck the version of SQL Server using
Select @.@.version
Thanks
Hari
SQL Server MVP
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||According to Books Online
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\ar
chitec.chm::/8_ar_ts_8dbn.htm)
the Standard Edition of SQL Server will not use more than 2GB of RAM.
Keith
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Take a look at the following URL
http://support.microsoft.com/defaul...kb;en-us;274750
There is a \3GB switch
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Hi,
Try /3gb switch in boot.ini
"Rafa?" wrote:
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a Dual-Xeo
n
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with hu
ge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole memory
?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper t
han
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Well, it's the Enterprise Edition...
What does /3gb in boot.ini?
"Wayne Snyder" wrote:
> Take a look at the following URL
> http://support.microsoft.com/defaul...kb;en-us;274750
> There is a \3GB switch
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Rafa?" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Dual-Xeon
> huge
> memory?
> than
>
>|||Since you are running on Enterprise Edition you could try using /3GB and or
/PAE within boot.ini.
You will then probably want to specify the memory usage within SQL Server
Using AWE Memory on Windows 2000
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\arc
hitec.chm::/8_ar_sa_6b3k.htm
Managing AWE Memory
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\adm
insql.chm::/ad_1_server_1fnd.htm
Keith
"Rafa" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Keith,
Why would you use the /PAE and AWE switches if his server only has 4 GB RAM.
Those settings are for servers with more than 4GB.
"Keith Kratochvil" wrote:
> Since you are running on Enterprise Edition you could try using /3GB and
or
> /PAE within boot.ini.
> You will then probably want to specify the memory usage within SQL Server
> Using AWE Memory on Windows 2000
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\a
rchitec.chm::/8_ar_sa_6b3k.htm
> Managing AWE Memory
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\a
dminsql.chm::/ad_1_server_1fnd.htm
> --
> Keith
>
> "Rafa?" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
>
>
Memory Utilization
Guys,
I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
can use the whole memory for the SQL Server service...
Just as a 2GB server that I had before, monitoring with Task Manager I see
that the memory utilization don't grow up more than 1,84gb... Even with huge
processing and disk reading... So my question is, is there any kind of
special configuration that you must set to let server use the whole memory?
I know about AWE, but I thought AWE is just for servers who break the 4GB
boundary... Would like to know why the memory utilization don't go upper than
1,84gb, even setting this as a fixed value in Server configuration...
Thx,
RafaHi,
What edition of SQL Server you are using? Only Enterprise or Developer
editions of SQL server supports more than 2 GB memory.
Sheck the version of SQL Server using
Select @.@.version
Thanks
Hari
SQL Server MVP
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Take a look at the following URL
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
There is a \3GB switch
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||According to Books Online
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_ts_8dbn.htm)
the Standard Edition of SQL Server will not use more than 2GB of RAM.
--
Keith
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Hi,
Try /3gb switch in boot.ini
"Rafa®" wrote:
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Well, it's the Enterprise Edition...
What does /3gb in boot.ini?
"Wayne Snyder" wrote:
> Take a look at the following URL
> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
> There is a \3GB switch
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> > Guys,
> > I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> > 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> > can use the whole memory for the SQL Server service...
> >
> > Just as a 2GB server that I had before, monitoring with Task Manager I see
> > that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> > processing and disk reading... So my question is, is there any kind of
> > special configuration that you must set to let server use the whole
> memory?
> >
> > I know about AWE, but I thought AWE is just for servers who break the 4GB
> > boundary... Would like to know why the memory utilization don't go upper
> than
> > 1,84gb, even setting this as a fixed value in Server configuration...
> >
> > Thx,
> > Rafa
>
>|||Since you are running on Enterprise Edition you could try using /3GB and or
/PAE within boot.ini.
You will then probably want to specify the memory usage within SQL Server
Using AWE Memory on Windows 2000
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
Managing AWE Memory
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_1_server_1fnd.htm
--
Keith
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Keith,
Why would you use the /PAE and AWE switches if his server only has 4 GB RAM.
Those settings are for servers with more than 4GB.
"Keith Kratochvil" wrote:
> Since you are running on Enterprise Edition you could try using /3GB and or
> /PAE within boot.ini.
> You will then probably want to specify the memory usage within SQL Server
> Using AWE Memory on Windows 2000
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
> Managing AWE Memory
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_1_server_1fnd.htm
> --
> Keith
>
> "Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> > Guys,
> > I have a server running MS-SQL SP3. The server configuration is a
> > Dual-Xeon
> > 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> > can use the whole memory for the SQL Server service...
> >
> > Just as a 2GB server that I had before, monitoring with Task Manager I see
> > that the memory utilization don't grow up more than 1,84gb... Even with
> > huge
> > processing and disk reading... So my question is, is there any kind of
> > special configuration that you must set to let server use the whole
> > memory?
> >
> > I know about AWE, but I thought AWE is just for servers who break the 4GB
> > boundary... Would like to know why the memory utilization don't go upper
> > than
> > 1,84gb, even setting this as a fixed value in Server configuration...
> >
> > Thx,
> > Rafa
>
>
I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
can use the whole memory for the SQL Server service...
Just as a 2GB server that I had before, monitoring with Task Manager I see
that the memory utilization don't grow up more than 1,84gb... Even with huge
processing and disk reading... So my question is, is there any kind of
special configuration that you must set to let server use the whole memory?
I know about AWE, but I thought AWE is just for servers who break the 4GB
boundary... Would like to know why the memory utilization don't go upper than
1,84gb, even setting this as a fixed value in Server configuration...
Thx,
RafaHi,
What edition of SQL Server you are using? Only Enterprise or Developer
editions of SQL server supports more than 2 GB memory.
Sheck the version of SQL Server using
Select @.@.version
Thanks
Hari
SQL Server MVP
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Take a look at the following URL
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
There is a \3GB switch
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||According to Books Online
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_ts_8dbn.htm)
the Standard Edition of SQL Server will not use more than 2GB of RAM.
--
Keith
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Hi,
Try /3gb switch in boot.ini
"Rafa®" wrote:
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Well, it's the Enterprise Edition...
What does /3gb in boot.ini?
"Wayne Snyder" wrote:
> Take a look at the following URL
> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
> There is a \3GB switch
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> > Guys,
> > I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> > 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> > can use the whole memory for the SQL Server service...
> >
> > Just as a 2GB server that I had before, monitoring with Task Manager I see
> > that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> > processing and disk reading... So my question is, is there any kind of
> > special configuration that you must set to let server use the whole
> memory?
> >
> > I know about AWE, but I thought AWE is just for servers who break the 4GB
> > boundary... Would like to know why the memory utilization don't go upper
> than
> > 1,84gb, even setting this as a fixed value in Server configuration...
> >
> > Thx,
> > Rafa
>
>|||Since you are running on Enterprise Edition you could try using /3GB and or
/PAE within boot.ini.
You will then probably want to specify the memory usage within SQL Server
Using AWE Memory on Windows 2000
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
Managing AWE Memory
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_1_server_1fnd.htm
--
Keith
"Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> Guys,
> I have a server running MS-SQL SP3. The server configuration is a
> Dual-Xeon
> 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> can use the whole memory for the SQL Server service...
> Just as a 2GB server that I had before, monitoring with Task Manager I see
> that the memory utilization don't grow up more than 1,84gb... Even with
> huge
> processing and disk reading... So my question is, is there any kind of
> special configuration that you must set to let server use the whole
> memory?
> I know about AWE, but I thought AWE is just for servers who break the 4GB
> boundary... Would like to know why the memory utilization don't go upper
> than
> 1,84gb, even setting this as a fixed value in Server configuration...
> Thx,
> Rafa|||Keith,
Why would you use the /PAE and AWE switches if his server only has 4 GB RAM.
Those settings are for servers with more than 4GB.
"Keith Kratochvil" wrote:
> Since you are running on Enterprise Edition you could try using /3GB and or
> /PAE within boot.ini.
> You will then probably want to specify the memory usage within SQL Server
> Using AWE Memory on Windows 2000
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
> Managing AWE Memory
> mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_1_server_1fnd.htm
> --
> Keith
>
> "Rafa®" <Rafa@.discussions.microsoft.com> wrote in message
> news:98A36C40-7BAF-4883-902D-D01BFE02FEFB@.microsoft.com...
> > Guys,
> > I have a server running MS-SQL SP3. The server configuration is a
> > Dual-Xeon
> > 2.4Ghz, with 4GB RAM. The server is reserved for running SQL Server, so he
> > can use the whole memory for the SQL Server service...
> >
> > Just as a 2GB server that I had before, monitoring with Task Manager I see
> > that the memory utilization don't grow up more than 1,84gb... Even with
> > huge
> > processing and disk reading... So my question is, is there any kind of
> > special configuration that you must set to let server use the whole
> > memory?
> >
> > I know about AWE, but I thought AWE is just for servers who break the 4GB
> > boundary... Would like to know why the memory utilization don't go upper
> > than
> > 1,84gb, even setting this as a fixed value in Server configuration...
> >
> > Thx,
> > Rafa
>
>
Friday, March 9, 2012
Memory Reserve
Hi All
I just want to know when some queries has completed on SQL 2000 whether the
memory that reserved for it will release after completion the process.
In current sql server which Im using having major issue with memory usage.
It is catching memory when some process is happening, but it won't release
that memory even after hours of that process took place.
Please send some advise
Thaks in advance
JanakaReleasing the memory after a query has executed would defeat the whole purpose of caching data. We
do not want that. I suggest you investigate the issue further and see if it is a real problem to you
(how do you determine that the behavior of SQL Server is a problem), and if for instance setting a
max for memory solves your problem. Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Janaka Sampath" <janakaj@.lankaequities.com> wrote in message
news:uubaDh27FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi All
>
> I just want to know when some queries has completed on SQL 2000 whether the
> memory that reserved for it will release after completion the process.
> In current sql server which Im using having major issue with memory usage.
> It is catching memory when some process is happening, but it won't release
> that memory even after hours of that process took place.
>
> Please send some advise
> Thaks in advance
> Janaka
>
I just want to know when some queries has completed on SQL 2000 whether the
memory that reserved for it will release after completion the process.
In current sql server which Im using having major issue with memory usage.
It is catching memory when some process is happening, but it won't release
that memory even after hours of that process took place.
Please send some advise
Thaks in advance
JanakaReleasing the memory after a query has executed would defeat the whole purpose of caching data. We
do not want that. I suggest you investigate the issue further and see if it is a real problem to you
(how do you determine that the behavior of SQL Server is a problem), and if for instance setting a
max for memory solves your problem. Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Janaka Sampath" <janakaj@.lankaequities.com> wrote in message
news:uubaDh27FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi All
>
> I just want to know when some queries has completed on SQL 2000 whether the
> memory that reserved for it will release after completion the process.
> In current sql server which Im using having major issue with memory usage.
> It is catching memory when some process is happening, but it won't release
> that memory even after hours of that process took place.
>
> Please send some advise
> Thaks in advance
> Janaka
>
Memory Reserve
Hi All
I just want to know when some queries has completed on SQL 2000 whether the
memory that reserved for it will release after completion the process.
In current sql server which Im using having major issue with memory usage.
It is catching memory when some process is happening, but it won't release
that memory even after hours of that process took place.
Please send some advise
Thaks in advance
Janaka
Releasing the memory after a query has executed would defeat the whole purpose of caching data. We
do not want that. I suggest you investigate the issue further and see if it is a real problem to you
(how do you determine that the behavior of SQL Server is a problem), and if for instance setting a
max for memory solves your problem. Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default...;en-us;q321363
http://www.mssqlserver.com/faq/troub...memoryleak.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Janaka Sampath" <janakaj@.lankaequities.com> wrote in message
news:uubaDh27FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi All
>
> I just want to know when some queries has completed on SQL 2000 whether the
> memory that reserved for it will release after completion the process.
> In current sql server which Im using having major issue with memory usage.
> It is catching memory when some process is happening, but it won't release
> that memory even after hours of that process took place.
>
> Please send some advise
> Thaks in advance
> Janaka
>
I just want to know when some queries has completed on SQL 2000 whether the
memory that reserved for it will release after completion the process.
In current sql server which Im using having major issue with memory usage.
It is catching memory when some process is happening, but it won't release
that memory even after hours of that process took place.
Please send some advise
Thaks in advance
Janaka
Releasing the memory after a query has executed would defeat the whole purpose of caching data. We
do not want that. I suggest you investigate the issue further and see if it is a real problem to you
(how do you determine that the behavior of SQL Server is a problem), and if for instance setting a
max for memory solves your problem. Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default...;en-us;q321363
http://www.mssqlserver.com/faq/troub...memoryleak.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Janaka Sampath" <janakaj@.lankaequities.com> wrote in message
news:uubaDh27FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi All
>
> I just want to know when some queries has completed on SQL 2000 whether the
> memory that reserved for it will release after completion the process.
> In current sql server which Im using having major issue with memory usage.
> It is catching memory when some process is happening, but it won't release
> that memory even after hours of that process took place.
>
> Please send some advise
> Thaks in advance
> Janaka
>
Memory Reserve
Hi All
I just want to know when some queries has completed on SQL 2000 whether the
memory that reserved for it will release after completion the process.
In current sql server which Im using having major issue with memory usage.
It is catching memory when some process is happening, but it won't release
that memory even after hours of that process took place.
Please send some advise
Thaks in advance
JanakaReleasing the memory after a query has executed would defeat the whole purpo
se of caching data. We
do not want that. I suggest you investigate the issue further and see if it
is a real problem to you
(how do you determine that the behavior of SQL Server is a problem), and if
for instance setting a
max for memory solves your problem. Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...b;en-us;q321363
http://www.mssqlserver.com/faq/trou...-memoryleak.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Janaka Sampath" <janakaj@.lankaequities.com> wrote in message
news:uubaDh27FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi All
>
> I just want to know when some queries has completed on SQL 2000 whether th
e
> memory that reserved for it will release after completion the process.
> In current sql server which Im using having major issue with memory usage.
> It is catching memory when some process is happening, but it won't release
> that memory even after hours of that process took place.
>
> Please send some advise
> Thaks in advance
> Janaka
>
I just want to know when some queries has completed on SQL 2000 whether the
memory that reserved for it will release after completion the process.
In current sql server which Im using having major issue with memory usage.
It is catching memory when some process is happening, but it won't release
that memory even after hours of that process took place.
Please send some advise
Thaks in advance
JanakaReleasing the memory after a query has executed would defeat the whole purpo
se of caching data. We
do not want that. I suggest you investigate the issue further and see if it
is a real problem to you
(how do you determine that the behavior of SQL Server is a problem), and if
for instance setting a
max for memory solves your problem. Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...b;en-us;q321363
http://www.mssqlserver.com/faq/trou...-memoryleak.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Janaka Sampath" <janakaj@.lankaequities.com> wrote in message
news:uubaDh27FHA.3976@.TK2MSFTNGP15.phx.gbl...
> Hi All
>
> I just want to know when some queries has completed on SQL 2000 whether th
e
> memory that reserved for it will release after completion the process.
> In current sql server which Im using having major issue with memory usage.
> It is catching memory when some process is happening, but it won't release
> that memory even after hours of that process took place.
>
> Please send some advise
> Thaks in advance
> Janaka
>
Subscribe to:
Posts (Atom)