| What action plan you create when SQL Server is not responding?
Once SQL Server is not responding we will create below action to get the reason:-
(1)In First we will think about the connection. To do this we will connect using DAC via CMD or by SSMS.
(2)Once we decided to connect via CMD. We will run below query to enter.
(3)SQLCMD -A –U adminlogin –P password -SMyServer –dmaster
(4)Once we connect with master after above command.
(5)We will now run the diagnostic queries to find the problem.
(6)Now will get the error reason correct the issue and after that restart the server. | | |