Forum Discussion
azure portal logging - no results found
Hello - I am trying to access the azure logging facility for my servers for the first time. Within the database I wish to post logs to and read logs from I have set up 'diagnostic settings'. Within ...
On the Log Analytics Workspace, what happens if you run the following:
AzureDiagnostics
| where LogicalServerName_s contains 'server1'
JK_UK When I run this query I do get records - 2,763 to be exact.
Here is the first row. madevsql01 is the actual server name. adscheduler is the database name on this particular record. Many different categories, including DatabaseWaitStatistics, QueryStoreRuntimeStatistics to name two.
| 6/18/2020, 9:58:09.753 AM | /SUBSCRIPTIONS/E1F843CE-5BAC-42BD-B3C2-A9EA02672DAB/RESOURCEGROUPS/OTTOBASE-CAMPAIGNS/PROVIDERS/MICROSOFT.SQL/SERVERS/MADEVSQL01/DATABASES/ADSCHEDULER | DatabaseWaitStatistics | OTTOBASE-CAMPAIGNS | e1f843ce-5bac-42bd-b3c2-a9ea02672dab | MICROSOFT.SQL | ADSCHEDULER | SERVERS/DATABASES | DatabaseWaitStatistcsEvent | madevsql01 | AdScheduler |