Re: Seems like only 1GB RAM being used even when higher MAX RAM is

The only governors are the ones that dictate how much memory a specific edition can use. It sounds like you do not in fact have standard edition but MSDE instead which will only use 1GB regardless of how much you have in total. If you do in fact have Standard edition then all of the defaults should allow you to use up to 2GB including the MemToLeave area which will make it look like you are only using 1.7GB if you look in Task Manager. Make sure you do not have the Max Memory set to anything other than the default. SQL Server can swap memory out if the OS is calling for more. Are there any apps running on that server other than SQL Server? Can you post the results of sp_configure?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Larry Epn" <larryepn@xxxxxxxxxxxxxxx> wrote in message news:46BC6E17-A618-4372-86F9-FE489E9150A8@xxxxxxxxxxxxxxxx
Thank you for your post.
I had already also tried (as one of my many attempts at every permutation
possible in the SQL Ent Mgr memory configuration applet) to do that, and it
had no effect at raising the amount of CPU used.
This is one of those problems we've had for a while and I've made various
feeble attempts recently at finding a solution (e.g., research and forums
like this)....I am thinking I'm going to have to get Micro$oft involved with
a paid $upport call. I'm sure there will be a hidden configuration governor
somewhere and I'll be at fault.
Thanks for any additional insights,
Larry

.

Relevant Pages

  • Re: More than 2G of Ram
    ... That is what lead me to think about the 2G memory ... > Columnist, SQL Server Professional ... > to 2G since that is all standard edition can support. ... Sql server is allowed to use a maximum of 3.5G of ram. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL-Server 2005, edition specifications
    ... I'd just like to point out that SQL Server 2000 Standard Edition is not ... limited to 2GB databases. ... Perhaps you meant how much memory SQL Server could ...
    (microsoft.public.sqlserver.server)
  • Interesting question about memory usage - standard edition
    ... I have sql server 2000 standard edition (windows 2000 ... This edition has restriction of 2048MB of memory ... I collected statistics using performance monitor. ...
    (microsoft.public.sqlserver.server)
  • RE: Error: Not enough memory to run this query
    ... > Total Server Memory counter amounts to 1.7Gb. ... > Task Manager shows that SQL Server process has eaten 1.8Gb. ... > So SQL thinks it has not enough memory when it is more than enough. ... need to upgrade to SQL Server enterprise edition as Standard edition has a ...
    (microsoft.public.sqlserver.server)
  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
Loading