Skip to content

Opinionated SQL

When no one else will tell you that you're holding it wrong...
  • Home
  • Who and Why
  • Send Me Your Thoughts

Auditing To the Security Event Log – SQL Server Error 33204 and OS Error 8

March 22, 2022 Sean Gallardy 1 Comment

It’s Great When No One Asks Questions You’re taking the best steps to track what goes on in your instance…

Continue Reading →

Posted in: Security, SQL Server Filed under: Auditing, Security, SQL Server, Windows Server

When Using Availability Groups, Beware of Mirroring Behaviors

January 21, 2022 Sean Gallardy 7 Comments

Many DBAs haven’t had the experience of using database mirroring, since it was deprecated in 2012 when availability groups were…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: App Compat, Drivers, HADR, Mirroring, SQL Server

What Interests You?

December 5, 2021 Sean Gallardy Leave a comment

I’ve been writing some technical, some troubleshooting, but all items that come up often enough without a resource that when…

Continue Reading →

Posted in: General Info, Non-Technical Filed under: Your Thoughts

Demystifying Dumps: Stalled Dispatcher

December 1, 2021 Sean Gallardy 1 Comment

Hey Dispatch, We Have a Code 8 If you’ve been following with the series of demystifying dumps then you’re probably…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Demystified, Dump, Dumps, Non-Yielding, SQL Server, stalled, stalled dispatcher, Windows, Windows Server

Demystifying Dumps: Non-Yielding (Stalled) IOCP

November 18, 2021 Sean Gallardy 2 Comments

What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO.…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Debugging, Demystified, Dump, Dumps, IOCP, Non-Yielding, SQL Server, Windows, Windows Server

Understanding the HADR_SYNC_COMMIT wait

September 22, 2021 Sean Gallardy 2 Comments

Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL…

Continue Reading →

Posted in: HA/DR, SQL Server, Waits Filed under: AGs, Always On, Availability Groups, HADR, HADR_SYNC_COMMIT, Monitoring, SQL Server, Synchronous Commit, Threads, Wait Types, Waits

Demystifying Dumps: Access Violation

August 29, 2021 Sean Gallardy 1 Comment

Access Violations (AV) are another common error that will cause SQL Server to take a memory dump. These can occur…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Access Violation, Debugging, Demystified, Dump, Dumps, SQL Server, Windows, Windows Server

Demystifying Dumps: Non-Yielding Scheduler

August 23, 2021 Sean Gallardy 6 Comments

One of the most common items that will cause a memory dump in SQL Server is a non-yielding scheduler (generally…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Debugging, Demystified, Dump, Dumps, Scheduling, SQL Server, SQLOS, Threads, WinDBG, Workers

olved steries #2 – Slow Restore

August 8, 2021 Sean Gallardy 1 Comment

Issue Introduction In this olved stery the problem comes as a slow database restore. That’s what I was given, that’s…

Continue Reading →

Posted in: NotASQLServerProblem, olved stery, Performance, SQL Server Filed under: Backups, network latency, olved stery, Performance, restores, SQL Server

Possible configuration error: 1000000 IO requests allocated

May 23, 2021 Sean Gallardy 1 Comment

You’ve won! If, somehow, you’ve managed to see this error in your errorlog then congratulations, you’ve won an instance of…

Continue Reading →

Posted in: Performance, SQL Server, Storage Filed under: Asynchronous IO, Performance, SQL Server, Storage, Weird Errors

Post navigation

Page 1 of 3
1 2 3 Next →

Subscribe via RSS!

Recent Comments

  • Sean Gallardy on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Hannah Vernon on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Failure to Write to the Security Event Log – Curated SQL on Auditing To the Security Event Log – SQL Server Error 33204 and OS Error 8

Archives

  • March 2022
  • January 2022
  • December 2021
  • November 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • September 2020
  • August 2020
  • June 2020
  • May 2020
  • January 2020
  • September 2019
  • June 2019
  • May 2019
Copyright © 2019 Opinionated SQL