HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.relationalserver.performance » 64 bit SQL Server 2005 Memory

Topic: 64 bit SQL Server 2005 Memory

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/15/2008 1:21:02 PM

By: Anonymous

I have a x64 bit installation of SQL Server 2005 Developer edition on windows
server 2003. The box has 8gb of memory and I've set the max memory to

2147483647 MB in the properties whenever I take a look at task manager the
Memory usage for sqlservr.exe is at about 117,236KB.

I'm not sure why the memeory usage is so low. Did I forget to configure
something?

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/15/2008 2:18:32 PM

By: TheSQLGuru

Re: 64 bit SQL Server 2005 Memory

Run DBCC memorystatus and you will probably see that memory usage is not as
low as you think. Some things don't get reported correctly on 64 bit boxes.
Some of the performance monitor counters will give the correct amount too.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

"JDS" <JDS@discussions.microsoft.com> wrote in message
news:02EEA36E-8FC0-4514-9300-5F4587C80249@microsoft.com...
>I have a x64 bit installation of SQL Server 2005 Developer edition on
>windows
> server 2003. The box has 8gb of memory and I've set the max memory to
>
> 2147483647 MB in the properties whenever I take a look at task manager the
> Memory usage for sqlservr.exe is at about 117,236KB.
>
> I'm not sure why the memeory usage is so low. Did I forget to configure
> something?

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/15/2008 6:12:55 PM

By: Andrew J. Kelly

Re: 64 bit SQL Server 2005 Memory

Task manager is not the proper tool for looking at memory usage of SQL
Server, especially anything over 2GB. Look at the SQL Server Memory Manager
counters for Total and Target memory instead. And just because there is 8GB
available does not mean SQL Server is using it.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"JDS" <JDS@discussions.microsoft.com> wrote in message
news:02EEA36E-8FC0-4514-9300-5F4587C80249@microsoft.com...
>I have a x64 bit installation of SQL Server 2005 Developer edition on
>windows
> server 2003. The box has 8gb of memory and I've set the max memory to
>
> 2147483647 MB in the properties whenever I take a look at task manager the
> Memory usage for sqlservr.exe is at about 117,236KB.
>
> I'm not sure why the memeory usage is so low. Did I forget to configure
> something?

Page 1 of 1 Pages