Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
 Posted - 2004-12-09 : 02:32:08
|
| Hey all,Well, after a couple of timed-out seaches, I figured I'd just open a topic to try and find out - do you or don't you?Have you got regularly scheduled reboots for SQL Servers? Specifically SQL 2000 (sp3) on Windows 2000 (sp3), but in general, for you environment as well?Is that "old-school" thinking?CiaO 4 NoW*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-09 : 05:33:52
|
| Nope |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-12-09 : 05:53:53
|
| MSSQLSERVEROLAPSERVICES - Daily :-(rockmoose |
|
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2004-12-09 : 06:24:39
|
| NopeServer Uptime of 300 DaysSql Server Uptime of 205 DaysWin2k With Latest Service Pack |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-09 : 16:10:47
|
| Scheduled reboots of SQL Server is not a good idea since you will get a negative performance impact after the reboot occurs until SQL Server regains the memory it needs. I've seen it take a couple of hours to catch up, which is visible using PerfMon. So reboots should only happen when necessary for maintenance like software installations that require reboots or as an emergency.Tara |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-10 : 01:23:05
|
| nope, we don't do reboots unless needed and during scheduled maintenance.--------------------keeping it simple... |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-12-10 : 03:36:36
|
| Seems to be a general consensus, then.Thanks for the feedback*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-10 : 13:56:58
|
| No scheduled reboots here either. Reboots for our SQL Server are pretty rare.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
POLL : Scheduled Server reboots?