I have a new server running SQL 2008 with 2.5 GB RAM and noticed all the available memory was being allocated. In task manager SQL was not taking up much memory, but once the service was stopped, my available memory nearly tripled.
I was not aware there is a max memory setting in SQL configuration. This is probably the cause of my memory leak? What do you suggest I change this max setting to?
View Complete Post