I received the below error while I was doing failover testing on a newly built SQL Server 2012 cluster.
The SQL Server (MSSQLSERVER) service terminated with
service-specific error An attempt was made to access a socket in a way forbidden
by its access permissions..
After few troubleshooting I found this was due to the port xxxxx was taken
control by another process. Apparently the process was Cluster Manager. :) So I
closed the Cluster Manager and re-opened and then failover was successful. This
seems to be very rare occurrence but it is possible.
Refer the below link for more details;
Server TCP provider failed to listen on...
Friday, February 5, 2016
I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...
I wanted build an expression to make a folder name dynamically. (Basically expressions are anyway dynamic in nature) So I simply used the ...
When querying sys.dm_exec_requests dmv, you can see the waiting requests and the resource those requests are waiting for. Sample of such val...
The SQLOS Prior to SQL Server 2005, SQL Server runs as a user mode process like any other Windows application and it depends on...