how to improve memory utilization?

We have a SQL 2005 Standard Server, single-processor license, in a
Win2k3 SP1 Standard Server box.
We recently increased its RAM to 4GB and added the /3GB switch to the
boot.ini file.
However, we still receive occasional alerts such as the one below:
Device: SQL
Service: Memory Utilization
State Transition: From Warning To Failed Time Of State Transition:
12/17/06 1:01 AM
Probe(s): 172.16.0.12
Scandetails:
Total Physical Memory (KB): 3145208
Used Physical Memory (KB): 3007896
Free Physical Memory (KB): 137312
Physical Memory Usage (%): 96
Total Virtual Memory (KB): 4190208
Used Virtual Memory (KB): 64500
Free Virtual Memory (KB): 4125708
Virtual Memory Usage (%): 2
Alert: 0
Alert Activated: 12/17/06 1:01 AM
Alert Sent: 12/17/06 1:11 AM
The timing of events like this is not a big deal, it does not affect
end users, but I thought after we increased the available RAM, such
events would go away. And 12/17/06 is a Sunday. There was a test backup
running, but this error has not always appeared during other similar
nightly backups.
So far as I know there are no scheduled activities on the SQL server at
that time, so I am wondering if there is something I should do in the
SQL Server configuration to make it use memory better.
The pagefile is 4GB by the way. I found the Slava Oks blog about SQL
memory but it was over my head.
Thank you, TomIf there is no other usage of the computer, I would recommend reducing the
page file to the minimum -or eliminating it altogether.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"tlyczko" <tlyczko@.gmail.com> wrote in message
news:1166452468.090918.44710@.l12g2000cwl.googlegroups.com...
> We have a SQL 2005 Standard Server, single-processor license, in a
> Win2k3 SP1 Standard Server box.
> We recently increased its RAM to 4GB and added the /3GB switch to the
> boot.ini file.
> However, we still receive occasional alerts such as the one below:
> Device: SQL
> Service: Memory Utilization
> State Transition: From Warning To Failed Time Of State Transition:
> 12/17/06 1:01 AM
> Probe(s): 172.16.0.12
> Scandetails:
> Total Physical Memory (KB): 3145208
> Used Physical Memory (KB): 3007896
> Free Physical Memory (KB): 137312
> Physical Memory Usage (%): 96
> Total Virtual Memory (KB): 4190208
> Used Virtual Memory (KB): 64500
> Free Virtual Memory (KB): 4125708
> Virtual Memory Usage (%): 2
> Alert: 0
> Alert Activated: 12/17/06 1:01 AM
> Alert Sent: 12/17/06 1:11 AM
> The timing of events like this is not a big deal, it does not affect
> end users, but I thought after we increased the available RAM, such
> events would go away. And 12/17/06 is a Sunday. There was a test backup
> running, but this error has not always appeared during other similar
> nightly backups.
> So far as I know there are no scheduled activities on the SQL server at
> that time, so I am wondering if there is something I should do in the
> SQL Server configuration to make it use memory better.
> The pagefile is 4GB by the way. I found the Slava Oks blog about SQL
> memory but it was over my head.
> Thank you, Tom
>|||Really' How come' Would you mind providing some explanation' (or a
link to an explanation)
Is it okay to shrink the pagefile to say 1GB or 512MB' instead of
eliminating it'
Our largest database is around 3GB (Great Plains) but it may someday
take on a SharePoint Services database as well, which could become
quite large, I know.
The box has one single Xeon 2.8 Ghz processor.
We do also have Abra Suite running on it (with FoxPro tables, this is
the server-side part of it, the client runs in Citrix).
(I know SQL does its own memory management etc.)
Thank you, Tom
Arnie Rowland wrote:[vbcol=seagreen]
> If there is no other usage of the computer, I would recommend reducing the
> page file to the minimum -or eliminating it altogether.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "tlyczko" <tlyczko@.gmail.com> wrote in message
> news:1166452468.090918.44710@.l12g2000cwl.googlegroups.com...