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 3 of 3   

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 | 2,416 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,598 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,684 reads
   Items 1 to 3 of 3   
dmv's (1)    
execution count (1)    
in-memory oltp (1)