Skip to content
Twitter Email LinkedIn
Menu

GarryBargsley.com

GarryBargsley.com

Primary Menu

  • Home
  • About
Search

Category: Troubleshooting

Checking your dumps!!!

Posted onOctober 6, 2020October 10, 2020Leave a comment

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 …

CategoriesBlogging, dbatools, First Responder Kit, SQL, Troubleshooting

Why a 60GB Database Backup Grew to 1TB in Size

Posted onAugust 11, 2020August 10, 2020Leave a comment

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 …

CategoriesBlogging, SQL, Troubleshooting

OLDEST_PAGE Log Reuse Wait type

Posted onSeptember 24, 2019September 20, 2019Leave a comment

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 …

CategoriesBlogging, SQL, Troubleshooting

The Story of the Stubborn Transaction Log

Posted onJanuary 26, 20182 Comments

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 …

CategoriesBlogging, SQL, Troubleshooting

Ghost Replication and the Growing Log File

Posted onJanuary 13, 2018Leave a comment

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 …

CategoriesBlogging, SQL, Troubleshooting

Recent Posts

  • [MSSQLTIPS] Rookie of the Year Candidate – Vote for ME
  • [PowerShell Newbie] Using Start-Transcript
  • Export SQL Server Configurations for DR purposes
  • Blog Refresh – Growing Readers
  • How To: Create Schema Only Database Copies

Recent Comments

  • Nira on [PowerShell Newbie] Using Start-Transcript
  • Kevin3NF on Blog Refresh – Growing Readers
  • gbargsley@gmail.com on Copying an Azure SQL Database
  • Chuck Hottle on Copying an Azure SQL Database
  • gbargsley@gmail.com on T-SQL Tuesday #130 – Automate Permissions Audits

Latest Tweets

My Tweets

Archives

  • January 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • December 2019
  • November 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • February 2019
  • January 2019
  • December 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • September 2017
  • August 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017

Categories

  • #100DaysOfCode
  • Azure
  • BBQ
  • Blogging
  • dbachecks
  • dbatools
  • First Responder Kit
  • MSSQLTips
  • PASS
  • PowerShell
  • SQL
  • SQL Saturday
  • Troubleshooting
  • Tsql Tuesday
Copyright © 2021 GarryBargsley.com. All Rights Reserved. | Clean Journal by Catch Themes
Scroll Up
  • Home
  • About
Share On Facebook
Share On Twitter
Share On Linkedin
Share via E-Mail