Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Agent History
|   sysjobhistory_step_id |   run_duration_s | run_date                | report_time             | snapshot_time           | report_period_group     | pbi_job_step_id              |   run_status | end_date                |
|------------------------:|-----------------:|:------------------------|:------------------------|:------------------------|:------------------------|:-----------------------------|-------------:|:------------------------|
|                       1 |                0 | 2019-11-01 10:03:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:03:00.000 |
|                       1 |                0 | 2019-11-01 10:03:15.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:03:15.000 |
|                       1 |                0 | 2019-11-01 10:03:30.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:03:30.000 |
|                       1 |                0 | 2019-11-01 10:03:45.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:03:45.000 |
|                       1 |                0 | 2019-11-01 10:04:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:04:00.000 |
|                       1 |                0 | 2019-11-01 10:04:45.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:04:45.000 |
|                       1 |                0 | 2019-11-01 10:05:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:05:00.000 |
|                       1 |                0 | 2019-11-01 10:05:15.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:05:15.000 |
|                       1 |                0 | 2019-11-01 10:05:30.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:05:30.000 |
|                       1 |                0 | 2019-11-01 10:05:45.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:10:00.000 | 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM.JOB.2.STEP.6 |            1 | 2019-11-01 10:05:45.000 |


Table: Blockers
| report_time             | database_name     | sql_instance    | snapshot_time           | report_period_group     | attach_activity_id                   |   attach_activity_sequence | blocking_start_time     | blocking_end_time       |   blocked_ecid |   blocked_spid | blocked_sql                                                | lock_mode   |   blocking_ecid |   blocking_spid | blocking_sql                                               |   blocking_duration_ms | blocking_client_app_name                                                  | blocking_client_hostname   | report_xml                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|:------------------------|:------------------|:----------------|:------------------------|:------------------------|:-------------------------------------|---------------------------:|:------------------------|:------------------------|---------------:|---------------:|:-----------------------------------------------------------|:------------|----------------:|----------------:|:-----------------------------------------------------------|-----------------------:|:--------------------------------------------------------------------------|:---------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2019-10-31 14:04:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 14:03:16.000 | 2019-10-31 14:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        429 | 2019-10-31 14:02:00.483 | 2019-10-31 14:03:15.290 |              0 |             54 | exec usp_RandomQ                                           | IS          |               0 |              56 | BEGIN TRANSACTION                                          |                  74805 | SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="136413"><blocked-process><process id="process2287001dc28" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="74805" ownerId="58900039" transactionname="SELECT" lasttranstarted="2019-10-31T14:02:00.483" XDES="0x228686f5ac0" lockMode="IS" schedulerid="1" kpid="6632" status="suspended" spid="54" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2019-10-31T14:02:00.483" lastbatchcompleted="2019-10-31T14:02:00.483" lastattention="1900-01-01T00:00:00.483" clientapp="SQLAgent - TSQL JobStep (Job 0x9BCFC778A766B449A0CC55AE0D999D94 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58900039" currentdb="6" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056"><executionStack><frame line="12" stmtstart="326" stmtend="662" sqlhandle="0x03000600976f3f2b4b3dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="50" stmtstart="1190" stmtend="1230" sqlhandle="0x030006005f91e032583dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="1" stmtend="30" sqlhandle="0x0100060021598217a09eb6062802000000000000000000000000000000000000000000000000000000000000"/></executionStack><inputbuf>  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |                        |                                                                           |                            | exec usp_RandomQ   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="165498" spid="56" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T14:00:00.890" lastbatchcompleted="2019-10-31T14:00:00.890" lastattention="1900-01-01T00:00:00.890" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58885767" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="3" stmtstart="166" stmtend="242" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 2019-11-01 00:02:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-11-01 00:01:13.000 | 2019-11-01 00:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        449 | 2019-11-01 00:00:00.400 | 2019-11-01 00:01:06.296 |              0 |             60 | BEGIN TRANSACTION                                          | X           |               0 |              56 | BEGIN TRANSACTION                                          |                  65898 | SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="143571"><blocked-process><process id="process22865125848" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="65898" ownerId="61923999" transactionname="user_transaction" lasttranstarted="2019-11-01T00:00:00.397" XDES="0x22870af4490" lockMode="X" schedulerid="3" kpid="7944" status="suspended" spid="60" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-11-01T00:00:00.397" lastbatchcompleted="2019-11-01T00:00:00.390" lastattention="1900-01-01T00:00:00.390" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="61923999" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="2" stmtstart="42" stmtend="152" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                         |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |             |                 |                 |   SELECT *                                                 |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |             |                 |                 |   INTO #T1                                                 |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                | ROLLBACK TRANSACTION                                       |             |                 |                 |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)          |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:01:00'                               |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="51160" spid="56" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-11-01T00:00:00.383" lastbatchcompleted="2019-11-01T00:00:00.383" lastattention="1900-01-01T00:00:00.383" clientapp="SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="61923984" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="5" stmtstart="198" stmtend="250" sqlhandle="0x02000000bc87d90556dd8916e1f1352f7a94428c2f7f7ad50000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   SELECT *                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   INTO #T1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:01:00'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |    </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 2019-11-01 05:04:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-11-01 05:03:14.000 | 2019-11-01 05:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        461 | 2019-11-01 05:00:00.863 | 2019-11-01 05:03:01.393 |              0 |             60 | BEGIN TRANSACTION                                          | X           |               0 |              56 | BEGIN TRANSACTION                                          |                 180530 | SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="147187"><blocked-process><process id="process22865124ca8" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="180530" ownerId="63278138" transactionname="user_transaction" lasttranstarted="2019-11-01T05:00:00.877" XDES="0x231b77ec490" lockMode="X" schedulerid="3" kpid="4856" status="suspended" spid="60" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-11-01T05:00:00.873" lastbatchcompleted="2019-11-01T05:00:00.873" lastattention="1900-01-01T00:00:00.873" clientapp="SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="63278138" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="2" stmtstart="42" stmtend="184" sqlhandle="0x02000000bc87d90556dd8916e1f1352f7a94428c2f7f7ad50000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                        |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   SELECT *                                                 |             |                 |                 |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   INTO #T1                                                 |             |                 |                 |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |                        |                                                                           |                            |   SELECT *                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)          |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   INTO #T1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |     WAITFOR DELAY '00:01:00'                               |             |                 |                 |                                                            |                        |                                                                           |                            |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                | ROLLBACK TRANSACTION                                       |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:01:00'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |    </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="166602" spid="56" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-11-01T05:00:00.850" lastbatchcompleted="2019-11-01T05:00:00.850" lastattention="1900-01-01T00:00:00.850" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="63278094" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="3" stmtstart="166" stmtend="242" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 2019-10-31 15:04:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:03:14.000 | 2019-10-31 15:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        441 | 2019-10-31 15:00:00.360 | 2019-10-31 15:03:05.416 |              0 |             55 | BEGIN TRANSACTION                                          | X           |               0 |              58 | BEGIN TRANSACTION                                          |                 185056 | SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="137129"><blocked-process><process id="process2284a455468" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="185056" ownerId="59241209" transactionname="user_transaction" lasttranstarted="2019-10-31T15:00:00.363" XDES="0x22ce4768490" lockMode="X" schedulerid="3" kpid="5704" status="suspended" spid="55" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T15:00:00.363" lastbatchcompleted="2019-10-31T15:00:00.363" lastattention="1900-01-01T00:00:00.363" clientapp="SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="59241209" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="2" stmtstart="42" stmtend="184" sqlhandle="0x02000000bc87d90556dd8916e1f1352f7a94428c2f7f7ad50000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                        |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   SELECT *                                                 |             |                 |                 |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   INTO #T1                                                 |             |                 |                 |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |                        |                                                                           |                            |   SELECT *                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)          |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   INTO #T1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |     WAITFOR DELAY '00:01:00'                               |             |                 |                 |                                                            |                        |                                                                           |                            |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                | ROLLBACK TRANSACTION                                       |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:01:00'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |    </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="168885" spid="58" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T15:00:00.363" lastbatchcompleted="2019-10-31T15:00:00.363" lastattention="1900-01-01T00:00:00.363" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="59241207" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="3" stmtstart="166" stmtend="242" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 2019-10-31 12:04:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 12:03:15.000 | 2019-10-31 12:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        402 | 2019-10-31 12:00:00.653 | 2019-10-31 12:03:13.246 |              0 |             62 | exec usp_RandomQ                                           | IS          |               0 |              58 | BEGIN TRANSACTION                                          |                 192593 | SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="134978"><blocked-process><process id="process2287001dc28" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="192593" ownerId="58133211" transactionname="SELECT" lasttranstarted="2019-10-31T12:00:00.657" XDES="0x22861815ac0" lockMode="IS" schedulerid="1" kpid="2844" status="suspended" spid="62" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2019-10-31T12:00:00.653" lastbatchcompleted="2019-10-31T12:00:00.653" lastattention="1900-01-01T00:00:00.653" clientapp="SQLAgent - TSQL JobStep (Job 0x9BCFC778A766B449A0CC55AE0D999D94 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58133211" currentdb="6" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056"><executionStack><frame line="12" stmtstart="326" stmtend="662" sqlhandle="0x03000600976f3f2b4b3dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="50" stmtstart="1190" stmtend="1230" sqlhandle="0x030006005f91e032583dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="1" stmtend="30" sqlhandle="0x01000600215982175001ecea2702000000000000000000000000000000000000000000000000000000000000"/></executionStack><inputbuf> |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |                        |                                                                           |                            | exec usp_RandomQ   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="172568" spid="58" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T12:00:00.643" lastbatchcompleted="2019-10-31T12:00:00.643" lastattention="1900-01-01T00:00:00.643" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58133197" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="3" stmtstart="166" stmtend="242" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 2019-10-31 12:33:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 12:32:15.000 | 2019-10-31 12:30:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        407 | 2019-10-31 12:30:00.750 | 2019-10-31 12:31:16.556 |              0 |             62 | exec usp_RandomQ                                           | IS          |               0 |              58 | BEGIN TRANSACTION                                          |                  75805 | SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="135314"><blocked-process><process id="process227979e9c28" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="75805" ownerId="58320878" transactionname="SELECT" lasttranstarted="2019-10-31T12:30:00.757" XDES="0x22862aefac0" lockMode="IS" schedulerid="3" kpid="6404" status="suspended" spid="62" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2019-10-31T12:30:00.757" lastbatchcompleted="2019-10-31T12:30:00.750" lastattention="1900-01-01T00:00:00.750" clientapp="SQLAgent - TSQL JobStep (Job 0x9BCFC778A766B449A0CC55AE0D999D94 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58320878" currentdb="6" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056"><executionStack><frame line="12" stmtstart="326" stmtend="662" sqlhandle="0x03000600976f3f2b4b3dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="50" stmtstart="1190" stmtend="1230" sqlhandle="0x030006005f91e032583dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="1" stmtend="30" sqlhandle="0x01000600215982172045a3622802000000000000000000000000000000000000000000000000000000000000"/></executionStack><inputbuf>  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   SELECT *                                                 |                        |                                                                           |                            | exec usp_RandomQ   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="50782" spid="58" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T12:30:00.717" lastbatchcompleted="2019-10-31T12:30:00.717" lastattention="1900-01-01T00:00:00.717" clientapp="SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58320805" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="5" stmtstart="198" stmtend="250" sqlhandle="0x02000000bc87d90556dd8916e1f1352f7a94428c2f7f7ad50000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   INTO #T1                                                 |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)          |                        |                                                                           |                            |   SELECT *                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:01:00'                               |                        |                                                                           |                            |   INTO #T1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:01:00'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |    </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 2019-11-01 10:03:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-11-01 10:02:18.000 | 2019-11-01 10:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        467 | 2019-11-01 10:00:00.620 | 2019-11-01 10:01:34.060 |              0 |             61 | BEGIN TRANSACTION                                          | X           |               0 |              59 | BEGIN TRANSACTION                                          |                  93439 | SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="150762"><blocked-process><process id="process22861033848" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="93439" ownerId="64748479" transactionname="user_transaction" lasttranstarted="2019-11-01T10:00:00.607" XDES="0x22f316ac490" lockMode="X" schedulerid="4" kpid="5244" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-11-01T10:00:00.620" lastbatchcompleted="2019-11-01T10:00:00.620" lastattention="1900-01-01T00:00:00.620" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="64748479" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="2" stmtstart="42" stmtend="152" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                         |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |             |                 |                 |   SELECT *                                                 |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |             |                 |                 |   INTO #T1                                                 |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                | ROLLBACK TRANSACTION                                       |             |                 |                 |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)          |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:01:00'                               |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="50612" spid="59" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-11-01T10:00:00.617" lastbatchcompleted="2019-11-01T10:00:00.617" lastattention="1900-01-01T00:00:00.617" clientapp="SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="64748443" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="5" stmtstart="198" stmtend="250" sqlhandle="0x02000000bc87d90556dd8916e1f1352f7a94428c2f7f7ad50000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   SELECT *                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   INTO #T1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:01:00'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |    </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 2019-10-31 11:04:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 11:03:20.000 | 2019-10-31 11:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        390 | 2019-10-31 11:02:00.143 | 2019-10-31 11:03:13.873 |              0 |             56 | exec usp_RandomQ                                           | IS          |               0 |              60 | BEGIN TRANSACTION                                          |                  73729 | SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="134260"><blocked-process><process id="process228651244e8" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="73729" ownerId="57776424" transactionname="SELECT" lasttranstarted="2019-10-31T11:02:00.143" XDES="0x22865183ac0" lockMode="IS" schedulerid="3" kpid="7992" status="suspended" spid="56" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2019-10-31T11:02:00.140" lastbatchcompleted="2019-10-31T11:02:00.140" lastattention="1900-01-01T00:00:00.140" clientapp="SQLAgent - TSQL JobStep (Job 0x917927544BC97447BE290E46B1E4811A : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="57776424" currentdb="6" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056"><executionStack><frame line="12" stmtstart="326" stmtend="662" sqlhandle="0x03000600976f3f2b4b3dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="50" stmtstart="1190" stmtend="1230" sqlhandle="0x030006005f91e032583dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="1" stmtend="30" sqlhandle="0x0100060021598217b044a3622802000000000000000000000000000000000000000000000000000000000000"/></executionStack><inputbuf>  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |                        |                                                                           |                            | exec usp_RandomQ   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="164714" spid="60" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T11:00:00.937" lastbatchcompleted="2019-10-31T11:00:00.937" lastattention="1900-01-01T00:00:00.937" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="57761573" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="3" stmtstart="166" stmtend="242" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 2019-10-31 20:02:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 20:01:13.000 | 2019-10-31 20:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        445 | 2019-10-31 20:00:00.393 | 2019-10-31 20:01:03.196 |              0 |             56 | BEGIN TRANSACTION                                          | X           |               0 |              60 | BEGIN TRANSACTION                                          |                  62804 | SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="140696"><blocked-process><process id="process227feaf6ca8" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="62804" ownerId="60849692" transactionname="user_transaction" lasttranstarted="2019-10-31T20:00:00.390" XDES="0x22792bb0490" lockMode="X" schedulerid="1" kpid="7976" status="suspended" spid="56" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T20:00:00.390" lastbatchcompleted="2019-10-31T20:00:00.390" lastattention="1900-01-01T00:00:00.390" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="60849692" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="2" stmtstart="42" stmtend="152" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                         |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |             |                 |                 |   SELECT *                                                 |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |             |                 |                 |   INTO #T1                                                 |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                | ROLLBACK TRANSACTION                                       |             |                 |                 |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)          |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:01:00'                               |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="51018" spid="60" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T20:00:00.390" lastbatchcompleted="2019-10-31T20:00:00.390" lastattention="1900-01-01T00:00:00.390" clientapp="SQLAgent - TSQL JobStep (Job 0x8DF48F7E1889E14FBC33AE79204B7D47 : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="60849689" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="5" stmtstart="198" stmtend="250" sqlhandle="0x02000000bc87d90556dd8916e1f1352f7a94428c2f7f7ad50000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   SELECT *                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   INTO #T1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |   FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:01:00'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |    </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 2019-10-31 13:05:00.000 | StackOverflow2010 | WIN-E8OB9B8SIQ2 | 2019-10-31 13:04:14.000 | 2019-10-31 13:00:00.000 | 219CC843-18A4-4318-B12B-980C3B057E5C |                        424 | 2019-10-31 13:00:00.203 | 2019-10-31 13:03:21.893 |              0 |             62 | exec usp_RandomQ                                           | IS          |               0 |              61 | BEGIN TRANSACTION                                          |                 201690 | SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1) | WIN-E8OB9B8SIQ2            | <blocked-process-report monitorLoop="135698"><blocked-process><process id="process227feaf7088" taskpriority="0" logused="0" waitresource="OBJECT: 6:5575058:0 " waittime="201690" ownerId="58506387" transactionname="SELECT" lasttranstarted="2019-10-31T13:00:00.203" XDES="0x2280b8fa610" lockMode="IS" schedulerid="1" kpid="4692" status="suspended" spid="62" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2019-10-31T13:00:00.203" lastbatchcompleted="2019-10-31T13:00:00.193" lastattention="1900-01-01T00:00:00.193" clientapp="SQLAgent - TSQL JobStep (Job 0x917927544BC97447BE290E46B1E4811A : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58506387" currentdb="6" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056"><executionStack><frame line="12" stmtstart="326" stmtend="662" sqlhandle="0x03000600976f3f2b4b3dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="50" stmtstart="1190" stmtend="1230" sqlhandle="0x030006005f91e032583dec00e2aa000001000000000000000000000000000000000000000000000000000000"/><frame line="1" stmtend="30" sqlhandle="0x01000600215982172045a3622802000000000000000000000000000000000000000000000000000000000000"/></executionStack><inputbuf> |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK) |                        |                                                                           |                            | exec usp_RandomQ   </inputbuf></process></blocked-process><blocking-process><process status="suspended" waittime="177863" spid="61" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2019-10-31T13:00:00.183" lastbatchcompleted="2019-10-31T13:00:00.180" lastattention="1900-01-01T00:00:00.180" clientapp="SQLAgent - TSQL JobStep (Job 0x12133491754CCD4089057BAC029F488F : Step 1)" hostname="WIN-E8OB9B8SIQ2" hostpid="3588" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="58506108" currentdb="6" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056"><executionStack><frame line="3" stmtstart="166" stmtend="242" sqlhandle="0x0200000010414a151445252991f63305fc78d6c4806d8eac0000000000000000000000000000000000000000"/></executionStack><inputbuf>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |     WAITFOR DELAY '00:03:00' -- 3 minutes                  |                        |                                                                           |                            | BEGIN TRANSACTION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 | ROLLBACK TRANSACTION                                       |                        |                                                                           |                            |   SELECT * FROM [dbo].[Comments] WITH (TABLOCKX, HOLDLOCK)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            |     WAITFOR DELAY '00:03:00' -- 3 minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|                         |                   |                 |                         |                         |                                      |                            |                         |                         |                |                |                                                            |             |                 |                 |                                                            |                        |                                                                           |                            | ROLLBACK TRANSACTION   </inputbuf></process></blocking-process></blocked-process-report>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |


Table: Dim Agent Job Steps
| step_name                                         |   sqlwatch_job_step_id | pbi_job_id            | pbi_job_step_id               |
|:--------------------------------------------------|-----------------------:|:----------------------|:------------------------------|
| dbo.usp_sqlwatch_logger_whoisactive               |                      1 | VM-XKUTIEGROZAV.JOB.1 | VM-XKUTIEGROZAV.JOB.1.STEP.1  |
| dbo.usp_sqlwatch_internal_add_database            |                      2 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.2  |
| dbo.usp_sqlwatch_internal_add_job                 |                      3 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.3  |
| dbo.usp_sqlwatch_internal_add_master_file         |                      4 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.4  |
| dbo.usp_sqlwatch_internal_add_memory_clerk        |                      5 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.5  |
| dbo.usp_sqlwatch_internal_add_performance_counter |                      6 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.6  |
| dbo.usp_sqlwatch_internal_add_table               |                      7 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.7  |
| dbo.usp_sqlwatch_internal_add_wait_type           |                      8 | VM-XKUTIEGROZAV.JOB.2 | VM-XKUTIEGROZAV.JOB.2.STEP.8  |
| dbo.usp_sqlwatch_internal_purge_deleted_items     |                      9 | VM-XKUTIEGROZAV.JOB.3 | VM-XKUTIEGROZAV.JOB.3.STEP.9  |
| dbo.usp_sqlwatch_internal_retention               |                     10 | VM-XKUTIEGROZAV.JOB.3 | VM-XKUTIEGROZAV.JOB.3.STEP.10 |


Table: Dim Agent Jobs
| sql_instance    | job_name                         | deleted_when   | job_create_date         | pbi_job_id             |
|:----------------|:---------------------------------|:---------------|:------------------------|:-----------------------|
| VM-XKUTIEGROZAV | SQLWATCH-LOGGER-WHOISACTIVE      |                | 2019-10-30 09:33:22.230 | VM-XKUTIEGROZAV.JOB.1  |
| VM-XKUTIEGROZAV | SQLWATCH-INTERNAL-META-CONFIG    |                | 2019-10-30 09:33:19.980 | VM-XKUTIEGROZAV.JOB.2  |
| VM-XKUTIEGROZAV | SQLWATCH-INTERNAL-RETENTION      |                | 2019-10-30 09:33:20.420 | VM-XKUTIEGROZAV.JOB.3  |
| VM-XKUTIEGROZAV | SQLWATCH-LOGGER-PERFORMANCE      |                | 2019-10-30 09:33:21.730 | VM-XKUTIEGROZAV.JOB.4  |
| VM-XKUTIEGROZAV | SQLWATCH-LOGGER-AGENT-HISTORY    |                | 2019-10-30 09:33:20.466 | VM-XKUTIEGROZAV.JOB.5  |
| VM-XKUTIEGROZAV | syspolicy_purge_history          |                | 2019-10-10 12:34:32.933 | VM-XKUTIEGROZAV.JOB.6  |
| VM-XKUTIEGROZAV | SQLWATCH-LOGGER-DISK-UTILISATION |                | 2019-10-30 09:33:20.543 | VM-XKUTIEGROZAV.JOB.7  |
| VM-XKUTIEGROZAV | SQLWATCH-LOGGER-INDEXES          |                | 2019-10-30 09:33:20.590 | VM-XKUTIEGROZAV.JOB.8  |
| VM-XKUTIEGROZAV | SSIS Server Maintenance Job      |                | 2019-10-31 08:42:52.496 | VM-XKUTIEGROZAV.JOB.11 |
| VM-XKUTIEGROZAV | CENTRAL-REPO-GET-REMOTES         |                | 2019-10-31 09:10:08.023 | VM-XKUTIEGROZAV.JOB.12 |


Table: Dim Database
| database_name       | sql_instance_id   |   sqlwatch_database_id | database_create_date    | deleted_when   | pbi_database_id      | database_size_bytes_current   | database_bytes_growth   | total_growth_days   | database_size_bytes_current_formatted   | growth_bytes_per_day_formatted   |   log_growth_bytes_per_day | log_growth_bytes_per_day_formatted   | log_size_bytes_current_formatted   | database_size_MB   | log_size_MB   | log_size_total_bytes_current   |   database_growth_per_day_MB |   database_growth_bytes_per_day | data_bytes_current   | index_size_bytes_current   | unused_bytes_current   | unallocated_space_bytes_current   | Data (MB)   | Index (MB)   | Unallocated (MB)    | Unused (MB)   |
|:--------------------|:------------------|-----------------------:|:------------------------|:---------------|:---------------------|:------------------------------|:------------------------|:--------------------|:----------------------------------------|:---------------------------------|---------------------------:|:-------------------------------------|:-----------------------------------|:-------------------|:--------------|:-------------------------------|-----------------------------:|--------------------------------:|:---------------------|:---------------------------|:-----------------------|:----------------------------------|:------------|:-------------|:--------------------|:--------------|
| master              | VM-XKUTIEGROZAV   |                      1 | 2003-04-08 09:13:36.390 |                | VM-XKUTIEGROZAV.DB.1 | 6752829                       | 0                       | 2                   | 6.44 MB                                 | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        | 1.99 MB                            | 6.4399995803833008 | 1.9921875     | 2088960                        |                        0     |                               0 | 1802240              | 1646592                    | 516096                 | 692060                            | 1.71875     | 1.5703125    | 0.65999984741210938 | 0.4921875     |
| model               | VM-XKUTIEGROZAV   |                      2 | 2003-04-08 09:13:36.390 |                | VM-XKUTIEGROZAV.DB.2 | 16777216                      | 0                       | 2                   | 16.00 MB                                | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        | 7.99 MB                            | 16                 | 7.9921875     | 8380416                        |                        0     |                               0 | 1032192              | 1220608                    | 278528                 | 5861539                           | 0.984375    | 1.1640625    | 5.5899991989135742  | 0.265625      |
| msdb                | VM-XKUTIEGROZAV   |                      3 | 2017-08-22 19:39:22.886 |                | VM-XKUTIEGROZAV.DB.3 | 18287165                      | 1835008                 | 2                   | 17.44 MB                                | 896.00 KB / Day                  |                     131072 | 128.00 KB / Day                      | 1.24 MB                            | 17.4399995803833   | 1.2421875     | 1302528                        |                        0.875 |                          917504 | 12230656             | 3604480                    | 786432                 | 356515                            | 11.6640625  | 3.4375       | 0.33999919891357422 | 0.75          |
| mssqlsystemresource | VM-XKUTIEGROZAV   |                      4 | 1970-01-01 00:00:00.000 |                | VM-XKUTIEGROZAV.DB.4 |                               |                         |                     |                                         | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        |                                    |                    |               |                                |                        0     |                               0 |                      |                            |                        |                                   |             |              |                     |               |
| SQLWATCH            | VM-XKUTIEGROZAV   |                      5 | 2019-10-30 09:32:53.383 |                | VM-XKUTIEGROZAV.DB.5 | 1426063360                    | 1342177280              | 2                   | 1.33 GB                                 | 640.00 MB / Day                  |                   67108864 | 64.00 MB / Day                       | 135.99 MB                          | 1360               | 135.9921875   | 142598144                      |                      640     |                       671088640 | 1012686848           | 124248064                  | 125075456              | 21443379                          | 965.7734375 | 118.4921875  | 20.449999809265137  | 119.28125     |
| tempdb              | VM-XKUTIEGROZAV   |                      6 | 2019-10-30 09:28:51.493 |                | VM-XKUTIEGROZAV.DB.6 | 159383552                     | 134217728               | 2                   | 152.00 MB                               | 64.00 MB / Day                   |                          0 | 0.00 KB / Day                        | 7.99 MB                            | 152                | 7.9921875     | 8380416                        |                       64     |                        67108864 | 3170304              | 1662976                    | 2678784                | 143487139                         | 3.0234375   | 1.5859375    | 136.83999919891357  | 2.5546875     |
| SSISDB              | VM-XKUTIEGROZAV   |                      7 | 2019-10-31 08:42:51.863 |                | VM-XKUTIEGROZAV.DB.7 | 46724546                      |                         |                     | 44.56 MB                                | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        | 4.55 MB                            | 44.559999465942383 | 4.5546875     | 4775936                        |                        0     |                               0 | 3186688              | 2007040                    | 2285568                | 34466693                          | 3.0390625   | 1.9140625    | 32.869999885559082  | 2.1796875     |
| master              | VM-YQRLSNOIWCJM   |                      1 | 2003-04-08 09:13:36.390 |                | VM-YQRLSNOIWCJM.DB.1 | 6752829                       | 0                       | 8                   | 6.44 MB                                 | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        | 1.99 MB                            | 6.4399995803833008 | 1.9921875     | 2088960                        |                        0     |                               0 | 1777664              | 1638400                    | 532480                 | 702545                            | 1.6953125   | 1.5625       | 0.66999912261962891 | 0.5078125     |
| model               | VM-YQRLSNOIWCJM   |                      2 | 2003-04-08 09:13:36.390 |                | VM-YQRLSNOIWCJM.DB.2 | 16777216                      | 0                       | 8                   | 16.00 MB                                | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        | 7.99 MB                            | 16                 | 7.9921875     | 8380416                        |                        0     |                               0 | 1032192              | 1220608                    | 278528                 | 5861539                           | 0.984375    | 1.1640625    | 5.5899991989135742  | 0.265625      |
| msdb                | VM-YQRLSNOIWCJM   |                      3 | 2017-08-22 19:39:22.886 |                | VM-YQRLSNOIWCJM.DB.3 | 19335741                      | 0                       | 8                   | 18.44 MB                                | 0.00 KB / Day                    |                          0 | 0.00 KB / Day                        | 2.24 MB                            | 18.4399995803833   | 2.2421875     | 2351104                        |                        0     |                               0 | 12214272             | 3391488                    | 974848                 | 398458                            | 11.6484375  | 3.234375     | 0.37999916076660156 | 0.9296875     |


Table: Dim Environment
| Environment   |
|:--------------|
| DEV-172       |
| DEV-160       |
| DEV-62        |


Table: Dim Index
| index_name                           | index_type_desc   |   index_id | date_deleted   | pbi_table_id                 | pbi_index_id                        |
|:-------------------------------------|:------------------|-----------:|:---------------|:-----------------------------|:------------------------------------|
| PK____Refact__D3AEFFDB13B18A5F       | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.230 | VM-XKUTIEGROZAV.DB.5.TBL.230.IDX.1  |
| pk_sql_perf_mon_config_perf_counters | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.231 | VM-XKUTIEGROZAV.DB.5.TBL.231.IDX.2  |
| PK__sqlwatch__BEDD6A25292103EA       | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.232 | VM-XKUTIEGROZAV.DB.5.TBL.232.IDX.4  |
| pk_config_sql_instance               | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.233 | VM-XKUTIEGROZAV.DB.5.TBL.233.IDX.5  |
| pk_sqlwatch_config_wait_stats        | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.234 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6  |
| pk_sqlwatch_logger_agent_job_history | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.235 | VM-XKUTIEGROZAV.DB.5.TBL.235.IDX.7  |
| PK_logger_disk_util_database         | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.236 | VM-XKUTIEGROZAV.DB.5.TBL.236.IDX.8  |
| PK_disk_util_vol                     | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.237 | VM-XKUTIEGROZAV.DB.5.TBL.237.IDX.9  |
| pk_logger_missing_indexes            | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.238 | VM-XKUTIEGROZAV.DB.5.TBL.238.IDX.10 |
| pk_index_usage_stats                 | CLUSTERED         |          1 |                | VM-XKUTIEGROZAV.DB.5.TBL.239 | VM-XKUTIEGROZAV.DB.5.TBL.239.IDX.11 |


Table: Dim Master File
|   file_type | file_name    | file_physical_name                                                                        | logical_disk   | pbi_database_id      | pbi_master_file_id         |   size_on_disk_bytes |
|------------:|:-------------|:------------------------------------------------------------------------------------------|:---------------|:---------------------|:---------------------------|---------------------:|
|           0 | master       | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\master.mdf           | C:             | VM-XKUTIEGROZAV.DB.1 | VM-XKUTIEGROZAV.DB.1.MF.1  |              4653056 |
|           1 | mastlog      | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\mastlog.ldf          | C:             | VM-XKUTIEGROZAV.DB.1 | VM-XKUTIEGROZAV.DB.1.MF.2  |              2097152 |
|           0 | modeldev     | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\model.mdf            | C:             | VM-XKUTIEGROZAV.DB.2 | VM-XKUTIEGROZAV.DB.2.MF.6  |              8388608 |
|           1 | modellog     | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\modellog.ldf         | C:             | VM-XKUTIEGROZAV.DB.2 | VM-XKUTIEGROZAV.DB.2.MF.7  |              8388608 |
|           0 | MSDBData     | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf         | C:             | VM-XKUTIEGROZAV.DB.3 | VM-XKUTIEGROZAV.DB.3.MF.8  |             16973824 |
|           1 | MSDBLog      | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf          | C:             | VM-XKUTIEGROZAV.DB.3 | VM-XKUTIEGROZAV.DB.3.MF.9  |              1310720 |
|           0 | SQLWATCH     | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\SQLWATCH_Primary.mdf | C:             | VM-XKUTIEGROZAV.DB.5 | VM-XKUTIEGROZAV.DB.5.MF.10 |           1283457024 |
|           1 | SQLWATCH_log | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\SQLWATCH_Primary.ldf | C:             | VM-XKUTIEGROZAV.DB.5 | VM-XKUTIEGROZAV.DB.5.MF.11 |            142606336 |
|           0 | tempdev      | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tempdb.mdf           | C:             | VM-XKUTIEGROZAV.DB.6 | VM-XKUTIEGROZAV.DB.6.MF.3  |             75497472 |
|           1 | templog      | C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\templog.ldf          | C:             | VM-XKUTIEGROZAV.DB.6 | VM-XKUTIEGROZAV.DB.6.MF.4  |              8388608 |


Table: Dim Missing Index
| statement                                                       |   index_handle | date_added              | pbi_table_id                 | pbi_missing_index_id                 |
|:----------------------------------------------------------------|---------------:|:------------------------|:-----------------------------|:-------------------------------------|
| [SQLWATCH].[dbo].[sqlwatch_logger_agent_job_history]            |             13 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.235 | VM-XKUTIEGROZAV.DB.5.TBL.235.MIDX.91 |
| [SQLWATCH].[dbo].[sqlwatch_logger_agent_job_history]            |              9 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.235 | VM-XKUTIEGROZAV.DB.5.TBL.235.MIDX.92 |
| [SQLWATCH].[dbo].[sqlwatch_logger_agent_job_history]            |              4 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.235 | VM-XKUTIEGROZAV.DB.5.TBL.235.MIDX.93 |
| [SQLWATCH].[dbo].[sqlwatch_logger_agent_job_history]            |             51 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.235 | VM-XKUTIEGROZAV.DB.5.TBL.235.MIDX.94 |
| [SQLWATCH].[dbo].[sqlwatch_logger_index_usage_stats]            |            123 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.239 | VM-XKUTIEGROZAV.DB.5.TBL.239.MIDX.95 |
| [SQLWATCH].[dbo].[sqlwatch_logger_index_usage_stats_histogram]  |            125 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.240 | VM-XKUTIEGROZAV.DB.5.TBL.240.MIDX.81 |
| [SQLWATCH].[dbo].[sqlwatch_logger_index_usage_stats_histogram]  |            160 | 2019-10-31 12:04:20.840 | VM-XKUTIEGROZAV.DB.5.TBL.240 | VM-XKUTIEGROZAV.DB.5.TBL.240.MIDX.96 |
| [SQLWATCH].[dbo].[sqlwatch_logger_perf_file_stats]              |              1 | 2019-10-30 12:04:20.886 | VM-XKUTIEGROZAV.DB.5.TBL.241 | VM-XKUTIEGROZAV.DB.5.TBL.241.MIDX.1  |
| [SQLWATCH].[dbo].[sqlwatch_logger_perf_file_stats]              |             16 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.241 | VM-XKUTIEGROZAV.DB.5.TBL.241.MIDX.84 |
| [SQLWATCH].[dbo].[sqlwatch_logger_perf_os_performance_counters] |             19 | 2019-10-30 18:04:21.160 | VM-XKUTIEGROZAV.DB.5.TBL.243 | VM-XKUTIEGROZAV.DB.5.TBL.243.MIDX.85 |


Table: Dim OS Volume
| sql_instance    | volume_name   | label     | file_system   |   volume_block_size_bytes | pbi_volume_id         | disk_info            |   volume_total_space_bytes_current |   volume_free_space_bytes_current |   total_growth_days |   volume_bytes_growth |   free_space_percentage |   growth_bytes_per_day |   days_until_full | total_space_formatted   | free_space_formatted   | growth_bytes_per_day_formatted   | free_space_percentage_formatted   |   Total Spaced Used (GB) |
|:----------------|:--------------|:----------|:--------------|--------------------------:|:----------------------|:---------------------|-----------------------------------:|----------------------------------:|--------------------:|----------------------:|------------------------:|-----------------------:|------------------:|:------------------------|:-----------------------|:---------------------------------|:----------------------------------|-------------------------:|
| VM-XKUTIEGROZAV | C:\           |           | NTFS          |                      4096 | VM-XKUTIEGROZAV.VOL.1 | C:\  (NTFS)          |                        64078475264 |                       33659514880 |                   2 |            3108876288 |               0.525286  |             1554438144 |                21 | 59.68 GB                | 31.35 GB               | 1.45 GB / Day                    | 53 %                              |                 28.3299  |
| VM-YQRLSNOIWCJM | C:\           |           | NTFS          |                      4096 | VM-YQRLSNOIWCJM.VOL.1 | C:\  (NTFS)          |                        64078475264 |                       34889039872 |                   8 |            5484728320 |               0.544474  |              685591040 |                50 | 59.68 GB                | 32.49 GB               | 653.83 MB / Day                  | 54 %                              |                 27.1848  |
| WIN-E8OB9B8SIQ2 | C:\           |           | NTFS          |                      4096 | WIN-E8OB9B8SIQ2.VOL.1 | C:\  (NTFS)          |                        64078475264 |                        1382060032 |                   1 |             162357248 |               0.0215682 |              162357248 |                 8 | 59.68 GB                | 1.29 GB                | 154.84 MB / Day                  | 2 %                               |                 58.3906  |
| WIN-E8OB9B8SIQ2 | G:\           | SLOW_DISK | NTFS          |                     65536 | WIN-E8OB9B8SIQ2.VOL.2 | G:\ SLOW_DISK (NTFS) |                        64288129024 |                       54666919936 |                   1 |                     0 |               0.850342  |                      0 |                 0 | 59.87 GB                | 50.91 GB               | 0.00 KB / Day                    | 85 %                              |                  8.96045 |
| WIN-E8OB9B8SIQ2 | E:\           | REMOVE_ME | NTFS          |                     65536 | WIN-E8OB9B8SIQ2.VOL.3 | E:\ REMOVE_ME (NTFS) |                       107236753408 |                      104829878272 |                   1 |                     0 |               0.977556  |                      0 |                 0 | 99.87 GB                | 97.63 GB               | 0.00 KB / Day                    | 98 %                              |                  2.24158 |


Table: Dim Server
| physical_name   | service_name   | local_net_address   |   local_tcp_port | environment   |   utc_offset_minutes | sql_instance    | servername      | sql_version                                            |
|:----------------|:---------------|:--------------------|-----------------:|:--------------|---------------------:|:----------------|:----------------|:-------------------------------------------------------|
| VM-XKUTIEGROZAV | MSSQLSERVER    | 192.168.168.172     |             1433 | DEV-172       |                    0 | VM-XKUTIEGROZAV | VM-XKUTIEGROZAV | Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)  |
|                 |                |                     |                  |               |                      |                 |                 | 	Aug 22 2017 17:04:49                                                         |
|                 |                |                     |                  |               |                      |                 |                 | 	Copyright (C) 2017 Microsoft Corporation                                                        |
|                 |                |                     |                  |               |                      |                 |                 | 	Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)                                                        |
| VM-YQRLSNOIWCJM | MSSQLSERVER    | 192.168.168.161     |             1433 | DEV-160       |                   60 | VM-YQRLSNOIWCJM | VM-YQRLSNOIWCJM |                                                        |
| WIN-E8OB9B8SIQ2 | MSSQLSERVER    | 192.168.168.62      |             1433 | DEV-62        |                    0 | WIN-E8OB9B8SIQ2 | WIN-E8OB9B8SIQ2 |                                                        |


Table: Dim Table
| table_name                        | table_type   | date_added              | pbi_database_id      | pbi_table_id                   |
|:----------------------------------|:-------------|:------------------------|:---------------------|:-------------------------------|
| dbo.autoadmin_managed_databases   | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11097 |
| dbo.autoadmin_master_switch       | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11098 |
| dbo.autoadmin_system_flags        | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11099 |
| dbo.autoadmin_task_agent_metadata | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11100 |
| dbo.autoadmin_task_agents         | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11101 |
| dbo.backupfile                    | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11102 |
| dbo.backupfilegroup               | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11103 |
| dbo.backupmediafamily             | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11104 |
| dbo.backupmediaset                | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11105 |
| dbo.backupset                     | BASE TABLE   | 2019-11-01 10:49:31.540 | WIN-E8OB9B8SIQ2.DB.3 | WIN-E8OB9B8SIQ2.DB.3.TBL.11106 |


Table: Dim Time
| report_period_group     | report_time             | date                    |   year | relative_date_label   | interval_minutes_5      | interval_minutes_15     | interval_minutes_60     | month_name   |
|:------------------------|:------------------------|:------------------------|-------:|:----------------------|:------------------------|:------------------------|:------------------------|:-------------|
| 2019-10-31 11:00:00.000 | 2019-10-31 11:03:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:04:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:05:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:05:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:06:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:05:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:07:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:05:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:08:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:05:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:09:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:05:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:10:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:10:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:11:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:10:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |
| 2019-10-31 11:00:00.000 | 2019-10-31 11:12:00.000 | 2019-10-31 00:00:00.000 |   2019 | Yesterday             | 2019-10-31 11:10:00.000 | 2019-10-31 11:00:00.000 | 2019-10-31 11:00:00.000 | October      |


Table: Disk Utilisation DB
|   database_size_bytes |   unallocated_space_bytes |   reserved_bytes |   data_bytes |   index_size_bytes |   unused_bytes |   log_size_total_bytes |   log_size_used_bytes | report_time             | pbi_database_id      |   Data (MB) |   Index Size (MB) |   Unallocated (MB) |   Unused (MB) | snapshot_time           |
|----------------------:|--------------------------:|-----------------:|-------------:|-------------------:|---------------:|-----------------------:|----------------------:|:------------------------|:---------------------|------------:|------------------:|-------------------:|--------------:|:------------------------|
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 13:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 13:04:37.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 14:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 14:04:38.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 20:04:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 20:03:53.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 20:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 20:04:37.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 21:50:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 21:49:38.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 22:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 22:04:38.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-24 23:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-24 23:04:37.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-25 00:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-25 00:04:37.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-25 01:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-25 01:04:38.000 |
|              16777216 |                   5861539 |          2531328 |      1032192 |            1220608 |         278528 |                8380416 |                740864 | 2019-10-25 02:05:00.000 | VM-YQRLSNOIWCJM.DB.2 |    0.984375 |           1.16406 |               5.59 |      0.265625 | 2019-10-25 02:04:37.000 |


Table: Disk Utilisation OS
|   volume_free_space_bytes |   volume_total_space_bytes | report_time             | pbi_volume_id         | snapshot_time           |   disk_free_percentage |
|--------------------------:|---------------------------:|:------------------------|:----------------------|:------------------------|-----------------------:|
|               40373768192 |                64078475264 | 2019-10-24 13:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 13:04:38.000 |               0.630068 |
|               40372154368 |                64078475264 | 2019-10-24 14:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 14:04:38.000 |               0.630042 |
|               40369188864 |                64078475264 | 2019-10-24 20:04:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 20:03:56.000 |               0.629996 |
|               40369139712 |                64078475264 | 2019-10-24 20:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 20:04:39.000 |               0.629995 |
|               40368467968 |                64078475264 | 2019-10-24 21:50:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 21:49:42.000 |               0.629985 |
|               39051067392 |                64078475264 | 2019-10-24 22:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 22:04:39.000 |               0.609426 |
|               39116517376 |                64078475264 | 2019-10-24 23:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-24 23:04:38.000 |               0.610447 |
|               39110094848 |                64078475264 | 2019-10-25 00:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-25 00:04:38.000 |               0.610347 |
|               39104012288 |                64078475264 | 2019-10-25 01:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-25 01:04:39.000 |               0.610252 |
|               39118061568 |                64078475264 | 2019-10-25 02:05:00.000 | VM-YQRLSNOIWCJM.VOL.1 | 2019-10-25 02:04:38.000 |               0.610471 |


Table: File Statistics Sankey Database to File
| sql_instance    | source   | destination        |   size_on_disk_bytes | pbi_database_id      | pbi_master_file_id         |   Size on Disk (GB) |
|:----------------|:---------|:-------------------|---------------------:|:---------------------|:---------------------------|--------------------:|
| VM-XKUTIEGROZAV | master   | master (Rows)      |              4653056 | VM-XKUTIEGROZAV.DB.1 | VM-XKUTIEGROZAV.DB.1.MF.1  |          0.0043335  |
| VM-XKUTIEGROZAV | master   | mastlog (Log)      |              2097152 | VM-XKUTIEGROZAV.DB.1 | VM-XKUTIEGROZAV.DB.1.MF.2  |          0.00195312 |
| VM-XKUTIEGROZAV | model    | modeldev (Rows)    |              8388608 | VM-XKUTIEGROZAV.DB.2 | VM-XKUTIEGROZAV.DB.2.MF.6  |          0.0078125  |
| VM-XKUTIEGROZAV | model    | modellog (Log)     |              8388608 | VM-XKUTIEGROZAV.DB.2 | VM-XKUTIEGROZAV.DB.2.MF.7  |          0.0078125  |
| VM-XKUTIEGROZAV | msdb     | MSDBData (Rows)    |             16973824 | VM-XKUTIEGROZAV.DB.3 | VM-XKUTIEGROZAV.DB.3.MF.8  |          0.0158081  |
| VM-XKUTIEGROZAV | msdb     | MSDBLog (Log)      |              1310720 | VM-XKUTIEGROZAV.DB.3 | VM-XKUTIEGROZAV.DB.3.MF.9  |          0.0012207  |
| VM-XKUTIEGROZAV | SQLWATCH | SQLWATCH (Rows)    |           1283457024 | VM-XKUTIEGROZAV.DB.5 | VM-XKUTIEGROZAV.DB.5.MF.10 |          1.19531    |
| VM-XKUTIEGROZAV | SQLWATCH | SQLWATCH_log (Log) |            142606336 | VM-XKUTIEGROZAV.DB.5 | VM-XKUTIEGROZAV.DB.5.MF.11 |          0.132812   |
| VM-XKUTIEGROZAV | tempdb   | tempdev (Rows)     |             75497472 | VM-XKUTIEGROZAV.DB.6 | VM-XKUTIEGROZAV.DB.6.MF.3  |          0.0703125  |
| VM-XKUTIEGROZAV | tempdb   | templog (Log)      |              8388608 | VM-XKUTIEGROZAV.DB.6 | VM-XKUTIEGROZAV.DB.6.MF.4  |          0.0078125  |


Table: File Statistics Sankey File to Disk
| sql_instance    | source             | destination   |   size_on_disk_bytes | pbi_database_id      | pbi_master_file_id         |
|:----------------|:-------------------|:--------------|---------------------:|:---------------------|:---------------------------|
| VM-XKUTIEGROZAV | master (Rows)      | C:            |              4653056 | VM-XKUTIEGROZAV.DB.1 | VM-XKUTIEGROZAV.DB.1.MF.1  |
| VM-XKUTIEGROZAV | mastlog (Log)      | C:            |              2097152 | VM-XKUTIEGROZAV.DB.1 | VM-XKUTIEGROZAV.DB.1.MF.2  |
| VM-XKUTIEGROZAV | modeldev (Rows)    | C:            |              8388608 | VM-XKUTIEGROZAV.DB.2 | VM-XKUTIEGROZAV.DB.2.MF.6  |
| VM-XKUTIEGROZAV | modellog (Log)     | C:            |              8388608 | VM-XKUTIEGROZAV.DB.2 | VM-XKUTIEGROZAV.DB.2.MF.7  |
| VM-XKUTIEGROZAV | MSDBData (Rows)    | C:            |             16973824 | VM-XKUTIEGROZAV.DB.3 | VM-XKUTIEGROZAV.DB.3.MF.8  |
| VM-XKUTIEGROZAV | MSDBLog (Log)      | C:            |              1310720 | VM-XKUTIEGROZAV.DB.3 | VM-XKUTIEGROZAV.DB.3.MF.9  |
| VM-XKUTIEGROZAV | SQLWATCH (Rows)    | C:            |           1283457024 | VM-XKUTIEGROZAV.DB.5 | VM-XKUTIEGROZAV.DB.5.MF.10 |
| VM-XKUTIEGROZAV | SQLWATCH_log (Log) | C:            |            142606336 | VM-XKUTIEGROZAV.DB.5 | VM-XKUTIEGROZAV.DB.5.MF.11 |
| VM-XKUTIEGROZAV | tempdev (Rows)     | C:            |             75497472 | VM-XKUTIEGROZAV.DB.6 | VM-XKUTIEGROZAV.DB.6.MF.3  |
| VM-XKUTIEGROZAV | templog (Log)      | C:            |              8388608 | VM-XKUTIEGROZAV.DB.6 | VM-XKUTIEGROZAV.DB.6.MF.4  |


Table: File Statistics
| report_period_group     |   num_of_reads_delta |   num_of_bytes_read_delta |   num_of_writes_delta |   num_of_bytes_written_delta |   size_on_disk_bytes_delta | report_time             |   io_latency_read |   io_latency_write | pbi_master_file_id         |   delta_seconds |   bytes_written_per_second |   bytes_read_per_second |
|:------------------------|---------------------:|--------------------------:|----------------------:|-----------------------------:|---------------------------:|:------------------------|------------------:|-------------------:|:---------------------------|----------------:|---------------------------:|------------------------:|
| 2019-10-31 13:15:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 13:15:00.000 |                 0 |                  0 | VM-YQRLSNOIWCJM.DB.2.MF.6  |              60 |                          0 |                       0 |
| 2019-11-01 06:00:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-11-01 06:00:00.000 |                 0 |                  0 | VM-YQRLSNOIWCJM.DB.2.MF.7  |              60 |                          0 |                       0 |
| 2019-10-31 17:30:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 17:30:00.000 |                 0 |                  0 | VM-XKUTIEGROZAV.DB.7.MF.13 |              60 |                          0 |                       0 |
| 2019-10-31 11:15:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 11:15:00.000 |                 0 |                  0 | WIN-E8OB9B8SIQ2.DB.2.MF.7  |              60 |                          0 |                       0 |
| 2019-10-31 23:00:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 23:00:00.000 |                 0 |                  0 | VM-XKUTIEGROZAV.DB.6.MF.5  |              60 |                          0 |                       0 |
| 2019-10-31 11:15:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 11:15:00.000 |                 0 |                  0 | VM-YQRLSNOIWCJM.DB.6.MF.5  |              60 |                          0 |                       0 |
| 2019-10-31 18:45:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 18:45:00.000 |                 0 |                  0 | WIN-E8OB9B8SIQ2.DB.6.MF.17 |              60 |                          0 |                       0 |
| 2019-10-31 13:00:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 13:00:00.000 |                 0 |                  0 | VM-XKUTIEGROZAV.DB.2.MF.7  |              60 |                          0 |                       0 |
| 2019-10-31 13:30:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 13:30:00.000 |                 0 |                  0 | VM-XKUTIEGROZAV.DB.6.MF.5  |              60 |                          0 |                       0 |
| 2019-10-31 17:45:00.000 |                    0 |                         0 |                     0 |                            0 |                          0 | 2019-10-31 17:45:00.000 |                 0 |                  0 | WIN-E8OB9B8SIQ2.DB.8.MF.15 |              60 |                          0 |                       0 |


Table: fn_get_end_time
| fn_get_end_time         |
|:------------------------|
| 2019-11-01 11:02:42.703 |


Table: Index Histogram
|   sqlwatch_stat_range_id | RANGE_HI_KEY                   |   RANGE_ROWS |   EQ_ROWS |   DISTINCT_RANGE_ROWS |   AVG_RANGE_ROWS | report_time             | collection_time         | snapshot_time           | report_period_group     | pbi_index_id                       |
|-------------------------:|:-------------------------------|-------------:|----------:|----------------------:|-----------------:|:------------------------|:------------------------|:------------------------|:------------------------|:-----------------------------------|
|                    43451 | ABR                            |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43453 | BROKER_CONNECTION_RECEIVE_TASK |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43457 | CLR_AUTO_EVENT                 |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43458 | CLR_RWLOCK_WRITER              |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43459 | CMEMTHREAD                     |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43460 | CURSOR_ASYNC                   |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43463 | DEADLOCK_ENUM_MUTEX            |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43464 | DIRTY_PAGE_POLL                |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43465 | DISPATCHER_QUEUE_SEMAPHORE     |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |
|                    43466 | DTC                            |            0 |         1 |                     0 |                1 | 2019-11-01 11:02:00.000 | 2019-11-01 11:01:02.193 | 2019-11-01 11:01:02.000 | 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV.DB.5.TBL.234.IDX.6 |


Table: Index Statistics
| report_period_group     |   used_pages_count_delta |   user_seeks_delta |   user_updates_delta | last_user_seek          | last_user_scan          | last_user_lookup        | last_user_update        | stats_date              |   user_scans_delta | pbi_index_id                           |   user_lookups_delta |   scan_to_seek_ratio |   update_ratio |   used_pages_count | report_time             | index_status   |   user_seeks |   user_scans |   user_lookups |   user_updates |   sqlwatch_database_id |   sqlwatch_table_id |   sqlwatch_index_id |   index_maintenance_performance_impact |
|:------------------------|-------------------------:|-------------------:|---------------------:|:------------------------|:------------------------|:------------------------|:------------------------|:------------------------|-------------------:|:---------------------------------------|---------------------:|---------------------:|---------------:|-------------------:|:------------------------|:---------------|-------------:|-------------:|---------------:|---------------:|-----------------------:|--------------------:|--------------------:|---------------------------------------:|
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11444.IDX.82  |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11444 |                  82 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11466.IDX.114 |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11466 |                 114 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11469.IDX.117 |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11469 |                 117 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11456.IDX.99  |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11456 |                  99 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11465.IDX.113 |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11465 |                 113 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11444.IDX.81  |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11444 |                  81 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11452.IDX.96  |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11452 |                  96 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11456.IDX.100 |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11456 |                 100 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11471.IDX.118 |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11471 |                 118 |                            1.01679e+08 |
| 2019-11-01 11:00:00.000 |                        0 |                  0 |                    0 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:51.903 | 2019-11-01 10:52:55.360 | 2019-11-01 10:52:55.300 | 2019-11-01 10:00:21.573 |                  0 | WIN-E8OB9B8SIQ2.DB.6.TBL.11473.IDX.121 |                    0 |                    0 |        0.28722 |            2054.81 | 2019-11-01 11:00:00.000 | Enabled        |      44724.1 |         1222 |        714.115 |        49483.4 |                      6 |               11473 |                 121 |                            1.01679e+08 |


Table: Memory Clerks
| report_period_group     | sql_instance    | clerk_name   |   allocated_kb | report_time             |
|:------------------------|:----------------|:-------------|---------------:|:------------------------|
| 2019-10-31 22:45:00.000 | VM-XKUTIEGROZAV | OTHER        |         304594 | 2019-10-31 22:45:00.000 |
| 2019-11-01 11:00:00.000 | VM-XKUTIEGROZAV | OTHER        |         316317 | 2019-11-01 11:00:00.000 |
| 2019-11-01 02:15:00.000 | VM-XKUTIEGROZAV | OTHER        |         316915 | 2019-11-01 02:15:00.000 |
| 2019-10-31 12:30:00.000 | VM-XKUTIEGROZAV | OTHER        |         341649 | 2019-10-31 12:30:00.000 |
| 2019-10-31 13:30:00.000 | VM-XKUTIEGROZAV | OTHER        |         330375 | 2019-10-31 13:30:00.000 |
| 2019-11-01 09:45:00.000 | VM-XKUTIEGROZAV | OTHER        |         318306 | 2019-11-01 09:45:00.000 |
| 2019-10-31 17:30:00.000 | VM-XKUTIEGROZAV | OTHER        |         316868 | 2019-10-31 17:30:00.000 |
| 2019-11-01 00:00:00.000 | VM-XKUTIEGROZAV | OTHER        |         300213 | 2019-11-01 00:00:00.000 |
| 2019-11-01 06:00:00.000 | VM-XKUTIEGROZAV | OTHER        |         301889 | 2019-11-01 06:00:00.000 |
| 2019-10-31 15:00:00.000 | VM-XKUTIEGROZAV | OTHER        |         297900 | 2019-10-31 15:00:00.000 |


Table: Missing Index Stats
| report_period_group     |   unique_compiles |   user_seeks |   user_scans |   avg_total_user_cost |   avg_user_impact | report_time             | last_user_seek          | pbi_missing_index_id                  |    Impact |
|:------------------------|------------------:|-------------:|-------------:|----------------------:|------------------:|:------------------------|:------------------------|:--------------------------------------|----------:|
| 2019-10-31 12:00:00.000 |                 1 |            4 |            0 |              0.829229 |             90.35 | 2019-10-31 12:05:00.000 | 2019-10-31 12:00:20.476 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.97  |   2.99683 |
| 2019-10-31 18:00:00.000 |                 1 |           10 |            0 |              0.829229 |             90.35 | 2019-10-31 18:05:00.000 | 2019-10-31 18:00:20.880 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.97  |   7.49209 |
| 2019-11-01 00:00:00.000 |                 1 |           16 |            0 |              0.829229 |             90.35 | 2019-11-01 00:05:00.000 | 2019-11-01 00:00:27.916 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.97  |  11.9873  |
| 2019-11-01 06:00:00.000 |                 2 |           22 |            0 |              0.86494  |             90.37 | 2019-11-01 06:05:00.000 | 2019-11-01 06:00:20.656 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.97  |  17.1962  |
| 2019-10-31 12:00:00.000 |                21 |           21 |            0 |              1.02245  |             75.43 | 2019-10-31 12:05:00.000 | 2019-10-31 12:00:00.910 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.98  |  16.1959  |
| 2019-10-31 18:00:00.000 |                57 |           57 |            0 |              1.0474   |             75.76 | 2019-10-31 18:05:00.000 | 2019-10-31 18:00:00.240 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.98  |  45.2302  |
| 2019-11-01 00:00:00.000 |                93 |           93 |            0 |              1.07408  |             75.97 | 2019-11-01 00:05:00.000 | 2019-11-01 00:00:00.506 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.98  |  75.8857  |
| 2019-11-01 06:00:00.000 |               129 |          129 |            0 |              1.09624  |             76.47 | 2019-11-01 06:05:00.000 | 2019-11-01 06:00:01.040 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.98  | 108.14    |
| 2019-11-01 11:00:00.000 |                 1 |            1 |            0 |              1.54195  |             89.85 | 2019-11-01 11:02:00.000 | 2019-11-01 11:00:21.446 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.102 |   1.38544 |
| 2019-11-01 11:00:00.000 |                 2 |            2 |            0 |              1.64893  |             84.76 | 2019-11-01 11:02:00.000 | 2019-11-01 11:00:00.740 | VM-YQRLSNOIWCJM.DB.5.TBL.234.MIDX.103 |   2.79526 |


Table: Performance Counters
| object_name              | instance_name   | counter_name         | sql_instance    |   cntr_value | report_period_group     | report_time             | pbi_perf_counter_key                                          |
|:-------------------------|:----------------|:---------------------|:----------------|-------------:|:------------------------|:------------------------|:--------------------------------------------------------------|
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 14:15:00.000 | 2019-10-31 14:15:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 14:45:00.000 | 2019-10-31 14:45:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 23:30:00.000 | 2019-10-31 23:30:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 23:00:00.000 | 2019-10-31 23:00:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-11-01 03:45:00.000 | 2019-11-01 03:45:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-11-01 09:30:00.000 | 2019-11-01 09:30:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 16:15:00.000 | 2019-10-31 16:15:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 18:15:00.000 | 2019-10-31 18:15:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-11-01 03:15:00.000 | 2019-11-01 03:15:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |
| SQLServer:Buffer Manager |                 | Free list stalls/sec | VM-XKUTIEGROZAV |            0 | 2019-10-31 13:15:00.000 | 2019-10-31 13:15:00.000 | VM-XKUTIEGROZAV:SQLServer:Buffer Manager:Free list stalls/sec |


Table: Process Memory
| sql_instance    | report_period_group     |   memory_utilization_percentage |   physical_memory_in_use_mb | report_time             |
|:----------------|:------------------------|--------------------------------:|----------------------------:|:------------------------|
| VM-YQRLSNOIWCJM | 2019-10-31 15:15:00.000 |                              96 |                     2232.85 | 2019-10-31 15:15:00.000 |
| VM-YQRLSNOIWCJM | 2019-11-01 10:30:00.000 |                              96 |                     2232.77 | 2019-11-01 10:30:00.000 |
| VM-YQRLSNOIWCJM | 2019-10-31 15:00:00.000 |                              96 |                     2232.27 | 2019-10-31 15:00:00.000 |
| VM-YQRLSNOIWCJM | 2019-10-31 16:15:00.000 |                              96 |                     2234.04 | 2019-10-31 16:15:00.000 |
| VM-YQRLSNOIWCJM | 2019-11-01 03:30:00.000 |                              96 |                     2234.74 | 2019-11-01 03:30:00.000 |
| VM-YQRLSNOIWCJM | 2019-10-31 11:45:00.000 |                              96 |                     2234.04 | 2019-10-31 11:45:00.000 |
| VM-YQRLSNOIWCJM | 2019-11-01 07:15:00.000 |                              96 |                     2231.8  | 2019-11-01 07:15:00.000 |
| VM-YQRLSNOIWCJM | 2019-11-01 03:15:00.000 |                              96 |                     2235.11 | 2019-11-01 03:15:00.000 |
| VM-YQRLSNOIWCJM | 2019-11-01 03:00:00.000 |                              96 |                     2235.09 | 2019-11-01 03:00:00.000 |
| VM-YQRLSNOIWCJM | 2019-11-01 04:30:00.000 |                              96 |                     2230.68 | 2019-11-01 04:30:00.000 |


Table: ref_agent_run_status
|   run_status | run_status_desc   |
|-------------:|:------------------|
|            0 | Failed            |
|            1 | Succeeded         |
|            2 | Retry             |
|            3 | Canceled          |
|            4 | In Progress       |


Table: ref_file_type
|   file_type | file_type_desc                                                                                     |
|------------:|:---------------------------------------------------------------------------------------------------|
|           0 | Rows                                                                                               |
|           1 | Log                                                                                                |
|           2 | FILESTREAM                                                                                         |
|           3 | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
|           4 | FULLTEXT (Full-text catalogs earlier than SQL Server 2008.)                                        |


Table: ref_index_status
| index_disabled   | status_desc   |
|:-----------------|:--------------|
| True             | DISABLED      |
| False            | ENABLED       |


Table: ref_index_type
|   index_type | index_type_desc                |
|-------------:|:-------------------------------|
|            0 | Heap                           |
|            1 | Clustered                      |
|            2 | Nonclustered                   |
|            3 | XML                            |
|            4 | Spatial                        |
|            5 | Clustered columnstore index    |
|            6 | Nonclustered columnstore index |
|            7 | Nonclustered hash index        |


Table: ref_metric_description
| Measure                                  | Description                                                                                                            |
|:-----------------------------------------|:-----------------------------------------------------------------------------------------------------------------------|
| SQL Compilations to Batch Requests Ratio | High % of compilations could suggests SQL is not able to cache execution plans. It could indicate insufficient memory. |


Table: ref_percentage_range
|   min_percentage |   max_percentage |
|-----------------:|-----------------:|
|                0 |                1 |


Table: ref_perf_counters_poster
| object_name               | counter_name              | description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | desired_value_txt                             | desired_value_num   | issue_header                   |   counter_id |
|:--------------------------|:--------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------------------------------------|:--------------------|:-------------------------------|-------------:|
| README                    | CREDITS                   | The following reference comes from the SQL Server Perfom Counters of Interest by Quest Software (Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge, Raoul Illyaos                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                               |                     |                                |            1 |
| SQLServer:Access Methods  | Full Scans/sec            | Monitors the number of full scans on tables or indexes. Ignore unless high CPU coincides with high scan rates. High scan rates may be caused by missing indexes, very small tables, or requests for too many records. A sudden increase in this value may indicate a statistics threshold has been reached, resulting in an index no longer being used.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 1 Full Scan/sec per 1000 Index Searches/sec   | 0.001               | High Full Scan rate.           |            2 |
| SQLServer:SQL Statistics  | Batch Requests/Sec        | Number of batch requests received per second, and is a good general indicator for the activity level of the SQL Server. This counter is highly dependent on the hardware and quality of code running on the server. The more powerful the hardware, the higher this number can be, even on poorly coded applications. A value of 1000 batch requests/sec is easily attainable though a typical 100Mbs NIC can only handle about 3000 batch requests/sec.Many other counter thresh- olds depend upon batch requests/sec while, in some cases, a low (or high) number does not point to poor processing power. You should frequently use this counter in combination with other counters, such as processor utilization or user connections.In version 2000, “Transactions/ sec” was the counter most often used to measure overall activity, while versions 2005 and later use “Batch Requests/sec”. Versions 2005 prior to SP2, measure this counter differently and may lead to some misunderstandings. Read the footnote for more details. |                                               |                     |                                |            3 |
| SQLServer:SQL Statistics  | SQL Compilations/sec      | Number of times that Transact-SQL compilations occurred, per second (including recompiles). The lower this value is the better. High values often indicate excessive adhoc querying and should be as low as possible. If excessive adhoc querying is happening, try rewriting the queries as procedures or invoke the queries using sp_ex- ecuteSQL. When rewriting isn’t possible, consider using a plan guide or setting the database to parameterization forced mode.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | < 10% of the number of Batch Re- quests/Sec   | 0.1                 | High compilation rate.         |            4 |
| SQLServer:SQL Statistics  | SQL Re-Compila- tions/sec | Number of times, per second, that Transact-SQL objects attempted to be executed but had to be recompiled before completion. This number should be at or near zero, since recompiles can cause deadlocks and exclusive compile locks. This counter’s value should follow in proportion to “Batch Requests/sec” and “SQL Compilations/ sec”. This needs to be nil in your system as much as possible.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | < 10% of the number of SQL Compila- tions/sec | 0.1                 | High recompilation rate.       |            5 |
| SQLServer:Access Methods  | Page Splits/sec           | Monitors the number of page splits per second which occur due to overflowing index pages and should be as low as possible. To avoid page splits, review table and index design to reduce non-sequential inserts or implement fillfactor and pad_index to leave more empty space per page. NOTE: A high value for this counter is not bad in situations where many new pages are being created, since it includes new page allocations.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | < 20 per 100 Batch Requests/Sec               | 0.2                 | High Page splits ratio.        |            6 |
| SQLServer:Access Methods  | Index Searches/sec        | Monitors the number of index searches when doing range scans, single index record fetches, and repositioning within an index. The threshold recommendation is strictly for OLTP workloads.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 1 Full Scan/sec per 1000 Index Searches/sec   | 0.001               | High Index Searches ratio.     |            7 |
| SQL Server:Buffer Manager | Free list stalls/sec      | Monitors the number of requests per second where data requests stall because no buffers are available. Any value above 2 means SQL Server needs more memory.number of requests per second where data requests stall because no buffers are available. Any value above 2 means SQL Server needs more memory.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | < 2                                           | 2                   | High Free list stalls ratio.   |            8 |
| SQL Server:Buffer Manager | Lazy writes/sec           | Monitors the number of times per second that the Lazy Writer process moves dirty pages from the buffer to disk as it frees up buffer space. Lower is better with zero being ideal. When greater than 20, this counter indicates a need for more memory.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | < 20                                          | 20                  | High number of Lazy writes/sec |            9 |
| SQL Server:Buffer Manager | Page reads/sec            | Number of physical database page reads issued per second. Normal OLTP workloads support 80 – 90 per second, but higher values may be a yellow flag for poor indexing or insufficient memory.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | < 90                                          | 90                  | High Parge read rate.          |           10 |


Table: ref_quick_download
| sql_instance   |
|:---------------|
| 1. All         |


Table: report_time



Table: Schedulers
| report_period_group     | sql_instance    |   current_tasks_count |   runnable_tasks_count |   pending_disk_io_count | report_time             |
|:------------------------|:----------------|----------------------:|-----------------------:|------------------------:|:------------------------|
| 2019-10-31 20:45:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-10-31 20:45:00.000 |
| 2019-11-01 02:45:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-11-01 02:45:00.000 |
| 2019-10-31 18:30:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-10-31 18:30:00.000 |
| 2019-10-31 11:15:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-10-31 11:15:00.000 |
| 2019-11-01 10:00:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-11-01 10:00:00.000 |
| 2019-11-01 04:30:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-11-01 04:30:00.000 |
| 2019-10-31 15:00:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-10-31 15:00:00.000 |
| 2019-11-01 06:30:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-11-01 06:30:00.000 |
| 2019-10-31 19:00:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-10-31 19:00:00.000 |
| 2019-11-01 09:00:00.000 | VM-YQRLSNOIWCJM |                    28 |                      0 |                       0 | 2019-11-01 09:00:00.000 |


Table: Server Issues
| issue                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |   impact | sql_instance_id   |
|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------:|:------------------|
| High compilation rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |      200 | VM-XKUTIEGROZAV   |
| Number of times that Transact-SQL compilations occurred, per second (including recompiles). The lower this value is the better. High values often indicate excessive adhoc querying and should be as low as possible. If excessive adhoc querying is happening, try rewriting the queries as procedures or invoke the queries using sp_ex- ecuteSQL. When rewriting isn’t possible, consider using a plan guide or setting the database to parameterization forced mode.                                                                                             |          |                   |
| High compilation rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |      200 | VM-YQRLSNOIWCJM   |
| Number of times that Transact-SQL compilations occurred, per second (including recompiles). The lower this value is the better. High values often indicate excessive adhoc querying and should be as low as possible. If excessive adhoc querying is happening, try rewriting the queries as procedures or invoke the queries using sp_ex- ecuteSQL. When rewriting isn’t possible, consider using a plan guide or setting the database to parameterization forced mode.                                                                                             |          |                   |
| High compilation rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |      200 | WIN-E8OB9B8SIQ2   |
| Number of times that Transact-SQL compilations occurred, per second (including recompiles). The lower this value is the better. High values often indicate excessive adhoc querying and should be as low as possible. If excessive adhoc querying is happening, try rewriting the queries as procedures or invoke the queries using sp_ex- ecuteSQL. When rewriting isn’t possible, consider using a plan guide or setting the database to parameterization forced mode.                                                                                             |          |                   |
| Low Buffer cache hit ratio.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |      200 | WIN-E8OB9B8SIQ2   |
| Long a stalwart counter used by SQL Server DBAs, this counter is no longer very useful. It monitors the percentage of data requests answer from the buffer cache since the last reboot. However, other counters are much better for showing current memory pressure that this one because it blows the curve. For example, PLE (page life expectancy) might suddenly drop from 2000 to 70, while buffer cache hit ration moves only from 98.2 to 98.1. Only be concerned by this counter if it’s value is regularly below 90 (for OLTP) or 80 (for very large OLAP). |          |                   |
| High Full Scan rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |      200 | VM-XKUTIEGROZAV   |
| Monitors the number of full scans on tables or indexes. Ignore unless high CPU coincides with high scan rates. High scan rates may be caused by missing indexes, very small tables, or requests for too many records. A sudden increase in this value may indicate a statistics threshold has been reached, resulting in an index no longer being used.                                                                                                                                                                                                              |          |                   |
| High Full Scan rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |      200 | VM-YQRLSNOIWCJM   |
| Monitors the number of full scans on tables or indexes. Ignore unless high CPU coincides with high scan rates. High scan rates may be caused by missing indexes, very small tables, or requests for too many records. A sudden increase in this value may indicate a statistics threshold has been reached, resulting in an index no longer being used.                                                                                                                                                                                                              |          |                   |
| High Full Scan rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |      200 | WIN-E8OB9B8SIQ2   |
| Monitors the number of full scans on tables or indexes. Ignore unless high CPU coincides with high scan rates. High scan rates may be caused by missing indexes, very small tables, or requests for too many records. A sudden increase in this value may indicate a statistics threshold has been reached, resulting in an index no longer being used.                                                                                                                                                                                                              |          |                   |
| High number of Lazy writes/sec                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |      200 | WIN-E8OB9B8SIQ2   |
| Monitors the number of times per second that the Lazy Writer process moves dirty pages from the buffer to disk as it frees up buffer space. Lower is better with zero being ideal. When greater than 20, this counter indicates a need for more memory.                                                                                                                                                                                                                                                                                                              |          |                   |
| High number of lock requests/sec.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |      200 | WIN-E8OB9B8SIQ2   |
| The number of new locks and locks converted per second. This metric’s value should generally correspond to “Batch Re- quests/sec”. Values > 1000 may indicate queries are accessing very large numbers of rows and may benefit from tuning.                                                                                                                                                                                                                                                                                                                          |          |                   |
| High Page lookup rate.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |      200 | VM-XKUTIEGROZAV   |
| The number of requests to find a page in the buffer pool. When the ratio of batch requests to page lookups crests 100, you may have inefficient execution plans or too many adhoc queries.                                                                                                                                                                                                                                                                                                                                                                           |          |                   |


Table: Time Groups
| report_period_group     |
|:------------------------|
| 2019-10-24 13:04:00.000 |
| 2019-10-24 13:05:00.000 |
| 2019-10-24 13:06:00.000 |
| 2019-10-24 13:07:00.000 |
| 2019-10-24 13:08:00.000 |
| 2019-10-24 13:09:00.000 |
| 2019-10-24 13:10:00.000 |
| 2019-10-24 13:11:00.000 |
| 2019-10-24 13:12:00.000 |
| 2019-10-24 13:13:00.000 |


Table: Wait Statistics
| wait_type                   |   wait_time_h |   wait_time_m | report_time             | sql_instance    |   waiting_tasks_count_delta |   wait_time_ms_delta | report_period_group     | wait_category   |
|:----------------------------|--------------:|--------------:|:------------------------|:----------------|----------------------------:|---------------------:|:------------------------|:----------------|
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-10-31 22:15:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-10-31 22:15:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-10-31 18:30:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-10-31 18:30:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-11-01 08:28:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-11-01 08:15:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-11-01 09:14:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-11-01 09:00:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-11-01 00:25:00.000 | WIN-E8OB9B8SIQ2 |                           1 |                    0 | 2019-11-01 00:15:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-10-31 13:46:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-10-31 13:45:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-10-31 22:22:00.000 | WIN-E8OB9B8SIQ2 |                           1 |                    0 | 2019-10-31 22:15:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-10-31 15:14:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-10-31 15:00:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-10-31 19:31:00.000 | VM-YQRLSNOIWCJM |                           1 |                    0 | 2019-10-31 19:30:00.000 | Other           |
| SESSION_WAIT_STATS_CHILDREN |             0 |             0 | 2019-11-01 04:09:00.000 | WIN-E8OB9B8SIQ2 |                           1 |                    0 | 2019-11-01 04:00:00.000 | Other           |


Table: WhoIsActive
|   sqlwatch_whoisactive_record_id | report_time             | start_time              |   session_id | status    | percent_complete   | host_name       | database_name              | program_name                                                              | sql_text                                                                                                                                   | sql_command      | login_name                |   open_tran_count | wait_info                                             | blocking_session_id   |   blocked_session_count |   CPU |   used_memory |   tempdb_current |   tempdb_allocations |   reads |   writes |   physical_reads | login_time              | sql_instance    | snapshot_time           | report_period_group     | wait_type      |   wait_time_ms | end_time                |   last_collection |   session_id_global |   lapsed_seconds | is_maintenance_task   | is_system_spid   |
|---------------------------------:|:------------------------|:------------------------|-------------:|:----------|:-------------------|:----------------|:---------------------------|:--------------------------------------------------------------------------|:-------------------------------------------------------------------------------------------------------------------------------------------|:-----------------|:--------------------------|------------------:|:------------------------------------------------------|:----------------------|------------------------:|------:|--------------:|-----------------:|---------------------:|--------:|---------:|-----------------:|:------------------------|:----------------|:------------------------|:------------------------|:---------------|---------------:|:------------------------|------------------:|--------------------:|-----------------:|:----------------------|:-----------------|
|                             4343 | 2019-10-31 15:30:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (517ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 28169 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:29:02.000 | 2019-10-31 15:30:00.000 | PAGEIOLATCH_SH |            517 | 2019-10-31 15:08:00.516 |                 0 |                1353 |             1262 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4340 | 2019-10-31 15:29:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (281ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 25593 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:28:46.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            281 | 2019-10-31 15:08:00.280 |                 0 |                1353 |             1246 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4337 | 2019-10-31 15:29:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (301ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 25365 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:28:31.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            301 | 2019-10-31 15:08:00.300 |                 0 |                1353 |             1231 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4332 | 2019-10-31 15:29:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (367ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 24985 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:28:16.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            367 | 2019-10-31 15:08:00.366 |                 0 |                1353 |             1216 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4327 | 2019-10-31 15:29:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (786ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 24564 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:28:02.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            786 | 2019-10-31 15:08:00.786 |                 0 |                1353 |             1202 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4325 | 2019-10-31 15:28:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (144ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 24365 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:27:46.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            144 | 2019-10-31 15:08:00.143 |                 0 |                1353 |             1186 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4323 | 2019-10-31 15:28:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (312ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 24148 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:27:31.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            312 | 2019-10-31 15:08:00.313 |                 0 |                1353 |             1171 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4320 | 2019-10-31 15:28:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (674ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 23929 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:27:16.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            674 | 2019-10-31 15:08:00.673 |                 0 |                1353 |             1156 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4317 | 2019-10-31 15:28:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (416ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 23629 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:27:01.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            416 | 2019-10-31 15:08:00.416 |                 0 |                1353 |             1141 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                             4315 | 2019-10-31 15:27:00.000 | 2019-10-31 15:08:00.870 |           54 | suspended |                    | WIN-E8OB9B8SIQ2 | StackOverflow2010_SlowDisk | SQLAgent - TSQL JobStep (Job 0xABF0F0E6E206324A805089D0CF1768B3 : Step 1) | <?query --                                                                                                                                 | <?query --       | NT SERVICE\SQLSERVERAGENT |                 0 | (690ms)PAGEIOLATCH_SH:StackOverflow2010_SlowDisk:1(*) |                       |                       0 | 23180 |          1683 |             8784 |                 8784 |       4 |        0 |                0 | 2019-10-31 15:08:00.860 | WIN-E8OB9B8SIQ2 | 2019-10-31 15:26:45.000 | 2019-10-31 15:15:00.000 | PAGEIOLATCH_SH |            690 | 2019-10-31 15:08:00.690 |                 0 |                1353 |             1125 | False                 | False            |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | SELECT                                                                                                                                     | exec usp_RandomQ |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            | --?>             |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | FROM                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts q                                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   INNER JOIN                                                                                                                               |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     Posts a ON q.AcceptedAnswerId = a.Id                                                                                                   |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | WHERE                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.OwnerUserId = @UserId                                                                                                                |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |   AND                                                                                                                                      |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |                                                                                                                                            |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           |     a.PostTypeId = 2                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |
|                                  |                         |                         |              |           |                    |                 |                            |                                                                           | --?>                                                                                                                                       |                  |                           |                   |                                                       |                       |                         |       |               |                  |                      |         |          |                  |                         |                 |                         |                         |                |                |                         |                   |                     |                  |                       |                  |


Table: XE IO Subsystem
| report_period_group     | sql_instance    | longest_pending_request_file   |   total_long_ios | report_time             | longest_pending_request_duration   |
|:------------------------|:----------------|:-------------------------------|-----------------:|:------------------------|:-----------------------------------|
| 2019-10-31 11:00:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 11:05:00.000 |                                    |
| 2019-10-31 11:15:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 11:15:00.000 |                                    |
| 2019-10-31 11:30:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 11:30:00.000 |                                    |
| 2019-10-31 11:45:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 11:45:00.000 |                                    |
| 2019-10-31 12:00:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 12:00:00.000 |                                    |
| 2019-10-31 12:15:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 12:15:00.000 |                                    |
| 2019-10-31 12:30:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 12:30:00.000 |                                    |
| 2019-10-31 12:45:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 12:45:00.000 |                                    |
| 2019-10-31 13:00:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 13:00:00.000 |                                    |
| 2019-10-31 13:15:00.000 | VM-XKUTIEGROZAV |                                |                0 | 2019-10-31 13:15:00.000 |                                    |


Table: XE Query Processing
| report_period_group     | sql_instance    |   max_workers |   workers_created |   idle_workers |   pending_tasks | report_time             |
|:------------------------|:----------------|--------------:|------------------:|---------------:|----------------:|:------------------------|
| 2019-10-31 20:45:00.000 | VM-YQRLSNOIWCJM |           512 |           69      |        33.6667 |               0 | 2019-10-31 20:48:00.000 |
| 2019-11-01 02:45:00.000 | VM-YQRLSNOIWCJM |           512 |           68.6667 |        33.3333 |               0 | 2019-11-01 02:48:00.000 |
| 2019-10-31 14:00:00.000 | VM-XKUTIEGROZAV |           512 |           71      |        33      |               0 | 2019-10-31 14:00:00.000 |
| 2019-10-31 18:30:00.000 | VM-YQRLSNOIWCJM |           512 |           68      |        33      |               0 | 2019-10-31 18:33:00.000 |
| 2019-10-31 20:30:00.000 | WIN-E8OB9B8SIQ2 |           512 |           63      |        28      |               0 | 2019-10-31 20:32:00.000 |
| 2019-10-31 21:00:00.000 | VM-XKUTIEGROZAV |           512 |           79.6667 |        42.3333 |               0 | 2019-10-31 21:00:00.000 |
| 2019-10-31 11:45:00.000 | WIN-E8OB9B8SIQ2 |           512 |           80.3333 |        40.6667 |               0 | 2019-10-31 11:47:00.000 |
| 2019-10-31 12:00:00.000 | WIN-E8OB9B8SIQ2 |           512 |           80      |        29.3333 |               0 | 2019-10-31 12:02:00.000 |
| 2019-11-01 08:30:00.000 | VM-YQRLSNOIWCJM |           512 |           69      |        34      |               0 | 2019-11-01 08:33:00.000 |
| 2019-11-01 09:30:00.000 | VM-XKUTIEGROZAV |           512 |           92.3333 |        54.3333 |               0 | 2019-11-01 09:30:00.000 |


Table: XE Query Waits
| event_time              |   session_id | wait_type      |   duration |   signal_duration | wait_resource   | sql_text         | report_time             | activity_id                          |   activity_sequence | username   | database_name              | client_hostname   | client_app_name                                                           | activity_id_xfer   | activity_seqeuence_xfer   | event_name   | sql_instance    |   sqlwatch_activity_id | snapshot_time           |   snapshot_type_id | report_period_group     | wait_category   |
|:------------------------|-------------:|:---------------|-----------:|------------------:|:----------------|:-----------------|:------------------------|:-------------------------------------|--------------------:|:-----------|:---------------------------|:------------------|:--------------------------------------------------------------------------|:-------------------|:--------------------------|:-------------|:----------------|-----------------------:|:------------------------|-------------------:|:------------------------|:----------------|
| 2019-11-01 08:43:54.420 |           56 | PAGEIOLATCH_SH |       1415 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 152 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16668 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:43:55.776 |           56 | PAGEIOLATCH_SH |       1354 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 153 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16676 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:43:57.016 |           56 | PAGEIOLATCH_SH |       1241 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 154 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16684 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:43:58.136 |           56 | PAGEIOLATCH_SH |       1117 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 155 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16690 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:43:59.206 |           56 | PAGEIOLATCH_SH |       1069 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 156 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16695 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:44:00.276 |           56 | PAGEIOLATCH_SH |       1069 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 157 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16703 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:44:01.486 |           56 | PAGEIOLATCH_SH |       1206 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 158 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16704 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:44:03.776 |           56 | PAGEIOLATCH_SH |       1080 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 159 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16715 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:44:06.080 |           56 | PAGEIOLATCH_SH |       1039 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 161 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16730 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |
| 2019-11-01 08:44:07.926 |           56 | PAGEIOLATCH_SH |       1845 |                 0 |                 | exec usp_RandomQ | 2019-11-01 08:45:00.000 | B3A367FF-4139-4B6B-A39A-664D8DCEC8C2 |                 162 |            | StackOverflow2010_SlowDisk | WIN-E8OB9B8SIQ2   | SQLAgent - TSQL JobStep (Job 0xF6A18FFD0F33144CA654A9ADA8E30413 : Step 1) |                    |                           | wait_info    | WIN-E8OB9B8SIQ2 |                  16738 | 2019-11-01 08:44:14.000 |                  6 | 2019-11-01 08:45:00.000 | Buffer I/O      |

 


tables: name: Agent History
data: Agent History.csv
name: Blockers
data: Blockers.csv
name: Dim Agent Job Steps
data: Dim Agent Job Steps.csv
name: Dim Agent Jobs
data: Dim Agent Jobs.csv
name: Dim Database
data: Dim Database.csv
name: Dim Environment
data: Dim Environment.csv
name: Dim Index
data: Dim Index.csv
name: Dim Master File
data: Dim Master File.csv
name: Dim Missing Index
data: Dim Missing Index.csv
name: Dim OS Volume
data: Dim OS Volume.csv
name: Dim Server
data: Dim Server.csv
name: Dim Table
data: Dim Table.csv
name: Dim Time
data: Dim Time.csv
name: Disk Utilisation DB
data: Disk Utilisation DB.csv
name: Disk Utilisation OS
data: Disk Utilisation OS.csv
name: File Statistics Sankey Database to File
data: File Statistics Sankey Database to File.csv
name: File Statistics Sankey File to Disk
data: File Statistics Sankey File to Disk.csv
name: File Statistics
data: File Statistics.csv
name: fn_get_end_time
data: fn_get_end_time.csv
name: Index Histogram
data: Index Histogram.csv
name: Index Statistics
data: Index Statistics.csv
name: Memory Clerks
data: Memory Clerks.csv
name: Missing Index Stats
data: Missing Index Stats.csv
name: Performance Counters
data: Performance Counters.csv
name: Process Memory
data: Process Memory.csv
name: ref_agent_run_status
data: ref_agent_run_status.csv
name: ref_file_type
data: ref_file_type.csv
name: ref_index_status
data: ref_index_status.csv
name: ref_index_type
data: ref_index_type.csv
name: ref_metric_description
data: ref_metric_description.csv
name: ref_percentage_range
data: ref_percentage_range.csv
name: ref_perf_counters_poster
data: ref_perf_counters_poster.csv
name: ref_quick_download
data: ref_quick_download.csv
name: report_time
data: report_time.csv
name: Schedulers
data: Schedulers.csv
name: Server Issues
data: Server Issues.csv
name: Time Groups
data: Time Groups.csv
name: Wait Statistics
data: Wait Statistics.csv
name: WhoIsActive
data: WhoIsActive.csv
name: XE IO Subsystem
data: XE IO Subsystem.csv
name: XE Query Processing
data: XE Query Processing.csv
name: XE Query Waits
data: XE Query Waits.csv
label: Performance Counters
counter_name
ref_perf_counters_poster
counter_name
Dim Server
environment
Dim Environment
Environment
Wait Statistics
sql_instance
Dim Server
sql_instance
Performance Counters
sql_instance
Dim Server
sql_instance
Dim Time
report_period_group
Time Groups
report_period_group
Performance Counters
report_time
Dim Time
report_time
Wait Statistics
report_time
Dim Time
report_time
Process Memory
report_time
Dim Time
report_time
Process Memory
sql_instance
Dim Server
sql_instance
File Statistics
report_time
Dim Time
report_time
Memory Clerks
sql_instance
Dim Server
sql_instance
Memory Clerks
report_time
Dim Time
report_time
Schedulers
sql_instance
Dim Server
sql_instance
Schedulers
report_time
Dim Time
report_time
Dim Database
sql_instance_id
Dim Server
sql_instance
Dim Master File
pbi_database_id
Dim Database
pbi_database_id
File Statistics
pbi_master_file_id
Dim Master File
pbi_master_file_id
XE IO Subsystem
sql_instance
Dim Server
sql_instance
XE IO Subsystem
report_time
Dim Time
report_time
Dim Table
pbi_database_id
Dim Database
pbi_database_id
Dim Index
pbi_table_id
Dim Table
pbi_table_id
Dim Master File
file_type
ref_file_type
file_type
XE Query Processing
sql_instance
Dim Server
sql_instance
XE Query Waits
sql_instance
Dim Server
sql_instance
XE Query Waits
report_time
Dim Time
report_time
XE Query Processing
report_time
Dim Time
report_time
Blockers
sql_instance
Dim Server
sql_instance
Blockers
report_time
Dim Time
report_time
WhoIsActive
sql_instance
Dim Server
sql_instance
WhoIsActive
report_time
Dim Time
report_time
Dim Agent Jobs
sql_instance
Dim Server
sql_instance
Dim Agent Job Steps
pbi_job_id
Dim Agent Jobs
pbi_job_id
Agent History
report_time
Dim Time
report_time
Agent History
run_status
ref_agent_run_status
run_status
Agent History
pbi_job_step_id
Dim Agent Job Steps
pbi_job_step_id
Index Statistics
report_time
Dim Time
report_time
Index Statistics
pbi_index_id
Dim Index
pbi_index_id
Index Histogram
pbi_index_id
Dim Index
pbi_index_id
Dim Missing Index
pbi_table_id
Dim Table
pbi_table_id
Missing Index Stats
report_time
Dim Time
report_time
Dim OS Volume
sql_instance
Dim Server
sql_instance
Disk Utilisation OS
pbi_volume_id
Dim OS Volume
pbi_volume_id
Missing Index Stats
pbi_missing_index_id
Dim Missing Index
pbi_missing_index_id
Disk Utilisation DB
pbi_database_id
Dim Database
pbi_database_id
Disk Utilisation DB
report_time
Dim Time
report_time
File Statistics Sankey Database to File
pbi_master_file_id
Dim Master File
pbi_master_file_id
output: {
    "joins": [
        {
            "from_table": "Performance Counters",
            "from_column": "counter_name",
            "to_table": "ref_perf_counters_poster",
            "to_column": "counter_name"
        },
        {
            "from_table": "Dim Server",
            "from_column": "environment",
            "to_table": "Dim Environment",
            "to_column": "Environment"
        },
        {
            "from_table": "Wait Statistics",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Performance Counters",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Dim Time",
            "from_column": "report_period_group",
            "to_table": "Time Groups",
            "to_column": "report_period_group"
        },
        {
            "from_table": "Performance Counters",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Wait Statistics",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Process Memory",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Process Memory",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "File Statistics",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Memory Clerks",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Memory Clerks",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Schedulers",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Schedulers",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Dim Database",
            "from_column": "sql_instance_id",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Dim Master File",
            "from_column": "pbi_database_id",
            "to_table": "Dim Database",
            "to_column": "pbi_database_id"
        },
        {
            "from_table": "File Statistics",
            "from_column": "pbi_master_file_id",
            "to_table": "Dim Master File",
            "to_column": "pbi_master_file_id"
        },
        {
            "from_table": "XE IO Subsystem",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "XE IO Subsystem",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Dim Table",
            "from_column": "pbi_database_id",
            "to_table": "Dim Database",
            "to_column": "pbi_database_id"
        },
        {
            "from_table": "Dim Index",
            "from_column": "pbi_table_id",
            "to_table": "Dim Table",
            "to_column": "pbi_table_id"
        },
        {
            "from_table": "Dim Master File",
            "from_column": "file_type",
            "to_table": "ref_file_type",
            "to_column": "file_type"
        },
        {
            "from_table": "XE Query Processing",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "XE Query Waits",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "XE Query Waits",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "XE Query Processing",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Blockers",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Blockers",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "WhoIsActive",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "WhoIsActive",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Dim Agent Jobs",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Dim Agent Job Steps",
            "from_column": "pbi_job_id",
            "to_table": "Dim Agent Jobs",
            "to_column": "pbi_job_id"
        },
        {
            "from_table": "Agent History",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Agent History",
            "from_column": "run_status",
            "to_table": "ref_agent_run_status",
            "to_column": "run_status"
        },
        {
            "from_table": "Agent History",
            "from_column": "pbi_job_step_id",
            "to_table": "Dim Agent Job Steps",
            "to_column": "pbi_job_step_id"
        },
        {
            "from_table": "Index Statistics",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Index Statistics",
            "from_column": "pbi_index_id",
            "to_table": "Dim Index",
            "to_column": "pbi_index_id"
        },
        {
            "from_table": "Index Histogram",
            "from_column": "pbi_index_id",
            "to_table": "Dim Index",
            "to_column": "pbi_index_id"
        },
        {
            "from_table": "Dim Missing Index",
            "from_column": "pbi_table_id",
            "to_table": "Dim Table",
            "to_column": "pbi_table_id"
        },
        {
            "from_table": "Missing Index Stats",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "Dim OS Volume",
            "from_column": "sql_instance",
            "to_table": "Dim Server",
            "to_column": "sql_instance"
        },
        {
            "from_table": "Disk Utilisation OS",
            "from_column": "pbi_volume_id",
            "to_table": "Dim OS Volume",
            "to_column": "pbi_volume_id"
        },
        {
            "from_table": "Missing Index Stats",
            "from_column": "pbi_missing_index_id",
            "to_table": "Dim Missing Index",
            "to_column": "pbi_missing_index_id"
        },
        {
            "from_table": "Disk Utilisation DB",
            "from_column": "pbi_database_id",
            "to_table": "Dim Database",
            "to_column": "pbi_database_id"
        },
        {
            "from_table": "Disk Utilisation DB",
            "from_column": "report_time",
            "to_table": "Dim Time",
            "to_column": "report_time"
        },
        {
            "from_table": "File Statistics Sankey Database to File",
            "from_column": "pbi_master_file_id",
            "to_table": "Dim Master File",
            "to_column": "pbi_master_file_id"
        }
    ]
}