I wanted to ask you all about the server setup for DNN. I recently noticed my web servers had no memory max limit set for SQL so it was consuming all my memory and causing slowness.
I have SQL and IIS7 all in the same box so websites are running DNS, IIS & SQL all off the same machine.
I've now limited the SQL to only use up 8GB of my available 16GB but am still noticing my memory usage is maxed out.
I am investigating the app pools for all my DNN websites and that seems to be the second culprit, every time i setup a new DNN site it has its own NEW app pool for just that website so my server that has 35 DNN sites has 35 separate app pools for each site. Should I be creating one shared app pool for all my DNN sites? I'm assuming this would reduce the memory load on my machine but am not sure if this is the way to go?
When adding a new DNN site to IIS7 should i be using the machines administrator account for the "application pass through user" setting? or some other IIS user account?
Thanks for any insight on all this,