troubleshooting

The #1 Thing to Never Do to Fix a Performance Problem

The #1 Thing to Never Do to Fix a Performance Problem

Never, ever, disable backups to fix a performance problem.

If you’re not having a performance crisis, you might look at that sentence and say, “Wow, that’s super dumb! Who would ever do that?”

Well, a lot of people, actually. It’s pretty common.

Error Configuring DataCollector: A collection set cannot start without a schedule

Error Configuring DataCollector: A collection set cannot start without a schedule

When setting up data collection using the GUI, configuration failed halfway through setup. At the point  of failure I found there were SQL Agent jobs for collections visible, but nothing appearing  in Management Studio under Management\Data Collection. The Data Collection icon still had the ‘off’ down red arrow. (I manually refreshed it for good measure to make sure.)