Thanks for your help.
Yea..Its windows 2003 Enterprise edition 32 bit and SQL server 2005 32 bit.
So Do i set the max memory setting for...
Its windows 2003 Ent 32 bit
Thanks, here are the values.
SQL Server Memory Manager:
1) Target Server Memory - max -1048576, Min-1022904, Average - 1048319
2) Total Server...
I am sorry..am new to SQL administration...could you please tell me how do I check these values?
We have performance issue on one of our prod servers.
it is Windows 2003 which has 8GB of RAM on it and running SQL server 2005.
Separate names with a comma.