There are times when updates force you to reboot, but otherwise, your server is meant to run without a reboot for quite a while. Reboots should work without an issue, but if there is one, I want to be the one there when it happens.
Agreed. I dislike rebooting servers remotely unless I have hardware KVM access. There's always a chance someone left something in the drive or you might have to strike a key to continue.
That's why I suggest just restarting the SQL instance:
net stop mssql$AmazingCharts
net start mssql$AmazingCharts
You'll get the same speed difference. I know several people who schedule that command to run nightly. Keeps things running nice and smooth.
.png "ACUF Donor I")
