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..
Working with 30000 data files in one database – why do my log backups take so long?