<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <Body>
    <ReportItems>
      <Textbox Name="Textbox1">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="1. Create AdminMonitor Database"</Value>
                <Style>
                  <FontSize>24pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox1</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDoNotOpenCreateAdminMonitorDB</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>3.12975in</Top>
        <Left>0.505in</Left>
        <Height>0.425in</Height>
        <Width>10.08333in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox2">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>2. Create Tables</Value>
                <Style>
                  <FontSize>24pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox2</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDoNotOpenCreateMonitorTables</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>3.75254in</Top>
        <Left>0.505in</Left>
        <Height>0.425in</Height>
        <Width>10.08333in</Width>
        <ZIndex>1</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox3">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>3. Create Stored Procedures</Value>
                <Style>
                  <FontSize>24pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox3</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDoNotOpenCreateStoredProcs</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>4.37533in</Top>
        <Left>0.505in</Left>
        <Height>0.425in</Height>
        <Width>10.08333in</Width>
        <ZIndex>2</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox4">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>6. Create Monitor Jobs</Value>
                <Style>
                  <FontSize>24pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox4</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDoNotOpenCreateJobs</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>7.29369in</Top>
        <Left>0.52167in</Left>
        <Height>0.425in</Height>
        <Width>10.08333in</Width>
        <ZIndex>3</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox5">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="Create Monitoring Objects on " &amp; First(Fields!ServerName.Value, "ServerName")</Value>
                <Style>
                  <FontSize>48pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox5</rd:DefaultName>
        <Top>0.14667in</Top>
        <Left>0.505in</Left>
        <Height>1.10833in</Height>
        <Width>10.08333in</Width>
        <ZIndex>4</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox6">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>You must be a member of the SysAdmin Server role in order to run these scripts</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox6</rd:DefaultName>
        <Top>2.10696in</Top>
        <Left>0.505in</Left>
        <Height>0.825in</Height>
        <Width>10.08333in</Width>
        <ZIndex>5</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>LightSteelBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox7">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!NumberofRows.Value, "BlockingExists") = 0, "Click on each button in order, 1 - 12 to create all the required objects", "Click on each button in order, 1 - 12 to create all the required objects")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox6</rd:DefaultName>
        <Top>1.45279in</Top>
        <Left>0.505in</Left>
        <Height>0.45639in</Height>
        <Width>10.08333in</Width>
        <ZIndex>6</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>LightSteelBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox8">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Back to Report Library</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox8</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>ReportLibrary</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>14.4554in</Top>
        <Left>0.52167in</Left>
        <Height>0.525in</Height>
        <Width>10.08333in</Width>
        <ZIndex>7</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>LightSteelBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox9">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Directions</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox9</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDirections</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>15.17819in</Top>
        <Left>0.52167in</Left>
        <Height>0.525in</Height>
        <Width>10.08333in</Width>
        <ZIndex>8</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>LightSteelBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox10">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>4. Enter Counter and Wait Information</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox8</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDoNotOpenInsertMonitorData</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>4.99811in</Top>
        <Left>0.505in</Left>
        <Height>0.425in</Height>
        <Width>10.08333in</Width>
        <ZIndex>9</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox12">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!EEFolderExists.Value, "EEPathInTable") = 0, "7. The Extended Events Folder is not in the AdminMonitor.dbo.Config table or the AdminMonitor database does not exist, Click to get directions", IIF(Sum(Fields!config_value.Value, "CheckToSeeIfXPcmdIsEnabled")=0, "7. XP_cmdshell is not Enabled, please enable or create the folder manually.  If created, enter into the Config table.","7. Create Extended Events folder for the File Targets"))</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!config_value.Value, "CheckToSeeIfXPcmdIsEnabled")=0,"DarkGray","DarkBlue")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox8</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(Sum(Fields!EEFolderExists.Value, "EEPathInTable") = 0, "MonitorAddEEpathToConfigTable",IIF(Sum(Fields!config_value.Value, "CheckToSeeIfXPcmdIsEnabled")=0,Nothing,"MonitorWarningCreateEEFolder"))</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>7.91648in</Top>
        <Left>0.53834in</Left>
        <Height>0.98333in</Height>
        <Width>10.08333in</Width>
        <ZIndex>10</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox13">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!NumberofRows.Value, "DeadlockExists") = 0, "8. Deploy Deadlock Extended Event Session", "8. Deadlock Session Already Exists")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!NumberofRows.Value, "DeadlockExists") = 0, "DarkBlue", "DarkGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox13</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(Sum(Fields!NumberofRows.Value, "DeadlockExists") = 0, "MonitorDONOTOPENCreateDeadlockExtEvSession", NOthing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>10.31205in</Top>
        <Left>0.53834in</Left>
        <Height>1.18333in</Height>
        <Width>4.9in</Width>
        <ZIndex>11</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox15">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!NumberofRows.Value, "BlockingExists") = 0, "9. Deploy Blocking Report Extended Event Session","9. Blocking Session Already Exists")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!NumberofRows.Value, "BlockingExists")= 0, "DarkBlue", "DarkGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox13</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(Sum(Fields!NumberofRows.Value, "BlockingExists") = 0, "MonitorDONOTOPENCreateBlockingExtEvSession", NOthing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>10.26731in</Top>
        <Left>5.69667in</Left>
        <Height>1.18333in</Height>
        <Width>4.925in</Width>
        <ZIndex>12</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox16">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!NumberofRows.Value, "DroppedLoginExists") = 0,"10. Deploy Deleted Login Report Extended Event Session", "10. Deleted Login Session Already Exists.")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!NumberofRows.Value, "DroppedLoginExists") = 0, "DarkBlue", "DarkGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox13</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDONOTOPENCreateDeletedLoginEESession</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>11.69317in</Top>
        <Left>0.53834in</Left>
        <Height>1.18333in</Height>
        <Width>4.9in</Width>
        <ZIndex>13</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox17">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!NumberofRows.Value, "DroppedDBUserExists") = 0, "11. Deploy Deleted Database User Report Extended Event Session", "11. Deleted DB User Session Already Exists")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!NumberofRows.Value, "DroppedDBUserExists") = 0, "DarkBlue","DarkGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox13</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(Sum(Fields!NumberofRows.Value, "DroppedDBUserExists") = 0, "MonitorDONOTOPENCreateDeletedDBUsersEESession", Nothing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>11.67386in</Top>
        <Left>5.69667in</Left>
        <Height>1.18333in</Height>
        <Width>4.925in</Width>
        <ZIndex>14</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox11">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Below buttons deploy the Extended Events part of the solution.  None of which are required.  However if you do not deployment, you must disable the corresponding job, if you don't, the jobs will fail.</Value>
                <Style>
                  <FontSize>18pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox11</rd:DefaultName>
        <Top>9.09759in</Top>
        <Left>0.53834in</Left>
        <Height>1.01667in</Height>
        <Width>10.06666in</Width>
        <ZIndex>15</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>LightSteelBlue</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox18">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=Microsoft.VisualBasic.Interaction.IIF(Sum(Fields!NumberofRows.Value, "QueryTimeoutExists") = 0, "12. Deploy Query Timeout Extended Event Session", "12. Query Timeout Session Already Exists.")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!NumberofRows.Value, "QueryTimeoutExists") = 0, "DarkBlue", "DarkGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox13</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorDONOTOPENCreateQueryTimeoutExtEvSession</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>13.07428in</Top>
        <Left>0.53834in</Left>
        <Height>1.18333in</Height>
        <Width>10.06666in</Width>
        <ZIndex>16</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox14">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="5. Check File path in the Config table, it will be set to 'C:\ExtendedEvents'.  If this is not the desired path, please change in the Config table before moving on to the next step."</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>DarkBlue</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox14</rd:DefaultName>
        <Top>5.6209in</Top>
        <Left>0.505in</Left>
        <Height>1.475in</Height>
        <Width>10.08333in</Width>
        <ZIndex>17</ZIndex>
        <ToolTip>="This path will be used to create the Extended Events file target folder, when the Extended Events sessions are created and for the jobs that read from the files."</ToolTip>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>Silver</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>6pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
    </ReportItems>
    <Height>15.96637in</Height>
    <Style>
      <Border>
        <Style>None</Style>
      </Border>
      <BackgroundColor>DarkBlue</BackgroundColor>
    </Style>
  </Body>
  <Width>11.1025in</Width>
  <Page>
    <PageHeight>455in</PageHeight>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="CreateDB">
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=LocalHost;Initial Catalog=master</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
      <rd:SecurityType>Integrated</rd:SecurityType>
      <rd:DataSourceID>e72421b4-cec9-496a-b970-5f5984f3a0fa</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="ServerName">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>Select @@servername AS 'ServerName'</CommandText>
      </Query>
      <Fields>
        <Field Name="ServerName">
          <DataField>ServerName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="DeadlockExists">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>SELECT   Count(*) AS 'NumberofRows'
FROM msdb.sys.dm_xe_session_targets t
	INNER JOIN msdb.sys.dm_xe_sessions S
		ON T.event_session_address = S.ADDRESS
	INNER JOIN msdb.sys.dm_xe_session_events e
		ON s.address = e.event_session_address
WHERE s.name IN ( 'Deadlocks') </CommandText>
      </Query>
      <Fields>
        <Field Name="NumberofRows">
          <DataField>NumberofRows</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="BlockingExists">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>SELECT   Count(*) AS 'NumberofRows'
FROM msdb.sys.dm_xe_session_targets t
	INNER JOIN msdb.sys.dm_xe_sessions S
		ON T.event_session_address = S.ADDRESS
	INNER JOIN msdb.sys.dm_xe_session_events e
		ON s.address = e.event_session_address
WHERE s.name IN ( 'BlockedProcess') and e.event_name
	IN ('blocked_process_report')</CommandText>
      </Query>
      <Fields>
        <Field Name="NumberofRows">
          <DataField>NumberofRows</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="EEPathInTable">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>DECLARE @value TINYINT

select @value = Count(name) 
from sysdatabases
where name = 'adminmonitor'

If @value = 0
	BEGIN
		SELECT  0 AS 'EEFolderExists'
	END
ELSE
	BEGIN

SELECT @value = Count(name) from adminmonitor.sys.tables
where name = 'config'

IF @value = 0
	BEGIN
		select 2 AS 'EEFolderExists'
	END
ELSE
BEGIN
SELECT  Count(Configvalue) AS 'EEFolderExists'
FROM AdminMonitor.[dbo].[Config]
WHERE [ConfigTitle] = 'ExtendedEventFolder'
	AND Active = 1
END
END</CommandText>
      </Query>
      <Fields>
        <Field Name="EEFolderExists">
          <DataField>EEFolderExists</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="DatabaseExists">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>select Count(name) AS 'EEFolderExists'
from sysdatabases
where name = 'adminmonitor'</CommandText>
      </Query>
      <Fields>
        <Field Name="EEFolderExists">
          <DataField>EEFolderExists</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="CheckToSeeIfXPcmdIsEnabled">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>SELECT CONVERT(INT, ISNULL(value, value_in_use)) AS config_value
FROM  sys.configurations
WHERE  name = 'xp_cmdshell'</CommandText>
      </Query>
      <Fields>
        <Field Name="config_value">
          <DataField>config_value</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="DroppedLoginExists">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>SELECT   Count(*) AS 'NumberofRows'
FROM msdb.sys.dm_xe_session_targets t
	INNER JOIN msdb.sys.dm_xe_sessions S
		ON T.event_session_address = S.ADDRESS
	INNER JOIN msdb.sys.dm_xe_session_events e
		ON s.address = e.event_session_address
WHERE s.name IN ( 'DropLogin') and e.event_name
	IN ('sql_statement_completed')</CommandText>
      </Query>
      <Fields>
        <Field Name="NumberofRows">
          <DataField>NumberofRows</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="DroppedDBUserExists">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>SELECT   Count(*) AS 'NumberofRows'
FROM msdb.sys.dm_xe_session_targets t
	INNER JOIN msdb.sys.dm_xe_sessions S
		ON T.event_session_address = S.ADDRESS
	INNER JOIN msdb.sys.dm_xe_session_events e
		ON s.address = e.event_session_address
WHERE s.name IN ( 'DropUser') and e.event_name
	IN ('sql_statement_completed')</CommandText>
      </Query>
      <Fields>
        <Field Name="NumberofRows">
          <DataField>NumberofRows</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="QueryTimeoutExists">
      <Query>
        <DataSourceName>CreateDB</DataSourceName>
        <CommandText>SELECT   Count(*) AS 'NumberofRows'
FROM msdb.sys.dm_xe_session_targets t
	INNER JOIN msdb.sys.dm_xe_sessions S
		ON T.event_session_address = S.ADDRESS
	INNER JOIN msdb.sys.dm_xe_session_events e
		ON s.address = e.event_session_address
WHERE s.name IN ( 'QueryTimeOut(Attention Event)') and e.event_name
	IN ('attention')</CommandText>
      </Query>
      <Fields>
        <Field Name="NumberofRows">
          <DataField>NumberofRows</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>1a2b1ea9-b1f3-430c-978b-b62d3314434f</rd:ReportID>
</Report>