This is the server information:
SQL Server 2005 -- Standard Edition --64 bit --64 bit OS
RAM - 8 GB -- 8 processors
SQL Server is using 4 GB of RAM ...
1. We are expecting that there is more RAM space , that the SQL Server can utilize ... What and all options that I need to change ..
2. what are the best practices on this environment fot effectively utilizing the server resources.
Since it is a 64 bit sql server, enabling AWE is not usefull .. any suggestions highly appreciated.
-- Reddy Balaji C. ##Mark as answer if it solves the issue
View Complete Post