Home » Posts tagged 'SQL 2008 R2' (Page 5)
Tag Archives: SQL 2008 R2
DMV-9 : Digging out details of CLR Tasks……..sys.dm_clr_tasks
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx Returns a row for all common language runtime (CLR) tasks that are currently running. A Transact-SQL batch that contains a reference to a CLR routine creates a separate task for execution of all the managed code in that batch. Multiple statements in the batch … Continue reading
DMV-8 : Check Space consumed by Database……..sys.dm_db_file_space_usage
sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx Returns space usage information for each file in the database. It’s most commonly used DMV to check total used & available free space in database. Before SQL Server 2012, it applicable only to the tempdb database Key Columns :- database_id – identifies the database … Continue reading
Cumulative Update – 6 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 6th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2. Those who are facing severe issues with their environment, they can plan … Continue reading
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP1. Those who are facing severe issues with their environment, they can plan … Continue reading
DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx Returns information about the queries that have acquired a memory grant or that still require a memory grant to execute. Queries that do not have to wait on a memory grant will not appear in this view. This DMV helps in finding queries … Continue reading