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

Content with tag DMV's Rss

   Items 1 to 3 of 3   
 

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,831 reads

Database encryption

By Steve Jones 2011/08/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,151 reads

Performance Counters

By Robert Davis 2010/09/15 | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 3,090 reads
   Items 1 to 3 of 3   
 
Tags
administration (1)    
dynamic management views (1)    
encryption (1)    
execution count (1)    
performance tuning (1)    
security (1)