New answers tagged

2

First, find the person who put that job in place and have him/her tied to a chair listening to cats scratching a chalk board while you go for lunch. When done with that, compare your resource utilization and performance data for extended periods before and after the job runs. I suspect you'll see perf dips and a number of resources getting really busy ...


1

Unfortunately the answer is going to be it depends. From what you have in the maintenance plan it seems whomever put them in place was trying to reset the server statistics, cache and running values at a specific time of the day to what it would be when SQL Server first starts up without actually restarting SQL Server. CHECKPOINT is going to instruct the ...



Top 50 recent answers are included