SQL Server reboot recommedations

sql server guru's,

we follows weekly/ monthly/ quarterly sql server reboot general practice, did not came across recommendations ms after days sql services/ server needs restarted?

please guide..thank in advance

regards,

nilesh

---

- nilesh

in addition olaf response,

may ask reason doing reboot? have seen people lot of times, wanted clear stuff, clean statistics, clear memory cache, rebuild indexes, , on. sql server have build in options actions. if reason reboot, please don't , try use options example

clean memory: dbcc freeproccache
http://msdn.microsoft.com/en-us/library/ms174283.aspx

removes clean buffers buffer pool: dbcc dropcleanbuffers
http://msdn.microsoft.com/en-us/library/ms187762.aspx

reset wait , latch statistics.: dbcc sqlperf
http://msdn.microsoft.com/en-us/library/ms189768.aspx

drops statistics: drop statistics
http://msdn.microsoft.com/en-us/library/ms175075.aspx

reorganize , rebuild indexes
http://msdn.microsoft.com/en-us/library/ms189858.aspx

---

[personal site]  [blog]  [facebook]

SQL Server  >  SQL Server Database Engine