SQL Server Performance

Windows 2003 x64 R2 w/ sql 2005 developer edition

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by ltmack, Oct 15, 2006.

  1. ltmack New Member

    We 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.
  2. satya Moderator

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

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. MohammedU New Member

Share This Page