SQL Server 2005 64 bit memory question

Hello!

I just installed 64 bit SQL Server 2005 on Windows 2003 SP1 64 bit. I am
puzzled because Total Server Memory (KB) counter shows much higher value
than Total Server memory (KB). I have got 4 GB of RAM installed. My
understanding I do not need to do anything in order to enable SQL Server to
see all 4 GB available. Can someone shed some light on whether I should
expect to see all memory allocated to SQL Server 2005?  Normally, I see
Total and Target counters almost identical on our SQL 200 boxes.

Thanks,
Igor

Hi

If you are running IA-64 (Itanium), then it will use all the memory
automatically.

If it is not using all the memory, it might be due to the fact that you have
not stressed the machine enough and caused enough pages of the DB to be
cached in RAM.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:uUU$n5CCGHA.3744@TK2MSFTNGP10.phx.gbl...
> Hello!
>
>    I just installed 64 bit SQL Server 2005 on Windows 2003 SP1 64 bit. I
> am puzzled because Total Server Memory (KB) counter shows much higher
> value than Total Server memory (KB). I have got 4 GB of RAM installed. My
> understanding I do not need to do anything in order to enable SQL Server
> to see all 4 GB available. Can someone shed some light on whether I should
> expect to see all memory allocated to SQL Server 2005?  Normally, I see
> Total and Target counters almost identical on our SQL 200 boxes.
>
> Thanks,
> Igor
>

It is dynamic so it will not show the same counters until you actually use
the memory.

--
Andrew J. Kelly  SQL MVP


"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:uUU$n5CCGHA.3744@TK2MSFTNGP10.phx.gbl...
> Hello!
>
>    I just installed 64 bit SQL Server 2005 on Windows 2003 SP1 64 bit. I
> am puzzled because Total Server Memory (KB) counter shows much higher
> value than Total Server memory (KB). I have got 4 GB of RAM installed. My
> understanding I do not need to do anything in order to enable SQL Server
> to see all 4 GB available. Can someone shed some light on whether I should
> expect to see all memory allocated to SQL Server 2005?  Normally, I see
> Total and Target counters almost identical on our SQL 200 boxes.
>
> Thanks,
> Igor
>

Mike,

I am running Windows 2003 on AMD Opteron processors. Is Itanium
identifed by processor type or OS type? How can I determine that?

Thanks,
Igor



"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:efV5J0HCGHA.2040@TK2MSFTNGP14.phx.gbl...
> Hi
>
> If you are running IA-64 (Itanium), then it will use all the memory
> automatically.
>
> If it is not using all the memory, it might be due to the fact that you
> have not stressed the machine enough and caused enough pages of the DB to
> be cached in RAM.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "imarchenko" < igormarchenko@hotmai
l.com> wrote in message
> news:uUU$n5CCGHA.3744@TK2MSFTNGP10.phx.gbl... 
>
>

Itanium is the processor type and AMD is not it.

--
Andrew J. Kelly  SQL MVP


"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:%23fGPzzKCGHA.2840@TK2MSFTNGP12.phx.gbl...
> Mike,
>
>    I am running Windows 2003 on AMD Opteron processors. Is Itanium
> identifed by processor type or OS type? How can I determine that?
>
> Thanks,
> Igor
>
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:efV5J0HCGHA.2040@TK2MSFTNGP14.phx.gbl... 
>
>

Hi

Itanium is the real 64 bit processor, RISC architecture.

Opterons are 32 bit processors, CISC architecture, with 64 extensions (as
are the Xeons with EM64T extensions).

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:%23fGPzzKCGHA.2840@TK2MSFTNGP12.phx.gbl...
> Mike,
>
>    I am running Windows 2003 on AMD Opteron processors. Is Itanium
> identifed by processor type or OS type? How can I determine that?
>
> Thanks,
> Igor
>
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:efV5J0HCGHA.2040@TK2MSFTNGP14.phx.gbl... 
>
>

I am slightly confused.  Will SQL Server 64 bit (on Windows 64 bit Opterons
processors) be able to see 4GB out of the box? Do I have to make any
configurational changes to enable SQL Server to see 4GB I have?

Thanks,
Igor


"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:O9$hjcMCGHA.4040@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Itanium is the real 64 bit processor, RISC architecture.
>
> Opterons are 32 bit processors, CISC architecture, with 64 extensions (as
> are the Xeons with EM64T extensions).
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "imarchenko" < igormarchenko@hotmai
l.com> wrote in message
> news:%23fGPzzKCGHA.2840@TK2MSFTNGP12.phx.gbl... 
>
>

64 bit SQL Server 2005 on a 64 bit OS will see as much memory as the OS
supports - I think around half a terabyte.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:upjfIQQCGHA.2356@tk2msftngp13.phx.gbl...
>I am slightly confused.  Will SQL Server 64 bit (on Windows 64 bit Opterons
>processors) be able to see 4GB out of the box? Do I have to make any
>configurational changes to enable SQL Server to see 4GB I have?
>
> Thanks,
> Igor
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:O9$hjcMCGHA.4040@TK2MSFTNGP12.phx.gbl... 
>
>

Roger,

I have been trying to stress out SQL Server 2005 64 bit by running up to
255 instances of the same query using ostress. Total
Server Memory (KB) went up to 52992. Target Server Memory KB) number is
2864544. I still can not explain why SQL Server Total Server Memory is still
so low. Would you have an explanation for this? I have 4GB of RAM on the
server running Windows 2003 64 bit.

Thanks,
Igor


"Roger Wolter[MSFT]" <rwolter@online.microsoft.com> wrote in message
news:%23mb4$$RCGHA.228@TK2MSFTNGP12.phx.gbl...
> 64 bit SQL Server 2005 on a 64 bit OS will see as much memory as the OS
> supports - I think around half a terabyte.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "imarchenko" < igormarchenko@hotmai
l.com> wrote in message
> news:upjfIQQCGHA.2356@tk2msftngp13.phx.gbl... 
>
>

What are the queries accessing?  If they are all accessing a small portion
of the db over and over again then only that data will be in cache. Just
because SQL Server has that much memory available to it does not mean it
will use it.

--
Andrew J. Kelly  SQL MVP


"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:O4ukUWzCGHA.2480@TK2MSFTNGP10.phx.gbl...
> Roger,
>
>    I have been trying to stress out SQL Server 2005 64 bit by running up
> to 255 instances of the same query using ostress. Total
> Server Memory (KB) went up to 52992. Target Server Memory KB) number is
> 2864544. I still can not explain why SQL Server Total Server Memory is
> still so low. Would you have an explanation for this? I have 4GB of RAM on
> the server running Windows 2003 64 bit.
>
> Thanks,
> Igor
>
>
> "Roger Wolter[MSFT]" <rwolter@online.microsoft.com> wrote in message
> news:%23mb4$$RCGHA.228@TK2MSFTNGP12.phx.gbl... 
>
>