Microsoft recommends the following CHECKLIST POINTS: Process (sqlservr): % Privileged Time % Processor Time % User Time SELECT s.session_id, r.status, r.blocking_session_id ‘Blk by’, r.wait_type, wait_resource,… Read More »SQL High CPU Utilization Troubleshooting
Intro: DBA/Application teams frequently experience SQL Connectivity issues while connecting from apps during routine SQL Instance activities. In this essay, I’ll go over a couple… Read More »How to Fix SQL Connectivity Issues
Intro: In our environment, where AlwaysON Availability Groups were set up on Windows Server 2016 and SQL Server 2016, we came across an interesting problem… Read More »Issue with the Node Quarantine state on the WSFC 2016 with the Availability groups (Windows 2016 and SQL 2016)
The most recent versions of Windows Server are pre-loaded with.NET Framework 4.6, even though.NET Framework 3.5 is also available and might not be installed on server.The… Read More »Installing the .NET 3.5 Framework without a DVD on Windows Servers 2012, 2016, and 2019
Error message : The transaction log for database ‘Database’ is full due to ‘AVAILABILITY_REPLICA’ Error: 9002, Severity: 17, State: 9. Cause: The primary replica transaction… Read More »Transaction log File Full Issue for Availability databases due to AVAILABILITY_REPLICA
Tempdb Data Files are Full: I’m using a script to create a temporary table to fill up my Tempdb while also conducting some tests locally… Read More »Troubleshooting Tempdb Full Issue
Intro: When I encountered a situation where the monitoring tool was consistently reporting “SSPI Handshake Issues” the team contacted me for assistance in fixing these… Read More »Troubleshooting SSPI handshake failed Error
Intro: By creating new Windows Server 2016 operating systems and configuring Alwayson( 2 replicas) for SQL 2016 servers with multiple Availability Groups, we just completed… Read More »Lease Timeout or Expiration Error Issue in AlwaysON