Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Dynamic management views Rss

   Items 1 to 4 of 4   

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 6,428 reads

SQL Server 2014 In-Memory OLTP Dynamic Management Views

Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.  Read more...
By Additional Articles 2014/04/16 | Source: Database Journal | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 3,498 reads

Review Your BUCKET_COUNT Statistics with DMV

Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,754 reads

Find Top 5 executed queries ordered by execution count

I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.  Read more...
Rating: |  Discuss |   Briefcase | 1,932 reads
   Items 1 to 4 of 4   
administration (1)    
dmv's (1)    
execution count (1)    
indexing (1)    
in-memory oltp (1)    
missing indexes (1)    
monitoring (1)