Understand Hangs
There are several types of Hangs in SQL Server.
1. First we need to identify if any particular SPID is getting stuck which is followed by KILL SPID.
2. If your SQL server itself Hanging...
When SQL server hangs and become unresponsive we can clear the process ID related to sqlservr.exe by 'End Task' from Task Manager and restart SQL Services.
3. There are chances that due to disk array SQL Server intermittently hangs, so we have to get that replaced.
4. Due to memory allocation SQL server may respond slow, so Target Memory spike shouldn't be consistent, If yes then we need to either allocate more memory or switch to new Server.
5. Firewall - It's sometime observed that due to firewall settings all of sudden changed by itself, so application can stop responding. We need to ensure its as per requirement.
6. Network - PING for RTO can be checked anytime.
Additionally,
Note:- Sky is a Limit that's fine but SQL Server has defined that as well.
Best Regards
T. Amit Vaid S.
No comments:
Post a Comment