If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want to ...
Running 2 x Windows 2003 x64 Enterprise in a failover cluster. 24gb RAM each<BR>SQL 2005 x64 SP2<BR><BR>My SQL instance is running at about 17gb of pagefile usage. Instance memory ceiling is set at ...