sys.dm_exec_sessions – Day 30 – One DMV a Day
Hello Geeks and welcome to the Day 30 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read MoreTag: sys.dm_exec_connections
sys.dm_exec_connections – Day 29 – One DMV a Day
Hello Geeks and welcome to the Day 29 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read MoreSQL Server: Which protocol is being used for client-server connectivity in SQL Server?
Hi Friends, We all know that there are 4 protocols that can be used to connect a SQL Server instance from a client; namely Share Memory, TCP/IP, Named Pipes & VIA. …
Read MoreSQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose.
Many a times a DBA wishes for the below information, during performance troubleshooting, Can I get to know what was being executed 30 minutes back. Can I get to know which …
Read More