Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of the development servers started alerting due to the Index Maintenace job failing. The first day, I ignored it because it was a development server. On day Read More …
No, No, not those dumps: SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First Responder Kit utilities by Brent Ozar ( b | t ). I don’t usually poke my head in this channel. This particular day I was browsing Read More …
Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location to store SQL Backups. We have a nightly job that runs full copy only backups of a couple critical databases that are scrubbed and restored to Read More …
Do you frequently use the “log_reuse_wait_type_desc” column in the sys.databases view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting an issue with a database where the log was growing and the virtual logs would not clear after executing a transaction log backup. So I took Read More …
Two weeks ago I was on-call and at 4:45AM Saturday morning my phone rang and the dreaded contact “NOC” was on the screen. After finding my phone and answering, the NOC technician explained that we had a Tier 2 server that had the log drive out of space. After letting them know I would check Read More …
I know it is a weird time to be putting out a blog post. But I have 28 hours to keep my goal of 52 blogs in 52 weeks going. You say it is only week two and you are this far behind. This week was hectic since I was on-call at work. So I Read More …
