Skip to Content
0
Former Member
Dec 01, 2008 at 03:11 PM

Memory for MS-SQL is optimal?

38 Views

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?