Tagged Questions
2
votes
2answers
195 views
Minimum/Maximum Server Memory in SQL Server 2005 with /3GB and /Userva switches
I have a 32-Bit Windows 2003 machine with 3.75GB RAM running one SQL Server 2005 instance. I am trying to optimize memory. If I use the switches in boot.ini like below,
/3GB /Userva=2490
should I ...
1
vote
1answer
1k views
Quick look at how much RAM is allocated to SQL Server?
With SQL Server 2005, you could look at the Task Manager and, at least, get a cursory look at how much memory is allocated to SQL Server.
With SQL Server 2008, the Working Set or Commit Size never ...
4
votes
1answer
130 views
SQL Server falling below 5000 free pages
I have set alerts on two SQL Server 2005 instances I have in production.
One of those alerts is sent whenever the Free Pages performance counter falls below the 5000 pages mark.
Both servers normally ...
2
votes
1answer
144 views
How to increase the amount of memory sql server uses on the server?
On the db server, we have 4 GB of memory. Currently, the memory utilization of Sql Server 2005 on that server is 1,725,000 K and the total memory usage is stable at 2.04 GB. The Cpu usage on the ...
