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 |
|
elmerrill81
Starting Member
2 Posts |
 Posted - 2007-09-11 : 15:01:58
|
| when I start AS 2000 I find The server is out of memory in the Event Viewer, Application Log. This error occurs when the server starts and when it processes cubes. Now it's a 2 GB machine and i've set the low memory threshold to 1 GB with the max being 1.5. Any other suggestions? |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-11 : 15:25:15
|
quote:
Originally posted by elmerrill81
when I start AS 2000 I find The server is out of memory in the Event Viewer, Application Log. This error occurs when the server starts and when it processes cubes. Now it's a 2 GB machine and i've set the low memory threshold to 1 GB with the max being 1.5. Any other suggestions?
Honestly, sounds like you need more RAM.
Future guru in the making. |
 |
|
|
elmerrill81
Starting Member
2 Posts |
Posted - 2007-09-11 : 16:11:53
|
quote:
Originally posted by Zoroaster
quote:
Originally posted by elmerrill81
when I start AS 2000 I find The server is out of memory in the Event Viewer, Application Log. This error occurs when the server starts and when it processes cubes. Now it's a 2 GB machine and i've set the low memory threshold to 1 GB with the max being 1.5. Any other suggestions?
Honestly, sounds like you need more RAM.
Future guru in the making.
I guess my question is what's causing this error on start up, and what counters should I use to monitor to determine if it's a memory problem. I used pages/sec and found nothing there.. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-11 : 16:58:03
|
| http://www.sql-server-performance.com/tips/olap_performance_cubes_p1.aspxhttp://www.mosha.com/msolap/tech.htm#PerformanceCubes depending on dimensions/data and how you process them can take up alot of memory after all when you issue an mdx query it's retrieving the data from memory. You may want to add more memory, process and store less data, or use a different approach instead of molap try rolap or holap.PS: If you are interested in a high paid SQL job in Connecticut CT give me a shout or send me your resume to ValterBorges@msn.com |
|
|
|
|
|
|
The server is out of memory.