Slow-Running Query Due To Optimizer Timeout
Working as a Principal DBA in Coeo’s Remote DBA Team, I’m occasionally asked to talk to a prospective customer about how our team operates and to give them a technical overview of Coeo’s Remote DBA service. I’m often struck by how pleasantly surprised they are with what they hear about how we..
In my previous post I discussed an instance where SCOM was failing to monitor the space of a SQL Server database. In this latest post I want to bring to light an issue that was altogether more serious.
I particularly wanted to write this post because, although there are a number of possible..
As a SQL Server DBA, you may be working in environment that is monitored by System Center Operations Manager. If so, you’ll probably spend a lot of time in building a monitoring platform and configuring it to ensure that the DBA team get woken up when things start (or about to start) going wrong.
Working with 30000 data files in one database – why do my log backups take so long?