Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

诊断和解决SQL Server实例的性能瓶颈, 的 sql 全部列给我100个

  1. User

    诊断和解决SQL Server实例的性能瓶颈, 的 sql 全部列给我100个

  2. Assistant

    以下是100个SQL语句用于诊断和解决SQL Server实例的性能瓶颈:

    1. SELECT name, database_id, state_desc FROM sys.databases
    2. SELECT * FROM sys.dm_os_sys_info
    3. SELECT * FROM sys.dm_exec_sessions
    4. SELECT * FROM sys.dm_exec_connections
    5. SELECT * FROM sys.dm_exec_requests
    6. SELECT * FROM sys.dm_exec_query_memory_grants
    7. SELECT * FROM sys.dm_os_threads
    8. SELECT * FROM sys.dm_tran_locks
    9. SELECT * FROM sys.dm_db_index_operational_stats
    10. SELECT * FROM sys.dm_db_task_space_usage
    11. SELECT * FROM sys.dm_os_wait_stats
    12. SELECT * FROM sys.dm_os_performance_counters
    13. SELECT * FROM sys.dm_db_missing_index_details
    14. SELECT * FROM sys.dm_db_missing_index_groups
    15. SELECT * FROM sys.dm_db_missing_index_group_stats
    16. SELECT * FROM sys.dm_db_missing_index_columns
    17. SELECT * FROM sys.dm_db_index_usage_stats
    18. SELECT * FROM sys.dm_db_partition_stats
    19. SELECT * FROM sys.dm_db_file_space_usage
    20. SELECT * FROM sys.dm_os_memory_cache_entries
    21. SELECT * FROM sys.dm_os_memory_cache_counters
    22. SELECT * FROM sys.dm_os_memory_objects
    23. SELECT * FROM sys.dm_os_buffer_descriptors
    24. SELECT * FROM sys.dm_os_buffer_pool_extension_configuration
    25. SELECT * FROM sys.dm_os_buffer_stats
    26. SELECT * FROM sys.dm_os_latch_stats
    27. SELECT * FROM sys.dm_os_spinlock_stats
    28. SELECT * FROM sys.dm_io_virtual_file_stats
    29. SELECT * FROM sys.dm_exec_cached_plans
    30. SELECT * FROM sys.dm_exec_query_plan
    31. SELECT * FROM sys.dm_exec_query_stats
    32. SELECT * FROM sys.dm_exec_text_query_plan
    33. SELECT * FROM sys.dm_io_pending_io_requests
    34. SELECT * FROM sys.dm_io_cluster_shared_drives
    35. SELECT * FROM sys.dm_db_index_physical_stats
    36. SELECT * FROM sys.dm_os_schedulers
    37. SELECT * FROM sys.dm_db_log_space_usage
    38. SELECT * FROM sys.dm_server_services
    39. SELECT * FROM sys.dm_os_hosts
    40. SELECT * FROM sys.dm_os_ring_buffers
    41. SELECT * FROM sys.dm_hadr_cluster_members
    42. SELECT * FROM sys.dm_hadr_cluster_networks
    43. SELECT * FROM sys.dm_hadr_database_replica_states
    44. SELECT * FROM sys.dm_hadr_database_replica_cluster_states
    45. SELECT * FROM sys.dm_hadr_database_replica_states_internal
    46. SELECT * FROM sys.dm_hadr_database_replica_cluster_states_internal
    47. SELECT * FROM sys.dm_hadr_availability_group_states
    48. SELECT * FROM sys.dm_hadr_availability_replica_states
    49. SELECT * FROM sys.dm_hadr_availability_group_database_replica_states
    50. SELECT * FROM sys.dm_db_filestream_options
    51. SELECT * FROM sys.dm_db_filestream_file_io_requests
    52. SELECT * FROM sys.dm_os_dispatchers
    53. SELECT * FROM sys.dm_db_xtp_checkpoint_files
    54. SELECT * FROM sys.dm_db_xtp_checkpoint_stats
    55. SELECT * FROM sys.dm_db_xtp_hash_index_stats
    56. SELECT * FROM sys.dm_db_xtp_index_stats
    57. SELECT * FROM sys.dm_db_xtp_memory_consumers
    58. SELECT * FROM sys.dm_db_xtp_memory_consumers_internal
    59. SELECT * FROM sys.dm_db_xtp_merge_requests
    60. SELECT * FROM sys.dm_db_xtp_migration_status
    61. SELECT * FROM sys.dm_db_xtp_object_stats
    62. SELECT * FROM sys.dm_db_xtp_checkpoint_stats_internal
    63. SELECT * FROM sys.dm_db_xtp_gc_cycle_stats
    64. SELECT * FROM sys.dm_db_xtp_transactions
    65. SELECT * FROM sys.dm_db_xtp_transaction_stats
    66. SELECT * FROM sys.dm_db_xtp_table_memory_stats
    67. SELECT * FROM sys.dm_db_xtp_tombstone_stats
    68. SELECT * FROM sys.dm_db_xtp_gc_stats
    69. SELECT * FROM sys.dm_db_xtp_wait_stats
    70. SELECT * FROM sys.dm_db_xtp_checkpoint_queue
    71. SELECT * FROM sys.dm_db_xtp_version_garbage_collection
    72. SELECT * FROM sys.dm_db_xtp_version_store
    73. SELECT * FROM sys.dm_db_xtp_lock_stats
    74. SELECT * FROM sys.dm_db_xtp_checkpoint_stats_external
    75. SELECT * FROM sys.dm_xe_objects
    76. SELECT * FROM sys.dm_xe_sessions
    77. SELECT * FROM sys.dm_xe_session_targets
    78. SELECT * FROM sys.dm_xe_session_event_actions
    79. SELECT * FROM sys.dm_xe_session_events
    80. SELECT * FROM sys.dm_xe_sessions_internal
    81. SELECT * FROM sys.dm_exec_background_job_queue
    82. SELECT * FROM sys.dm_qn_subscriptions
    83. SELECT * FROM sys.dm_service_queues
    84. SELECT * FROM sys.dm_broker_databases
    85. SELECT * FROM sys.dm_broker_connections
    86. SELECT * FROM sys.dm_broker_queue_monitors
    87. SELECT * FROM sys.dm_broker_queues
    88. SELECT * FROM sys.dm_clr_tasks
    89. SELECT * FROM sys.dm_clr_loaded_assemblies
    90. SELECT * FROM sys.dm_clr_appdomains
    91. SELECT * FROM sys.dm_clr_appdomain_assemblies
    92. SELECT * FROM sys.dm_db_incremental_stats_properties
    93. SELECT * FROM sys.dm_db_incremental_stats_stats
    94. SELECT * FROM sys.dm_db_incremental_stats_histogram
    95. SELECT * FROM sys.dm_db_incremental_stats_data_set
    96. SELECT * FROM sys.dm_db_incremental_stats_internal
    97. SELECT * FROM sys.dm_db_incremental_stats_jobs
    98. SELECT * FROM sys.db_file_encryption
    99. SELECT * FROM sys.dm_exec_query_profiles
    100. SELECT * FROM sys.dm_tran_active_transactions