Rohit Garg

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

All authors

Cumulative Update – 6 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

by Rohit Garg

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