SQL Server Education (by the geeks, for the geeks)
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 …
sys.dm_exec_sessions – Day 30 – One DMV a Day Read MoreHello 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 …
sys.dm_exec_connections – Day 29 – One DMV a Day Read MoreHi 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. …
SQL Server: Which protocol is being used for client-server connectivity in SQL Server? Read MoreMany 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 …
SQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose. Read More