Troubleshoot Report Performance

The following indexes are recommended in the BGSessions database to support the integration:

create index session__start_time_ndx on session(start_time);
create index session__host_name_ndx on session(host_name);
create index session__host_name_ndx on session(host_name);
create index session__jump_group_name_ndx on session(jump_group_name);
create index session__lsid_ndx on session(lsid);
create index session_event__type_performed_by_type_ndx on session_event(type, performed_by_type);
create index session_event__session_id_ndx on session_event(session_id);
create index session_event__type_destination_ndx on session_event(type, destination);
create index session_event__type_performed_by_ndx on session_event(type, performed_by);
create index session_event_data__session_event_id_ndx on session_event_data(session_event_id);
create index session_event_data__name_ndx on session_event_data(name);