SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

DMO Word Scramble

By Kenneth Fisher,

Unscramble the DMOs and match them with the clues below.

  • sys.dm_ionk_isgttssaa_w
  • sys.dm_uqe_ten_ceplxtyr_axe
  • sys.dm_nnaoiar_strst_asessncinto
  • sys.dm_tn_ecisooenccexn
  • sys.dm_rsa_urinaecanntntttr_cor
  • sys.dm_akstc_ornl
  • sys.dm_sys_oo_fnsi
  • sys.dm_fitoai_ta_irll_setvsu
  • sys.dm_rxee_seuqtsce
  • sys.dm__efdacb_ass_iglueep

  1. most_recent_sql_handle
  2. What's doing something?
  3. Get the query plan for just one query within a batch.
  4. Reads per database file
  5. Number of CPUs
  6. What's waiting?
  7. My transaction
  8. Held locks
  9. Starting point to find out who has a given transaction open
  10. Size of data files on current DB

I'll post the answers into the comments within a day or two of the puzzle posting.

 
Total article views: 45 | Views in the last 30 days: 2
 
Related Articles
FORUM

sys.dm_db_index_physical_stats

sys.dm_db_index_physical_stats

BLOG

sys.dm_os_wait_stats

This is a short note explaining he sys.dm_os_wait_stats DMV. This DMV returns the following column...

FORUM

sys.dm_db_index_physical_stats not accurate?

sys.dm_db_index_physical_stats vs GUI to determine fragmentation

FORUM

Tempdb Contention - sys.dm_os_waiting_tasks

Tempdb Contention Analysis using sys.dm_os_waiting_tasks

BLOG

Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

I’ve been working on a way to test performance usage on a server by database. I started out using sy...

Tags
editorial    
puzzle    
scramble    
 
Contribute