How often should I schedule a reboot of SQL Server 2005?

How many times per year should we schedule time to reboot a SQL Server 2005 Cluster?We want to do this to defrag the memory.What I am looking for is a document from Microsoft or a consulting firm that has a good reputation that I can show my manager.

Hi

I don't think you need to scdedule a restart for SQL 2005 cluster. SQL Server 2005 is very efficient at managing the memory dynamically.

Jag

|||

There is no need to restart SQL Server on a regular basis. As SQL doesn't need memory it will release it. SQL Server 2005 is very good at managing it's memory.

If you want to clear it's cache you can use DBCC FREESYSTEMCACHE to free all the cache pools.

|||Unless you do not want to loose cached data and query plans, you should not do this :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||You don't need to do it -- this product is designed to stay up ad infinitum (well apart from if you patch it or the OS requiring a reboot).|||

If I am running SQL Server 2005 in a clustered environment, what is the safest way to restart the SQL server agent? It is currently running but I need to restart it for maintenance purposes.

Is the safeway way to restart is to login to the SQL Server Management Studio as the system administrator, select the SQL Server Agent object, right-mouse click and select "Restart?"

|||That should work fine.