dba:mssql:mssql_basic_queries
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dba:mssql:mssql_basic_queries [2023/08/14 08:15] – dodger | dba:mssql:mssql_basic_queries [2023/08/14 16:35] – [Last hour events] dodger | ||
---|---|---|---|
Line 42: | Line 42: | ||
</ | </ | ||
+ | ===== Log ===== | ||
+ | ==== Event log ==== | ||
+ | While connected to a database and using '' | ||
+ | <code sql> | ||
+ | select * | ||
+ | from sys.event_log; | ||
+ | </ | ||
+ | |||
+ | ==== Last hour events ==== | ||
+ | |||
+ | <code sql> | ||
+ | SELECT | ||
+ | * | ||
+ | FROM | ||
+ | sys.event_log | ||
+ | WHERE | ||
+ | start_time > DateAdd (HOUR, -1, CONVERT(datetime2, | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | ==== Not connection succeed events ==== | ||
+ | |||
+ | <code sql> | ||
+ | SELECT | ||
+ | * | ||
+ | FROM | ||
+ | sys.event_log | ||
+ | WHERE | ||
+ | event_subtype_desc <> ' | ||
+ | ORDER BY | ||
+ | start_time DESC OFFSET 11 ROWS FETCH NEXT 10 ROWS ONLY; | ||
+ | </ | ||
dba/mssql/mssql_basic_queries.txt · Last modified: 2023/08/15 08:59 by dodger