• Are there other applicaitons running on the server? Else I see little reason to see Max Server Memory to 2GB when you have 4GB in the machine. Set it to 3GB.

    Whether you actually need more RAM, it's hard to say, but 4GB is not much in a databse server these days. Of course, if you add more RAM, don't forget to change Max Server Memory.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]