SQL Server Performance Forum – Threads Archive
Windows 2003 x64 R2 w/ sql 2005 developer editionWe have a server with 32GB RAM and four 2.2GHZ dual core intel processors running SQL Server 2005 Developer Edition and little else. It would appear that the SQL process is using very little of the available memory (less than 1GB). Full Text queries using FREETEXTTABLE and CONTAINSTABLE run rather slowly. How can we get SQL to use most of the available RAM? What performance tips should we be considering? The whole purpose of buying this server was to see if we could improve performance of the database but so far the speed difference b/t this server and our 2GB RAM DB server is minimal.
http://msdn2.microsoft.com/en-us/library/ms142560.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Read Slava Oks’s WebLog to make use available memory in 64 bit… http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx