Dears:
Please see my SAP environment as below:
OS:Windows 2003 Enterprise Version
SAP: CRM 4.0
DB:SQL 2000 SP2
Total Memory: 16G
CPU: 8
And do you have any method to check if the allocation of Memory for MS-SQL is optimal? My current memory setting for SQL 2000 is 4096M, which is set fixed in the SQL database. So i am not sure if the memory setting for the SQL is optimal?