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
Hello Friends, This blog is to help the IT professionals who want to become a professional SQL Server DBA but don't know how and from where to start with. So, I am going to share my experiences and my learning in this blog. Will talk about what are the pre-requisite skills required to become a Professional SQL Server DBA, how much time it takes to be a good DBA and what are the additional skill sets are required to become a good DBA. Apart from that I will also post real time sql server settings on server level and database level, Configuring High Availability. Also will share the Client requirements with real time setups if possible I will provide you with screenshots.
Issue with the Node Quarantine state on the WSFC 2016 with the Availability groups (Windows 2016 and SQL 2016)
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
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