When SQL Server Audits Fail – Quick Summary SQL Server Audits – they’re running in the background, but what happens when something goes wrong? There is an alert that we have encountered that, if you follow the information in the error, typically does not lead you to the solution. What do you do then? Every minute the audit is … Read more
Quick Summary When snapshot replication is configured with schema replication enabled, DDL changes are sometimes marked for replication but never marked for truncation, creating a false “undistributed command” that prevents log truncation and causes uncontrolled growth. The solution was to add a log reader agent using sp_addlogreader_agent on the publisher to mark all replicated commands for truncation. Context The SQL … Read more
As you may have seen in some of our recent blog posts, here at Straight Path Solutions we’ve been working on a few free scripts to help you with maintaining your SQL Server instances. These include: …BUT THAT’S NOT WHAT THIS POST IS ABOUT! Instead, we want to draw attention to the scripts created by … Read more
Case of the Week: Quick Summary Two of the four clients’ SQL Server Failover Cluster Instances (FCIs) did not fail over to the secondary node. Context This is a SQL Server 2019 with four load-balanced FCI’s running on two physical servers with 64 CPUs, 4TB of memory, and a Pure Storage array on the backend. … Read more
Quick Summary We received an on-call call from a client who was attempting to run a failover from on a SQL Server Failover Cluster Instance to another but the failover wouldn’t move to the secondary. They tried things, were using the things we had taught them about failing over for their patching or for other … Read more
This is a post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: Quick Summary A client reported that their SQL Server service was “randomly shutting down”. They would restart SQL … Read more
Sometimes people install Office onto a SQL Server to get the drivers for the ability to import data from Excel into SQL Server Tables. This should never be done on a production, or any, server because it can cause many other problems for SQL, one of which is the purpose of this blog. For example, … Read more