migrated sql 2005 32 bits to sql 2005 64 bits

Last Post 15 Nov 2010 06:27 AM by russellb. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ctseah
New Member
New Member

--
11 Nov 2010 04:40 PM
Hi,

I have just migrated the current sql 2005 32 bits developer edition to sql 2005 64 bits developer edition.
Wonder whether there is anything I need to tune in term of memory to enable sql server to benefit from it.

Thanks &
Regards
gunneyk
New Member
New Member

--
11 Nov 2010 07:07 PM
SQL Server will automatically recognize all the memory available to it. You might want to set a MAX Memory to leave some for the OS or any other apps you may run on the server with it.
russellb
New Member
New Member

--
15 Nov 2010 06:27 AM
Make sure lock pages in memory is granted to sql service account


Acceptable Use Policy
---