>1. As I have worked with these settings over the years, I have assumed that I am setting memory usage on the local machine where the application is running. In some of the threads that I have read, there is some implication that we are referring to the memory at the server. Am I mis-reading this? There is clear reference that as the number of users increase there is less available memory to each user. If anyone could clarify this issue for me it would be much appreciated.
Perhaps you were reading about making the settings on a terminal server?
With the size of your database, have you thought of making a copy for reporting and taking some of the strain off of your tps? Just a thought.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown