November 28, 2017 at 9:06 pm
Comments posted to this topic are about the item DMO Word Scramble
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
November 29, 2017 at 8:42 am
I do not know, If I am correct, DMO world Scramble, resulted difficult, instead I searched the keys:
1.sys.dm_exec_query_stats
2.sys.dm_exec_requests
3.sys.dm_exec_text_query_plan
4.sys.dm_io_virtual_file_stats
5.sys.dm_os_sys_info
6.sys.dm_os_waiting_tasks
7. sys.dm_tran_session_transactions
8. sys.dm_tran_locks
9. sys.dm_tran_active_transaction
10. sys.dm_db_file_space_usage
:crazy:
December 3, 2017 at 6:49 pm
Sorry for the delay, but here is the answer key 🙂
1. SYS.DM_EXEC_CONNECTIONS
2. SYS.DM_EXEC_REQUESTS
3. SYS.DM_EXEC_TEXT_QUERY_PLAN
4. SYS.DM_IO_VIRTUAL_FILE_STATS
5. SYS.DM_OS_SYS_INFO
6. SYS.DM_OS_WAITING_TASKS
7. SYS.DM_TRAN_CURRENT_TRANSACTION
8. SYS.DM_TRAN_LOCKS
9. SYS.DM_TRAN_SESSION_TRANSACTIONS
10. SYS.DM_DB_FILE_SPACE_USAGE
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply