gpt-3.5-turbo-0301· OpenAI
WildChat-4.8M (AI2)
诊断和解决SQL Server实例的性能瓶颈, 的 sql 全部列给我100个
- User
诊断和解决SQL Server实例的性能瓶颈, 的 sql 全部列给我100个
- Assistant
以下是100个SQL语句用于诊断和解决SQL Server实例的性能瓶颈:
- SELECT name, database_id, state_desc FROM sys.databases
- SELECT * FROM sys.dm_os_sys_info
- SELECT * FROM sys.dm_exec_sessions
- SELECT * FROM sys.dm_exec_connections
- SELECT * FROM sys.dm_exec_requests
- SELECT * FROM sys.dm_exec_query_memory_grants
- SELECT * FROM sys.dm_os_threads
- SELECT * FROM sys.dm_tran_locks
- SELECT * FROM sys.dm_db_index_operational_stats
- SELECT * FROM sys.dm_db_task_space_usage
- SELECT * FROM sys.dm_os_wait_stats
- SELECT * FROM sys.dm_os_performance_counters
- SELECT * FROM sys.dm_db_missing_index_details
- SELECT * FROM sys.dm_db_missing_index_groups
- SELECT * FROM sys.dm_db_missing_index_group_stats
- SELECT * FROM sys.dm_db_missing_index_columns
- SELECT * FROM sys.dm_db_index_usage_stats
- SELECT * FROM sys.dm_db_partition_stats
- SELECT * FROM sys.dm_db_file_space_usage
- SELECT * FROM sys.dm_os_memory_cache_entries
- SELECT * FROM sys.dm_os_memory_cache_counters
- SELECT * FROM sys.dm_os_memory_objects
- SELECT * FROM sys.dm_os_buffer_descriptors
- SELECT * FROM sys.dm_os_buffer_pool_extension_configuration
- SELECT * FROM sys.dm_os_buffer_stats
- SELECT * FROM sys.dm_os_latch_stats
- SELECT * FROM sys.dm_os_spinlock_stats
- SELECT * FROM sys.dm_io_virtual_file_stats
- SELECT * FROM sys.dm_exec_cached_plans
- SELECT * FROM sys.dm_exec_query_plan
- SELECT * FROM sys.dm_exec_query_stats
- SELECT * FROM sys.dm_exec_text_query_plan
- SELECT * FROM sys.dm_io_pending_io_requests
- SELECT * FROM sys.dm_io_cluster_shared_drives
- SELECT * FROM sys.dm_db_index_physical_stats
- SELECT * FROM sys.dm_os_schedulers
- SELECT * FROM sys.dm_db_log_space_usage
- SELECT * FROM sys.dm_server_services
- SELECT * FROM sys.dm_os_hosts
- SELECT * FROM sys.dm_os_ring_buffers
- SELECT * FROM sys.dm_hadr_cluster_members
- SELECT * FROM sys.dm_hadr_cluster_networks
- SELECT * FROM sys.dm_hadr_database_replica_states
- SELECT * FROM sys.dm_hadr_database_replica_cluster_states
- SELECT * FROM sys.dm_hadr_database_replica_states_internal
- SELECT * FROM sys.dm_hadr_database_replica_cluster_states_internal
- SELECT * FROM sys.dm_hadr_availability_group_states
- SELECT * FROM sys.dm_hadr_availability_replica_states
- SELECT * FROM sys.dm_hadr_availability_group_database_replica_states
- SELECT * FROM sys.dm_db_filestream_options
- SELECT * FROM sys.dm_db_filestream_file_io_requests
- SELECT * FROM sys.dm_os_dispatchers
- SELECT * FROM sys.dm_db_xtp_checkpoint_files
- SELECT * FROM sys.dm_db_xtp_checkpoint_stats
- SELECT * FROM sys.dm_db_xtp_hash_index_stats
- SELECT * FROM sys.dm_db_xtp_index_stats
- SELECT * FROM sys.dm_db_xtp_memory_consumers
- SELECT * FROM sys.dm_db_xtp_memory_consumers_internal
- SELECT * FROM sys.dm_db_xtp_merge_requests
- SELECT * FROM sys.dm_db_xtp_migration_status
- SELECT * FROM sys.dm_db_xtp_object_stats
- SELECT * FROM sys.dm_db_xtp_checkpoint_stats_internal
- SELECT * FROM sys.dm_db_xtp_gc_cycle_stats
- SELECT * FROM sys.dm_db_xtp_transactions
- SELECT * FROM sys.dm_db_xtp_transaction_stats
- SELECT * FROM sys.dm_db_xtp_table_memory_stats
- SELECT * FROM sys.dm_db_xtp_tombstone_stats
- SELECT * FROM sys.dm_db_xtp_gc_stats
- SELECT * FROM sys.dm_db_xtp_wait_stats
- SELECT * FROM sys.dm_db_xtp_checkpoint_queue
- SELECT * FROM sys.dm_db_xtp_version_garbage_collection
- SELECT * FROM sys.dm_db_xtp_version_store
- SELECT * FROM sys.dm_db_xtp_lock_stats
- SELECT * FROM sys.dm_db_xtp_checkpoint_stats_external
- SELECT * FROM sys.dm_xe_objects
- SELECT * FROM sys.dm_xe_sessions
- SELECT * FROM sys.dm_xe_session_targets
- SELECT * FROM sys.dm_xe_session_event_actions
- SELECT * FROM sys.dm_xe_session_events
- SELECT * FROM sys.dm_xe_sessions_internal
- SELECT * FROM sys.dm_exec_background_job_queue
- SELECT * FROM sys.dm_qn_subscriptions
- SELECT * FROM sys.dm_service_queues
- SELECT * FROM sys.dm_broker_databases
- SELECT * FROM sys.dm_broker_connections
- SELECT * FROM sys.dm_broker_queue_monitors
- SELECT * FROM sys.dm_broker_queues
- SELECT * FROM sys.dm_clr_tasks
- SELECT * FROM sys.dm_clr_loaded_assemblies
- SELECT * FROM sys.dm_clr_appdomains
- SELECT * FROM sys.dm_clr_appdomain_assemblies
- SELECT * FROM sys.dm_db_incremental_stats_properties
- SELECT * FROM sys.dm_db_incremental_stats_stats
- SELECT * FROM sys.dm_db_incremental_stats_histogram
- SELECT * FROM sys.dm_db_incremental_stats_data_set
- SELECT * FROM sys.dm_db_incremental_stats_internal
- SELECT * FROM sys.dm_db_incremental_stats_jobs
- SELECT * FROM sys.db_file_encryption
- SELECT * FROM sys.dm_exec_query_profiles
- SELECT * FROM sys.dm_tran_active_transactions