Busy? In medicine? LOL.
I need to make sure of one thing. The current version of SQL in that category is SQL Server 2005 Workgroup Edition. Just want to make sure we are talking apples and apples.
We would basically want to determine what all of the other services and the OS are using and subtract from the total amount of physical RAM and set this as the maximum for SQL.
This would be quite easy to do.
Also what is the size of your page file, and where is it located?
