When SQL Server performance sucks, "Just reboot it." is common phrase from one of my colleagues. And surprisingly, it often seems to fix the problem. However, the improvement is usually temporary. Restarting SQL Server clears the buffer cache, execution plan cache, and other diagnostic data, which can hide the real root cause. In this article, we will explore why rebooting appears to improve performance and why you should avoid this bad habit.
[More]