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 |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2009-04-02 : 09:41:02
|
| We are running SQL Server 2000 SP4 and Reporting Services on the same server. The main database on it is for our ERP system (lots of transactions).SQL server is currently configured to allocate memory dynamically. Minimum is set to zero and Maximum is set to 2047MB (that's the total memory installed).Is this OK or should it be configured differently? I just want to make sure Reporting Services doesn't interfer with our ERP system.Thanks,Kevin |
|
|
|
|
|
All-on-one memory configuration