We have an ASP.NET application with MS SQL 2005 Express database.
The server OS is a Windows Server 2003 Standard x64 sp . The machine is dedicated to this application and database and runs nothing else.
We have upgraded to 4GB of ram and are considering what would be the appropriate settings for memory options for MSSQL. Given 4GB of RAM on the machine what should the numbers for Minimum server memory and minimum memory per query be? Should I also have a number for query govenor (we have some long running queries)?