mikntwd


Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.

A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.

There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.

Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box

Please let me know. Thank you.




Re: Microsoft##EESS and MSDE SQL 2000 on Windows 2003 Small Business Server

Arnie Rowland


Yes.

You might also investigate setting the MAX memory setting for both SQL instances.







Re: Microsoft##EESS and MSDE SQL 2000 on Windows 2003 Small Business Server

Hemantgiri S. Goswami

Hi,

Yes you can update with SQL Server SP4.

Refering to SQL Server memory architecture it goes upto maximum limit specify by you, and if not specified it can eat up all the memory it can access and freed up as N when require by another resources. I think below articles are good enough to clear it

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

http://msdn2.microsoft.com/en-us/library/ms187499.aspx

HTH

Hemantgiri S. Goswami