We have customers who are running low-end machines with 1GB RAM (or even less). We are thinking to upgrade our app to SQL Server Express 2008. I understand that nothing will replace real-life testing but I have few questions:(1) is SQL Server Express 2008 a good/fair choice for such hardware or not at all ?(2) can "Maximum server memory" parameter help to make SQL Server Express less aggressive in terms of memory consumption?(3) what is the reasonable minimum for "Maximum server memory" so the application can actually work without dramatic performance penalties ?(4) how, if at all, "Maximum server memory" can be configured in programmatic way (SQL, Xml, registry rtc) ?(5) The spec for SQL Server Express says that it cannot use more than 1GB of memory. When I start Server management Studio and go to Properties->Memory tab, the parameter "Maximum server memory (in MB)" shows 2147483647 - is this numbe ...
Go to the complete details ...