Category: SQL Server

How to Recover a Database from Suspect or Recovery Pending State in SQL Server?

So one or more of your databases went into RECOVERY PENDING state or in SUSPECT mode and you are confused about what to do now in order to fix the issue immediately. Do not panic!! Almost every DBA has encountered this scenario quite a few times in their professional career where one or more databases … Continue reading How to Recover a Database from Suspect or Recovery Pending State in SQL Server?

How to troubleshoot high CPU utilization issue in SQL Server?

So you have received a high CPU utilization alert from your monitoring system and wondering what to do next. If yes, then this blog post may be helpful for you. You can follow the below steps to isolate the problem and mitigate it. Open task manager and identify if SQL Server process is causing the … Continue reading How to troubleshoot high CPU utilization issue in SQL Server?