Category: Troubleshooting
The sectoin contains the SQL Server troubleshooting articles
-
dutyDBA Case Files #2 – Who dropped the tables and deleted/recreated stored procedures on the production database?
In this edition of dutyDBA case files, I show you how to investigate an unauthorised production database change to figure out who made the changes. This walks you through the process of recovering from the application outage, and identifying the root cause.
-
Script for a quick SQL Server memory overview – useful for creating a snapshot of current memory configuration
This post provides a quick memory overview of your SQL Server. The output includes the total amount of RAM on the SQL Server box, amount of unused RAM at host level, SQL Server memory allocations, current buffer pool and procedure cache sizes.
-
dutyDBA Case Files #1 – Unable to change the database owner on secondary replicas to sa
This case notes is from a real world incident, where a DBA account could not be dropped because it owns the databases on an Always On secondary replica. I investigate how it happened and show you how to resolve it, and prevent it from happening again.
-
How to identify and fix all logins with invalid default databases? (Error 4064)
This article shows you how to identify all those logins on your SQL Server instances which have an invalid default dataabase that no longer exists. This article also shows you how to manage this situatoin, and provides you a stored procedure that resolves the issue.
-
How to use sys.dm_io_virtual_file_stats to check the disk read and write performance of your SQL Server?
When it comes to checking how well the disks are performing on your SQL Server, sys.dm_io_virtual_file_stats is your best friend. This Dynamic Management View (DMV)
-
What is sp_WhoIsActive? How to deploy and configure it, as well as maintain the collected data?
If you’ve been an SQL Server DBA for a while, chances are you are already familiar with sp_WhoIsActive, a comprehensive, free, lightweight stored procedure developed
Latest Articles
