Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hossola
Starting Member
1 Post |
 Posted - 2011-06-27 : 18:06:12
|
| Hello,Hope that you can help.. I sure do appreciate it. I have a Virtual Machine running on Windows Hyper V. The OS is 2K3 enterprise. I have allocated all 4 CPUs at 100 resources and 8096mb of memory for the VM.I am running SQL standard 2005. The application using the DB is Everest, which is an ERP system. I am having performance issues with the server and find it odd that it never seems to use more than about 1.7-2GB memory or break 25-30% CPU….Do you know what may be causing it not to use the full amount of memory allocated to it?In the management studio I set it to have a min of 4GB and a Max of 24GB. Thanks so much!!Robert Hanson |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-27 : 18:15:26
|
| How are you checking memory?32 bit SQL or 64 bit? What about the OS?--Gail ShawSQL Server MVP |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-27 : 19:49:25
|
| Also, how are you determining that the system has enough of a load to force additional memory usage? How big is your database?=======================================I have never met a man so ignorant that I couldn't learn something from him. -Galileo Galilei, physicist and astronomer (1564-1642) |
|
|
|
ZZartin
Starting Member
30 Posts |
Posted - 2011-06-29 : 17:48:55
|
| Have you checked the server properties? Maybe the max memory isn't set as high as you want it or some of the CPU's are not enabled. Also have you checked in windows, maybe the OS isn't detecting the resources allocated to it correctly. |
|
|
|
|
|
|
SQL Server wont use more memory