Reboot

Question

Reboot

krishna83

Ten Centuries

Points: 1003
More actions
June 6, 2017 at 3:21 am

#337458

SQL server running slow after reboot

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

A reboot will clear out the plan cache so following the reboot a new plan will need to be created. This may account for the performance degradation you are seeing.

What was the reason for the reboot?

Thanks

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 2

NorthernSoul - Tuesday, June 6, 2017 3:30 AM
A reboot will clear out the plan cache so following the reboot a new plan will need to be created. This may account for the performance degradation you are seeing.
What was the reason for the reboot?
Thanks

I missed off about the data cache too. The reboot will clear data out of the buffer so initially the data will need to be read from disk which is slower and uses more resource.

Thanks

krishna83 Ten Centuries Points: 1003 More actions · Answer 3

We found some maleware in machine, so we removed it and rebooted the server.

andreas.kreuzberg SSCertifiable Points: 6186 More actions · Answer 4

Hi,
you can try to monitor this 2 counter:

Buffer Cache Hit Ratio
Plan Cache Hit Ratio

After a SQL Server reboot the values should not be so good, and after some hours of work, the performance counter should lock better.