Как пользоваться профайлером

[deas]

Здравствуйте.

Запустил профайлер и не могу разобраться что надо настроить и почему на втором шаге окно пустое.
Что у меня не так?

[Alexander]

Не могли бы Вы сообщить нам версию и редакцию SQL сервера, редакцию dbForge Studio for SQL Server, а также прислать результат следующего запроса:

Код: Выделить всё

SELECT
  p.guid,
  c.event,
  k.keyword,
  c.channel,
  c.description
FROM (SELECT
  event_package = o.package_guid,
  o.description,
  event = c.object_name,
  channel = v.map_value
FROM sys.dm_xe_objects o
LEFT JOIN sys.dm_xe_object_columns c
  ON o.name = c.object_name
INNER JOIN sys.dm_xe_map_values v
  ON c.type_name = v.name
  AND c.type_package_guid = v.object_package_guid
  AND c.column_value = CAST(v.map_key AS NVARCHAR)
WHERE object_type = 'event'
AND c.name = 'channel'
AND (o.capabilities & 1 = 0
OR o.capabilities IS NULL)) c
LEFT JOIN (SELECT
  event_package = c.object_package_guid,
  event = c.object_name,
  keyword = v.map_value
FROM sys.dm_xe_object_columns c
INNER JOIN sys.dm_xe_map_values v
  ON c.type_name = v.name
  AND c.column_value = v.map_key
  AND c.type_package_guid = v.object_package_guid
INNER JOIN sys.dm_xe_objects o
  ON o.name = c.object_name
  AND o.package_guid = c.object_package_guid
WHERE object_type = 'event'
AND c.name = 'keyword') k
  ON k.event_package = c.event_package
  AND k.event = c.event
INNER JOIN sys.dm_xe_packages p
  ON p.guid = c.event_package

[deas]

dbForge 4.5.60
Сервер 10.50.4000

У нас на сервере настроена чувствительная к регистру кодировка, поэтому ваш запрос срабатывает только при таком изменении:

Код: Выделить всё

AND lower(c.name) = 'channel'

Я думаю в этом и проблема.

[Alexander]

Не могли бы Вы также сообщить, существует ли у Вас директория TraceTemplates в папке C:\Users\%UserName%\Documents\dbForge Studio for SQL Server\ ?

[deas]

Я не нашел и самой папки C:\Users\%UserName%\Documents\dbForge Studio for SQL Server\

[Alexander]

Пожалуйста, попробуйте перейти в 'Пуск -> Выполнить' и наберите:

%USERPROFILE%\Documents

Если директория dbForge Studio for SQL Server отсутствует и там, пожалуйста, попробуйте переустановить dbForge Studio for SQL Server.

[deas]

Папки нет и она не появляется при переустановке.

Такая папка есть у пользователя Администратор и в ней есть TraceTemplates.

Устанавливаю программу под доменным пользователем, но он не является администратором компьютера, и поэтому по запросу системы ввожу логин и пароль локального администратора. Такая политика по установке ПО.
Система: Win 8.1 Профессиональная 64

[Alexander]

Спасибо за ответ.

Мы воспроизвели данную проблему и исправим её в одной из следующих сборок.

[Geny]

Здравствуйте.

Решил не делать новую ветку..., у меня при запуске профайлер всегда вылитает по таймауту, хотя все остальное работает отлично.

dbForge 4.5.60
Сервер 10.50.4000


На всякий случай результат запроса:

Код: Выделить всё

"guid";"event";"keyword";"channel";"description"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"allocation_ring_buffer_recorded";"memory";"Debug";"Allocation ring buffer recorded"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"app_domain_ring_buffer_recorded";"clr";"Debug";"AppDomain ring buffer recorded"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_activation_stored_procedure_invoked";"broker";"Analytic";"Broker activation stored procedure invoked"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_activation_task_aborted";"broker";"Admin";"Broker activation task aborted"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_activation_task_limit_reached";"broker";"Admin";"Broker activation task limit reached"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_activation_task_started";"broker";"Analytic";"Broker activation task started"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_dialog_state_change";"broker";"Analytic";"The state of a Service Broker dialog has changed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_dialog_transmission_queue_dequeue";"broker";"Analytic";"A message was dequeued from a Service Broker transmission queue"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_dialog_transmission_queue_enqueue";"broker";"Analytic";"A message was enqueued into a Service Broker transmission queue"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_task_idempotent_invoke_begin";"broker";"Debug";"Broker task idempotent invoke begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_task_idempotent_invoke_end";"broker";"Debug";"Broker task idempotent invoke end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_task_idempotent_submit";"broker";"Debug";"Broker task idempotent submit"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_acksm_action_fire";"broker";"Debug";"Broker transmission outgoing ack state machine action fire"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_acksm_event_begin";"broker";"Debug";"Broker transmission outgoing ack state machine event begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_acksm_event_end";"broker";"Debug";"Broker transmission outgoing ack state machine event end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_deliverysm_action_fire";"broker";"Debug";"Broker transmission delivery state machine action fire"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_deliverysm_event_begin";"broker";"Debug";"Broker transmission delivery state machine event begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_deliverysm_event_end";"broker";"Debug";"Broker transmission delivery state machine event end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_lazyflusher_processing_begin";"broker";"Debug";"Broker transmission lazyflusher processing begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_lazyflusher_processing_end";"broker";"Debug";"Broker transmission lazyflusher processing end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_lazyflusher_remove";"broker";"Debug";"Broker transmission lazyflusher remove"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_lazyflusher_submit";"broker";"Debug";"Broker transmission lazyflusher submit"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_delete_begin";"broker";"Debug";"Broker transmission object worktable save end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_delete_end";"broker";"Debug";"Broker transmission object worktable save end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_get";"broker";"Debug";"Broker transmission object load"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_worktable_load_begin";"broker";"Debug";"Broker transmission object worktable load begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_worktable_load_end";"broker";"Debug";"Broker transmission object worktable load end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_worktable_save_begin";"broker";"Debug";"Broker transmission object worktable save begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_object_worktable_save_end";"broker";"Debug";"Broker transmission object worktable save end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_timer_armed";"broker";"Debug";"Broker transmission timer armed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_timer_fire";"broker";"Debug";"Broker transmission timer fire"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_timer_reset";"broker";"Debug";"Broker transmission timer reset"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmission_timer_set";"broker";"Debug";"Broker transmission timer set"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_connect";"broker";"Debug";"Broker transmitter destination connect"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_event_fire";"broker";"Debug";"Broker transmitter destination event fire"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_process_begin";"broker";"Debug";"Broker transmitter destination process begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_process_end";"broker";"Debug";"Broker transmitter destination process end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_process_sender_process";"broker";"Debug";"Broker transmitter destination process sender process"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_reference";"broker";"Debug";"Broker transmitter destination reference"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_subscribe";"broker";"Debug";"Broker transmitter destination subscribe"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_destination_unsubscribe";"broker";"Debug";"Broker transmitter destination unsubscribe"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_dialog_reclassify";"broker";"Debug";"Broker transmitter dialog reclassify"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_dialog_register";"broker";"Debug";"Broker transmitter dialog register"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_dialog_unregister";"broker";"Debug";"Broker transmitter dialog unregister"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_reclassification_phase_begin";"broker";"Debug";"Broker transmitter reclassification phase begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_reclassification_phase_end";"broker";"Debug";"Broker transmitter reclassification phase end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_service_create";"broker";"Debug";"Broker transmitter service created"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_service_match";"broker";"Debug";"Broker transmitter service match"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_service_reclassify";"broker";"Debug";"Broker transmitter service reclassify"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_service_send";"broker";"Debug";"Broker transmitter service send"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transmitter_transport_stream_update";"broker";"Debug";"Broker transmitter transport stream update"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_action_fire";"broker";"Debug";"Broker transport connection event action"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_close";"broker";"Debug";"Broker transport connection close"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_delimit_message";"broker";"Debug";"Broker transport connection delimit message"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_dns_lookup";"broker";"Debug";"Broker transport connection DNS lookup"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_event_begin";"broker";"Debug";"Broker transport connection event begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_event_end";"broker";"Debug";"Broker transport connection event begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_incoming_connect_attempt";"broker";"Debug";"Broker transport connection incoming connect attempt"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_message_add";"broker";"Debug";"Broker transport connection message add"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_message_delete";"broker";"Debug";"Broker transport connection message delete"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_outgoing_connect_attempt";"broker";"Debug";"Broker transport connection outgoing connect attempt"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_process_receive_control_block";"broker";"Debug";"Broker transport connection process receive control block"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_read_complete";"broker";"Debug";"Broker transport connection read complete"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_receive_io_complete";"broker";"Debug";"Broker transport connection receive I/O complete"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_send_io_complete";"broker";"Debug";"Broker transport connection send I/O complete"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_winsock_connect_attempt";"broker";"Debug";"Broker transport connection winsock connect attempt"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_winsock_connect_fail";"broker";"Debug";"Broker transport connection winsock connect fail"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_winsock_connect_success";"broker";"Debug";"Broker transport connection winsock connect success"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_winsock_read";"broker";"Debug";"Broker transport connection winsock read"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_connection_write_complete";"broker";"Debug";"Broker transport connection write complete"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_flow_control";"broker";"Debug";"Broker transmitter dialog reclassify"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_global_message_add";"broker";"Debug";"Broker transport global message add"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_global_message_delete";"broker";"Debug";"Broker transport global message delete"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_process_boxcar";"broker";"Debug";"Broker transport process boxcar"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"broker_transport_send";"broker";"Debug";"Broker transport send"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_manager_database_pages";"server";"Analytic";"Buffer manager database pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_manager_free_pages";"server";"Analytic";"Buffer manager free pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_manager_page_life_expectancy";"server";"Analytic";"Buffer manager page life expectancy in milliseconds"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_manager_stolen_pages";"server";"Analytic";"Buffer manager stolen pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_manager_target_pages";"server";"Analytic";"Buffer manager target pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_manager_total_pages";"server";"Analytic";"Buffer manager total pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_node_database_pages";"server";"Analytic";"Buffer node database pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_node_free_pages";"server";"Analytic";"Buffer node free pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_node_page_life_expectancy";"server";"Analytic";"Buffer node page life expectancy in milliseconds"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_node_stolen_pages";"server";"Analytic";"Buffer node stolen pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_node_target_pages";"server";"Analytic";"Buffer node target pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_node_total_pages";"server";"Analytic";"Buffer node total pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_partition_free_list_empty";"server";"Analytic";"Buffer partition free list empty"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_partition_free_list_requests";"server";"Analytic";"Buffer partition free list requests"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_partition_free_pages";"server";"Analytic";"Buffer partition free pages"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"buffer_pool_ring_buffer_recorded";"memory";"Debug";"Buffer pool ring buffer recorded"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"catalog_metadata_cache_entry_added";"database";"Analytic";"Catalog metadata cache entry added"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"catalog_metadata_cache_entry_pinned";"database";"Analytic";"Catalog metadata cache entry pinned"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"catalog_metadata_cache_entry_removed";"database";"Analytic";"Catalog metadata cache entry removed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"catalog_metadata_cache_entry_unpinned";"database";"Analytic";"Catalog metadata cache entry unpinned"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"catalog_metadata_cache_hit";"database";"Analytic";"Catalog metadata cache hit"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cdc_error";"cdc_logscan";"Debug";"CDC Error Information"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cdc_session";"cdc_logscan";"Debug";"CDC Logscan session Information"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"change_tracking_cleanup";"change_tracking";"Debug";"Change Tracking Cleanup"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"checkpoint_begin";"database";"Analytic";"Checkpoint has begun"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"checkpoint_end";"database";"Analytic";"Checkpoint has ended"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"constant_page_corruption_detected";"database";"Operational";"A page that should have been constant has changed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cached_cursor_added";"cursor";"Analytic";"Cursor manager cached cursor added"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cached_cursor_removed";"cursor";"Analytic";"Cursor manager cached cursor removed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_begin";"cursor";"Analytic";"Cursor manager cursor begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_cache_attempt";"cursor";"Analytic";"Cursor manager cursor cache attempt"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_cache_hit";"cursor";"Analytic";"Cursor manager cursor cache hit"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_end";"cursor";"Analytic";"Cursor manager cursor end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_memory_usage";"cursor";"Analytic";"Cursor manager cursor memory usage"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_plan_begin";"cursor";"Analytic";"Cursor manager cursor plan begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_plan_end";"cursor";"Analytic";"Cursor manager cursor plan end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_worktable_use_begin";"cursor";"Analytic";"Cursor manager cursor worktable use begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"cursor_manager_cursor_worktable_use_end";"cursor";"Analytic";"Cursor manager cursor worktable use end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"database_attached";"database";"Operational";"Database attached"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"database_detached";"database";"Operational";"Database detached"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"database_started";"database";"Operational";"Database started"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"database_stopped";"database";"Operational";"Database stopped"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"database_transaction_begin";"transactions";"Analytic";"Database transaction begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"database_transaction_end";"transactions";"Analytic";"Database transaction end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_backup_restore_throughput";"database";"Analytic";"Databases backup/restore throughput"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_bulk_copy_rows";"database";"Analytic";"Databases bulk copy rows"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_bulk_copy_throughput";"database";"Analytic";"Databases bulk copy throughput in KB"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_data_file_size_changed";"database";"Analytic";"Databases data file size change"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_dbcc_logical_scan";"database";"Analytic";"Databases DBCC logical scan"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_cache_hit";"database";"Analytic";"Databases log cache hit"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_cache_read";"database";"Analytic";"Databases log cache read"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_file_size_changed";"io";"Analytic";"Databases log file size changed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_file_used_size_changed";"io";"Analytic";"Databases log file used size changed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_flush";"io";"Analytic";"Databases log flush"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_flush_wait";"io";"Analytic";"Databases log flush wait in milliseconds"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_growth";"io";"Analytic";"Databases log growth"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_shrink";"io";"Analytic";"Databases log shrink"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_log_truncation";"io";"Analytic";"Databases log truncation"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"databases_shrink_data_movement";"io";"Analytic";"Databases shrink data movement"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deadlock_monitor_mem_stats";"deadlock_monitor";"Debug";"Deadlock monitor memory utilization statistics"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deadlock_monitor_perf_stats";"deadlock_monitor";"Debug";"Deadlock monitor performance statistics"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deadlock_monitor_pmo_status";"deadlock_monitor";"Debug";"Deadlock monitor PMO status at various checkpoints in the LDM cycle"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deadlock_monitor_serialized_local_wait_for_graph";"deadlock_monitor";"Debug";"Deadlock monitor local wait-for graph dump in binary form"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deadlock_monitor_state_transition";"deadlock_monitor";"Debug";"Deadlock Monitor state transition"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deprecation_announcement";"server";"Admin";"Occurs when you use a feature that will be removed from a future version of SQL Server, but will not be removed from the next major release of SQL Server."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"deprecation_final_support";"server";"Admin";"Occurs when you use a feature that will be removed from the next major release of SQL Server."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"error_reported";"errors";"Admin";"Error has been reported"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"error_ring_buffer_recorded";"errors";"Debug";"Error ring buffer recorded"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"errorlog_written";"errors";"Admin";"Errorlog written"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"failed_hresult";null;"Debug";"Failed HRESULT"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"failed_hresult_msg";null;"Debug";"Failed HRESULT"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"fastloadcontext_enabled";"server";"Debug";"Occurs when fastloadcontext is activated / deactivated"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"file_read";"io";"Analytic";"File read"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"file_read_completed";"io";"Analytic";"File read completed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"file_write_completed";"io";"Analytic";"File write completed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"file_written";"io";"Analytic";"File written"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"file_written_to_replica";"io";"Analytic";"File writes issued to sparse file for replica DB"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"filestream_file_io_dump";"execution";"Debug";"FILESTREAM file I/O streaming access dump"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"filestream_file_io_failure";"errors";"Operational";"FILESTREAM file I/O streaming access failure"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"filestream_file_io_request";"execution";"Analytic";"FILESTREAM file I/O streaming access request"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"filestream_file_io_response";"execution";"Analytic";"Response to a FILESTREAM file I/O streaming access request"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"filestream_file_io_trace";"execution";"Debug";"FILESTREAM file I/O streaming access tracing information"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"flush_file_buffers";"io";"Debug";"FlushFileBuffers called"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"ghost_cleanup";"database";"Debug";"Ghost cleanup"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"group_commit_value_changed";"transactions";"Debug";"Number of group commit waiters has changed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"host_task_ring_buffer_recorded";"clr";"Debug";"AppDomain ring buffer recorded"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"latch_acquire_time";"latch";"Debug";"Time taken to acquire a latch"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"latch_demoted";"latch";"Analytic";"Latch demotion"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"latch_promoted";"latch";"Analytic";"Latch promotion"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"latch_suspend_begin";"latch";"Analytic";"Latch suspend begin"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"latch_suspend_end";"latch";"Analytic";"Latch suspend end"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"leaf_page_disfavored";"access_methods";"Debug";"Index leaf page disfavored during scan"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"lock_acquired";"lock";"Analytic";"Lock acquired"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"lock_deadlock";"lock";"Analytic";"Deadlock"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"lock_released";"lock";"Analytic";"Lock released"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"locks_lock_timeouts";"lock";"Analytic";"Locks lock timeouts"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"locks_lock_timeouts_greater_than_0";"lock";"Analytic";"Locks lock timeouts greater than 0"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"locks_lock_waits";"lock";"Analytic";"Locks lock waits"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"log_buffer_allocated";"transactions";"Debug";"Log write buffer was allocated"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"log_buffer_freed";"transactions";"Debug";"Log block was freed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"log_flush_requested";"transactions";"Debug";"Log flush was requested"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_add_compensation_range";"replication";"Debug";"Occurs when the replication logreader encounters a partial rollback for a particular transaction."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_add_eor";"replication";"Debug";"Occurs when the replication logreader agent reads and EOR record."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_add_tran_info";"replication";"Debug";"Outputs transactions which are added to the repl hash table as well as some hash table statistics. "
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_apply_filter_proc";"replication";"Debug";"Occurs when the replication logreader agent executes a horizontal filtering proc."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_process_filestream_info";"replication";"Debug";"Occurs when a filestream info record is read by the replication logreader."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_process_text_info";"replication";"Debug";"Occurs when a text info record is read by the replication logreader."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"logreader_process_text_ptr";"replication";"Debug";"Occurs when a text pointer is being read by the replication logreader."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"long_io_detected";"io";"Operational";"Long IO detected"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"module_end";"execution";"Analytic";"End of module execution"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"module_start";"execution";"Analytic";"Start of module execution"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"page_compression_attempt_failed";"server";"Operational";"An attempt to compress a database page failed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"page_compression_tracing";"access_methods";"Debug";"Entry and exit tracking for page compression operations"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"page_split";"database";"Analytic";"Page split"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"perfobject_logicaldisk";null;"Analytic";"Returns a set of counters associated with the Logical Disk performance object. The event occurs once every 15 seconds for each hard or fixed disk drive."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"perfobject_process";null;"Analytic";"Returns a set of counters associated with the Process performance object. The event occurs once every 15 seconds for both the SQL Server and SQL Agent processes."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"perfobject_processor";null;"Analytic";"Returns a set of counters associated with the Processor performance object. The event occurs once every 15 seconds for each processor in the system."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"perfobject_system";null;"Analytic";"Returns a set of counters associated with the System performance object. The event occurs once every 15 seconds."
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"physical_page_read";"io";"Analytic";"Physical page read"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"physical_page_write";"io";"Analytic";"Physical page write"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"plan_cache_cache_attempt";"execution";"Analytic";"Plan cache cache attempt"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"plan_cache_cache_hit";"execution";"Analytic";"Plan cache cache hit"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"prefetch_extent";"io";"Debug";"Prefetch issued for a whole extent instead of a single page"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"rpc_completed";"execution";"Analytic";"RPC completed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"rpc_starting";"execution";"Analytic";"RPC starting"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sec_ekm_provider_called";"server";"Debug";"External Key Management external API called"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sort_add_run_tracing";"access_methods";"Debug";"Sort adding merge runs to the merge run directory"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sort_memory_grant_adjustment";"access_methods";"Debug";"Sort adjusting the memory grant of an in-progress sort"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sort_state_change_tracing";"access_methods";"Debug";"Sort internal events and state changes"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sort_statistics_tracing";"access_methods";"Debug";"Various statistics about the sort"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sp_statement_completed";"execution";"Analytic";"Stored procedure statement completed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sp_statement_starting";"execution";"Analytic";"Stored procedure statement starting"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sql_statement_completed";"execution";"Analytic";"SQL statement completed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"sql_statement_starting";"execution";"Analytic";"SQL statement starting"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"trace_flag_changed";"server";"Operational";"Trace flag changed"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"trace_print";"errors";"Debug";"Trace message published"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"user_settable";null;"Debug";"User settable"
"655fd93f-3364-40d5-b2ba-330f7ffb6491";"xml_deadlock_report";"deadlock_monitor";"Admin";"Produces a deadlock report in XML format."
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"assert_fired";"exception";"Debug";"Assert fired"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"async_io_completed";"io";"Debug";"Asynchronous I/O completed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"async_io_requested";"io";"Debug";"Asynchronous I/O requested"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"context_switch_callback_executed";"scheduling";"Debug";"Context switch callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"cpu_config_changed";"process";"Debug";"CPU configuration has changed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"crt_out_of_memory_routine_executed";"memory";"Debug";"CRT out-of-memory routine executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"crt_signal_abort_called";"process";"Debug";"CRT signal abort handler called"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"deadlock_scheduler_callback_executed";"scheduling";"Debug";"Deadlock scheduler callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"dump_exception_routine_executed";"exception";"Debug";"Dump exception routine executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"ex_terminator_called";"process";"Debug";"ex_terminator called"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"exception_ring_buffer_recorded";"exception";"Debug";"Exception ring buffer recorded"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"exit_routine_executed";"process";"Debug";"Exit routine executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"function_hook_changed";"process";"Debug";"Function hook changed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"idle_server_callback_executed";"scheduling";"Debug";"Idle server callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"malloc_spy_corrupted_memory_detected";"memory";"Debug";"MallocSpy detected corrupted memory"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"malloc_spy_memory_allocated";"memory";"Debug";"MallocSpy allocated memory"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"malloc_spy_memory_freed";"memory";"Debug";"MallocSpy freed memory"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"memory_broker_ring_buffer_recorded";"memory";"Debug";"Memory broker ring buffer recorded"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"memory_node_oom_ring_buffer_recorded";"memory";"Debug";"Memory node OOM ring buffer recorded"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"memory_utilization_effect_callback_executed";"memory";"Debug";"Memory utilization effect callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"multiple_tasks_enqueued";"scheduling";"Debug";"Multiple tasks enqueued"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"node_affinity_changed";"process";"Debug";"Node affinity mask changed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"node_created";"process";"Debug";"Node created"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"non_yielding_iocp_listener_callback_executed";"scheduling";"Debug";"Non-yielding IOCP listener callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"non_yielding_rm_callback_executed";"scheduling";"Debug";"Non-yielding RM callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"non_yielding_scheduler_callback_executed";"scheduling";"Debug";"Non-yielding scheduler callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"page_heap_memory_allocated";"memory";"Debug";"PageHeap allocated memory"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"page_heap_memory_freed";"memory";"Debug";"PageHeap freed memory"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"process_killed";"process";"Debug";"Process killed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"resource_monitor_ring_buffer_recorded";"memory";"Debug";"Resource monitor ring buffer recorded"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_created";"scheduling";"Debug";"Scheduler created"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_destroyed";"scheduling";"Debug";"Scheduler destroyed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_monitor_deadlock_ring_buffer_recorded";"scheduling";"Operational";"Deadlock ring buffer recorded for scheduler monitor"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_monitor_non_yielding_iocp_ring_buffer_recorded";"scheduling";"Debug";"Nonyielding IOCP ring buffer recorded for scheduler monitor"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_monitor_non_yielding_ring_buffer_recorded";"scheduling";"Operational";"Nonyielding ring buffer recorded for scheduler monitor"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_monitor_non_yielding_rm_ring_buffer_recorded";"scheduling";"Debug";"Non-yielding resource manager ring buffer recorded for scheduler monitor"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_monitor_stalled_dispatcher_ring_buffer_recorded";"scheduling";"Debug";"Stalled dispatcher event recorded for scheduler monitor"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_monitor_system_health_ring_buffer_recorded";"scheduling";"Debug";"System health ring buffer recorded for scheduler monitor"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_online_state_changed";"scheduling";"Debug";"Scheduler has been set online/offline"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"scheduler_ring_buffer_recorded";"scheduling";"Debug";"Scheduler ring buffer recorded"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"security_handler_routine_executed";"process";"Debug";"Security handler routine executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"set_abort_callback_executed";"process";"Debug";"SetAbort callback executed"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"spinlock_backoff";"synchronization";"Debug";"Spinlock backoff"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"task_enqueued";"scheduling";"Debug";"Task enqueued"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"thread_attached";"process";"Debug";"Thread attached"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"thread_detached";"process";"Debug";"Thread detached"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"wait_info";"scheduling";"Debug";"Information regarding waits in SQLOS"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"wait_info_external";"scheduling";"Debug";"Information regarding waits external to SQLOS"
"bd97cc63-3f38-4922-aa93-607bd12e78b2";"worker_state_callback_executed";"scheduling";"Debug";"Worker state callback executed"

[Geny]

Здравствуйте.

Хотелось бы добавить, что при первой загрузке профайлер запускается и работает, но если его остановить и запустить повторно, то он не запускается с ошибкой о которой я писал в предидущем топике.

[Alexander]

Не могли бы Вы выполнить следующий запрос:

Код: Выделить всё

select * from sys.dm_xe_sessions

Если данный запрос вернёт большое количество сессий с именем devart, попробуйте удалить их с помощью:

Код: Выделить всё

DROP EVENT SESSION devart_session_id
ON SERVER

где devart_session_id- имя сессии, которую нужно удалить.

[Geny]

Если данный запрос вернёт большое количество сессий с именем devart, попробуйте удалить их с помощью:

Да запрос возвращает много сессий с именем devart, а разве они не должны сами очищатся при выходе из профайлера?

[Alexander]

Не могли бы Вы сообщить, удалось ли Вам запустить профайлер после удаления указанных сессий?

[Geny]

Здравствуйте.

Удалось, но после остановки профайлера сессии остались..., и все опять сломалось...(

Картина получается следующая:

- запускаем профайлер, он работает
- останавливаем профайлер (кнопочка "стоп"), штатно остановки не происходит и профайлер отваливается по таймауту
- повторно запустить профайлер не удаётся из-за наличия повисших сессий...

как-то так....

Спасибо.

[Alexander]

В данный момент мы занимаемся исследованием данной проблемы и свяжемся с Вами в ближайшее время.