Quote Originally Posted by koolsid
My insignificant piece on this topic

People usually do it... I was curious so I checked with my IT Head. He told me it is good if you re-boot the server every month as it releases a lot of memory... I asked him if he does it... strangely he doesn't because he doesn't get the time... but then he also said that he would love to...

I also checked the web and found that what he said is absolutely true for example see this link (point 5)...

http://blog.sqlauthority.com/2007/09...ommand-prompt/
Oner person saying "yeah! I do that" doesn't make it true.... especially for point #5 ... if the temp DB needs to be cleaned out that often, then the dba and the developers need to take a GOOD LONG LOOK at their processes and stored Procs. There's way too many temp tables being created and not dropped (that's what causes the growth of tempdb) ... And I don't think "people usually do it" ... I think a "few" and it's a very small number, do it and it's only because of a unfounded paranoid believe that it is good. Reboots of a server should be kept to a minimum and only as a last resort.

-tg