Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.

Issue – Today I faced very weird issue; on multi instance SQL Server machine, couple of SQL Services was not starting after Server reboot ( In my case it was SQL 2014 and SQL 2016 ) and every time I was trying to restart my SQL Services, I was getting below error message –  … Read More Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.

Create Blocking Alert – SQL 2005 , SQL 2008 R2 and SQL 2012

We often need to create blocking alert in our Production server to capture existing blocking on server and keep record for future analysis. Here are steps which help us to create blocking alerts- Either you can receive blocking details through e-mail or you can log event id in application log and configure your monitoring tool to… Read More Create Blocking Alert – SQL 2005 , SQL 2008 R2 and SQL 2012