MSSQLFUN

The 6th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...

2013-04-19

1,679 reads

Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !

by Rohit Garg

MSSQLFUN

The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the...

2013-04-17

961 reads

DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants

by Rohit Garg

MSSQLFUN

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...

2013-04-15

1,051 reads

DMV-6 : How well my store procedure doing ?……..sys.dm_exec_procedure_stats

by Rohit Garg

MSSQLFUN

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...

2013-04-10

1,900 reads

DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans

by Rohit Garg

MSSQLFUN

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...

2013-04-08

821 reads

DMV-4 : Find top most expensive cached queries ?……..sys.dm_exec_query_stats

by Rohit Garg

MSSQLFUN

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...

2013-04-03

4,565 reads

DMV-3 : What is currently going on ?……..sys.dm_exec_requests

by Rohit Garg

MSSQLFUN

sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx
Returns information about each request that is executing within SQL...

2013-04-01

1,186 reads