Skip to main content
Skip table of contents

Useful SQL queries and CLI commands

Check running queries
SQL
select cast(request.session_id as int)                  session_id,
       cast(sqltext.text as nvarchar(4000))             query_text,
       cast(request.total_elapsed_time as nvarchar(50)) elapsed_time,
       request.blocking_session_id
from sys.dm_exec_requests request
cross apply sys.dm_exec_sql_text(sql_handle) AS sqltext
where request.session_id <> @@spid
  and /* Filter Current Session SPID */
    db_name(request.database_id) = 'aec_prod'
Check if there are any blocking queries
SQL
SELECT blocking_session_id, session_id, wait_duration_ms, wait_type, resource_description
FROM sys.dm_os_waiting_tasks
WHERE blocking_session_id IS NOT NULL;
Restart solr
CODE
sudo systemctl enable solr && sudo systemctl start solr
Check solr status
CODE
sudo systemctl status solr
Check latest backup restorations
SQL
SELECT
   [rs].[destination_database_name],
   [rs].[restore_date],
   [rs].[user_name],
   [bs].[database_name] as [source_database_name],
   [bmf].[physical_device_name] as [backup_file_used_for_restore],
   [bs].[backup_start_date],
   [bs].[backup_finish_date]
FROM msdb..restorehistory rs
INNER JOIN msdb..backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id]
INNER JOIN msdb..backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id]
where destination_database_name = DB_NAME()
ORDER BY [rs].[restore_date] DESC

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.