Connectivity Issues

Active Connections to SQL Server Database 2008, 2005 by Application or User

To Check Active Connections to SQL Server Database grouped by User Below query is very helpful in finding the Total…

12 years ago

Bringing Database back from Single User to Multi User mode with active connections

Bringing Database back from Single User mode to Multi User mode for Database with active connection: Some times you will…

12 years ago

ASYNC_NETWORK_IO Waits SQL Server 2005 2008 2012 2014 2016

ASYNC_NETWORK_IO Waits SQL Server 2005 2008 2012 2014 2016 ASYNC_NETWORK_IO Wait type in SQL 2005 2008 2012 2014 or 2016…

12 years ago

SQL Server TCP/IP Static and Dynamic Ports

SQL Server TCP/IP Static and Dynamic Ports must be configured/known by a DBA. If Windows Firewall is active in a…

12 years ago

This website uses cookies.