Issue: All the sql job stuck in the state “Performing completion action” An AlwaysOn failure would sometimes cause this issue. A network glitch between SQL Server and Exchange Server can also cause this issue. Fix: Restart the SQL Agent service.
Microsoft regularly releases server or software updates to fix security problems, bugs in the software, and performance issues, or to add new features. These patches or updates are available on the Microsoft website. Microsoft regularly releases SQL server or software updates to fix security problems, bugs in the software, and performance issues, or to add... » read more
When running a validation test on a Windows Failover Cluster, drives may disappear from the cluster and file explorer if the cluster is hosting an Availability Group with iSCSI-backed disks. When you choose the default options in Validation – any storage that could be possibly shared storage is taken offline and brought into the cluster’s available... » read more
Look into the following logs… Critical Events from Failover Cluster Manager Validate Cluster Report Windows Event Viewer Quick Action: Update SQL Server to Latest Patch. Reboot server on all nodes. Critical Events from Failover Cluster Manager Cluster -> Nodes -> Show Critical Events Validate Cluster Report Cluster -> Validate Cluster -> Run all test Windows... » read more
Issue: Unable to get AlwaysOn database back online. The local availability replica is not in a state that could process the command. Verify that the availability group is online and that the local availability replica is the primary replica, then retry the command. (Microsoft SQL Server, Error: 41190) Fix: Drop AlwaysOn and re-create it. Steps:... » read more
This is one of the common errors I have seen while working with customers who are using SQL Server AlwaysOn availability groups. Once this error comes, the resource in the cluster goes to failed state and in SQL Server Management Studio, we should be an availability group in resolving state. Resolving state essentially means that... » read more
Error: Msg 13545, Level 16, State 1, Line 14Truncate failed on table ‘tbXXXXX’ because it is not a supported operation on system-versioned tables. Resolution: Links: https://rajeevdotnet.blogspot.com/2019/05/truncate-system-version-table-temporal.html
It is possible to setup SQL Server AlwaysOn without Windows Failover Clustering. The feature “Windows Failover Cluster” does not need to be installed on the server. There will still be Primary and Secondary AlwaysOn servers. This setup is useful when you do not need failover, but simply to setup for a read-only secondary server. Note:... » read more
https://www.solarwinds.com/sql-sentry SolarWinds SQL Sentry License by server instance. Use client application instead of web application.
https://www.brentozar.com/blitz/slow-storage-reads-writes/ SQL Server feels the need – the need for speed. Storage speed, to be more specific. One of the most common bottlenecks is underperforming storage subsystems. SQL Server tracks read and write speeds for each database file – both data and log files. This part of our SQL Server sp_Blitz script checks sys.dm_io_virtual_file_stats looking for average... » read more