Category: Troubleshooting

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 …