Archives: March 2013
The 10th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 10 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.
Those who are facing severe issues with their environment, they can plan to test CU10 in test environment… Read more
The 3rdcumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.
Those who are facing severe issues with their environment, they can plan to test CU3 in test environment &… Read more
· What will change :
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view that shows information about all active user connections and internal tasks. This information includes client version, client program name, client login time, login user, current…
The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx
Returns information about the connections established to this instance of SQL Server and the details of each connection.
sys.dm_exec_connections is the most common DMV used to get connection details. We will get details info… Read more