duanelawrence


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.





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

Jag Sandhu


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







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

mrdenny

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.







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

Jens K. Suessmeyer

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


Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---




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

BigE

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).



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

UnixAdmin

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 "






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

GlennAlanBerry

That should work fine.