Home » Posts tagged 'SQL 2012' (Page 6)
Tag Archives: SQL 2012
Cumulative Update – 7 for SQL Server 2012 RTM Is Now Available !
The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2012 RTM. Those who are facing severe issues with their environment, they can plan to test CU7 in test environment & then move to Production … 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
DMV-6 : How well my store procedure doing ?……..sys.dm_exec_procedure_stats
sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.aspx Returns aggregate performance statistics for cached stored procedures. The view contains one row per stored procedure, and the lifetime of the row is as long as the stored procedure remains cached. When a stored procedure is removed from the cache, the corresponding row … Continue reading
DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans
sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx Returns a row for each query plan that is cached by SQL Server for faster query execution. You can use this dynamic management view to find cached query plans, cached query text, the amount of memory taken by cached plans, and the reuse … Continue reading
DMV-4 : Find top most expensive cached queries ?……..sys.dm_exec_query_stats
sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx Returns aggregate performance statistics for cached query plans. The view contains one row per query statement within the cached plan, and the lifetime of the rows are tied to the plan itself. When a plan is removed from the cache, the corresponding rows … Continue reading