PSFirstResponderKit.Format.ps1xml
|
<?xml version="1.0" encoding="utf-8" ?>
<Configuration> <Controls> <Control> <Name>BlitzAnalysis-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Server Name : </Text> <ExpressionBinding> <PropertyName>ServerName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>BlitzAnalysisCache-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Server Name : </Text> <ExpressionBinding> <PropertyName>ServerName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Check Date : </Text> <ExpressionBinding> <PropertyName>CheckDate</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Sort Order : </Text> <ExpressionBinding> <PropertyName>SortOrder</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>BlitzAnalysisFileStats-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Server Name : </Text> <ExpressionBinding> <PropertyName>ServerName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Physical Path : </Text> <ExpressionBinding> <PropertyName>PhysicalPath</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>BlitzAnalysisWaitStats-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Server Name : </Text> <ExpressionBinding> <PropertyName>ServerName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Check Date : </Text> <ExpressionBinding> <PropertyName>CheckDate</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>BlitzFirst-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>SQL Instance Name : </Text> <ExpressionBinding> <PropertyName>ServerInstance</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Version : </Text> <ExpressionBinding> <ScriptBlock>$_.BlitzVersion.Version</ScriptBlock> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Version Date : </Text> <ExpressionBinding> <ScriptBlock>$_.BlitzVersion.VersionDate</ScriptBlock> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>FileStats-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Pattern : </Text> <ExpressionBinding> <PropertyName>Pattern</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Sample Time : </Text> <ExpressionBinding> <PropertyName>SampleTime</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>PerfmonStats-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Pattern : </Text> <ExpressionBinding> <PropertyName>Pattern</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Object Name : </Text> <ExpressionBinding> <PropertyName>object_name</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Counter Name : </Text> <ExpressionBinding> <PropertyName>counter_name</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>WaitStats-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Pattern : </Text> <ExpressionBinding> <PropertyName>Pattern</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Sample Ended : </Text> <ExpressionBinding> <PropertyName>SampleEnded</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Seconds Sample : </Text> <ExpressionBinding> <PropertyName>SecondsSample</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Total Thread Time (s) : </Text> <ExpressionBinding> <PropertyName>TotalThreadTime</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>WaitStatsSinceStartup-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Pattern : </Text> <ExpressionBinding> <PropertyName>Pattern</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Sample Ended : </Text> <ExpressionBinding> <PropertyName>SampleEnded</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Hours Sample : </Text> <ExpressionBinding> <PropertyName>HoursSample</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Thread Time (h) : </Text> <ExpressionBinding> <PropertyName>ThreadTime</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> </Controls> <ViewDefinitions> <View> <Name>Blitz-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.Blitz</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzFirst-GroupingFormat</CustomControlName> <PropertyName>ServerInstance</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Priority</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>FindingsGroup</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Finding</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>URL</Label> <Width>40</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Check ID</Label> <Width>5</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>Priority</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FindingsGroup</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Finding</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>URL</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>CheckID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>Blitz-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.Blitz</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Priority</Label> <PropertyName>Priority</PropertyName> </ListItem> <ListItem> <Label>Findings Group</Label> <PropertyName>FindingsGroup</PropertyName> </ListItem> <ListItem> <Label>Finding</Label> <PropertyName>Finding</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>URL</Label> <PropertyName>URL</PropertyName> </ListItem> <ListItem> <Label>Details</Label> <PropertyName>Details</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>QueryPlan</PropertyName> </ListItem> <ListItem> <Label>Query Plan Filtered</Label> <PropertyName>QueryPlanFiltered</PropertyName> </ListItem> <ListItem> <Label>Check ID</Label> <PropertyName>CheckID</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysis-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysis</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzFirst-GroupingFormat</CustomControlName> <PropertyName>ServerInstance</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Server To Report On</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Priorities To Include</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Start DateTime</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>End DateTime</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>ServerToReportOn</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PrioritesToInclude</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>StartDateTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>EndDateTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysis-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysis</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Server To Report On</Label> <PropertyName>ServerToReportOn</PropertyName> </ListItem> <ListItem> <Label>Priorities To Include</Label> <PropertyName>PrioritesToInclude</PropertyName> </ListItem> <ListItem> <Label>Start DateTime</Label> <PropertyName>StartDateTime</PropertyName> </ListItem> <ListItem> <Label>End DateTime</Label> <PropertyName>EndDateTime</PropertyName> </ListItem> <ListItem> <Label>BlitzFirst Summary</Label> <PropertyName>BlitzFirstSummary</PropertyName> </ListItem> <ListItem> <Label>BlitzFirst</Label> <PropertyName>BlitzFirst</PropertyName> </ListItem> <ListItem> <Label>Wait Stats</Label> <PropertyName>WaitStats</PropertyName> </ListItem> <ListItem> <Label>File Stats</Label> <PropertyName>FileStats</PropertyName> </ListItem> <ListItem> <Label>Perfmon Stats</Label> <PropertyName>PerfmonStats</PropertyName> </ListItem> <ListItem> <Label>BlitzCache</Label> <PropertyName>BlitzCache</PropertyName> </ListItem> <ListItem> <Label>BlitzWho</Label> <PropertyName>BlitzWho</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisCache-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisCache</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzAnalysisCache-GroupingFormat</CustomControlName> <ScriptBlock>$($_.CheckDate.Ticks.ToString() + '&' + $_.SortOrder)</ScriptBlock> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Database Name</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Average CPU</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total CPU</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Average Duration (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total Duration (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Average Reads</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total Reads</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Average Writes</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total Writes</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Execution Count</Label> <Width>9</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Execution Weight</Label> <Width>9</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Executions per Minute</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AverageCPU</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalCPU</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AverageDuration</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalDuration</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AverageReads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalReads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AverageWrites</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalWrites</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ExecutionCount</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ExecutionWeight</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ExecutionsPerMinute</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisCache-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisCache</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Name</Label> <PropertyName>ServerName</PropertyName> </ListItem> <ListItem> <Label>Check Date</Label> <PropertyName>CheckDate</PropertyName> </ListItem> <ListItem> <Label>Sort Order</Label> <PropertyName>SortOrder</PropertyName> </ListItem> <ListItem> <Label>Time Frame Rank</Label> <PropertyName>TimeFrameRank</PropertyName> </ListItem> <ListItem> <Label>Overall Rank</Label> <PropertyName>OverallRank</PropertyName> </ListItem> <ListItem> <Label>Query Type</Label> <PropertyName>QueryType</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>QueryText</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Average CPU</Label> <PropertyName>AverageCPU</PropertyName> </ListItem> <ListItem> <Label>Total CPU</Label> <PropertyName>TotalCPU</PropertyName> </ListItem> <ListItem> <Label>Percent CPU By Type</Label> <PropertyName>PercentCPUByType</PropertyName> </ListItem> <ListItem> <Label>Average Duration (ms)</Label> <PropertyName>AverageDuration</PropertyName> </ListItem> <ListItem> <Label>Total Duration (ms)</Label> <PropertyName>TotalDuration</PropertyName> </ListItem> <ListItem> <Label>Percent Duration By Type</Label> <PropertyName>PercentDurationByType</PropertyName> </ListItem> <ListItem> <Label>Average Reads</Label> <PropertyName>AverageReads</PropertyName> </ListItem> <ListItem> <Label>Total Reads</Label> <PropertyName>TotalReads</PropertyName> </ListItem> <ListItem> <Label>Percent Reads By Type</Label> <PropertyName>PercentReadsByType</PropertyName> </ListItem> <ListItem> <Label>Average Writes</Label> <PropertyName>AverageWrites</PropertyName> </ListItem> <ListItem> <Label>Total Writes</Label> <PropertyName>TotalWrites</PropertyName> </ListItem> <ListItem> <Label>Percent Writes By Type</Label> <PropertyName>PercentWritesByType</PropertyName> </ListItem> <ListItem> <Label>Execution Count</Label> <PropertyName>ExecutionCount</PropertyName> </ListItem> <ListItem> <Label>Execution Weight</Label> <PropertyName>ExecutionWeight</PropertyName> </ListItem> <ListItem> <Label>Percent Executions By Type</Label> <PropertyName>PercentExecutionsByType</PropertyName> </ListItem> <ListItem> <Label>Executions Per Minute</Label> <PropertyName>ExecutionsPerMinute</PropertyName> </ListItem> <ListItem> <Label>Plan Creation Time</Label> <PropertyName>PlanCreationTime</PropertyName> </ListItem> <ListItem> <Label>Plan Creation Time (Hours)</Label> <PropertyName>PlanCreationTimeHours</PropertyName> </ListItem> <ListItem> <Label>Last Execution Time</Label> <PropertyName>LastExecutionTime</PropertyName> </ListItem> <ListItem> <Label>Plan Handle</Label> <PropertyName>PlanHandle</PropertyName> </ListItem> <ListItem> <Label>SQL Handle</Label> <PropertyName>SqlHandle</PropertyName> </ListItem> <ListItem> <Label>SQL Handle More Information</Label> <PropertyName>SQLHandleMoreInfo</PropertyName> </ListItem> <ListItem> <Label>Query Hash</Label> <PropertyName>QueryHash</PropertyName> </ListItem> <ListItem> <Label>Query Hash More Information</Label> <PropertyName>QueryHashMoreInfo</PropertyName> </ListItem> <ListItem> <Label>Query Plan Hash</Label> <PropertyName>QueryPlanHash</PropertyName> </ListItem> <ListItem> <Label>Statement Start Offset</Label> <PropertyName>StatementStartOffset</PropertyName> </ListItem> <ListItem> <Label>Statement End Offset</Label> <PropertyName>StatementEndOffset</PropertyName> </ListItem> <ListItem> <Label>Minimum Returned Rows</Label> <PropertyName>MinReturnedRows</PropertyName> </ListItem> <ListItem> <Label>Maximum Returned Rows</Label> <PropertyName>MaxReturnedRows</PropertyName> </ListItem> <ListItem> <Label>Average Returned Rows</Label> <PropertyName>AverageReturnedRows</PropertyName> </ListItem> <ListItem> <Label>Total Returned Rows</Label> <PropertyName>TotalReturnedRows</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>QueryPlan</PropertyName> </ListItem> <ListItem> <Label>Number Of Plans</Label> <PropertyName>Number Of Plans</PropertyName> </ListItem> <ListItem> <Label>Number Of Distinct Plans</Label> <PropertyName>NumberOfDistinctPlans</PropertyName> </ListItem> <ListItem> <Label>Minimum Grant (KB)</Label> <PropertyName>MinGrantKB</PropertyName> </ListItem> <ListItem> <Label>Maximum Grant (KB)</Label> <PropertyName>MaxGrantKB</PropertyName> </ListItem> <ListItem> <Label>Minimum Used Grant (KB)</Label> <PropertyName>MinUsedGrantKB</PropertyName> </ListItem> <ListItem> <Label>Maximum Used Grant (KB)</Label> <PropertyName>MaxUsedGrantKB</PropertyName> </ListItem> <ListItem> <Label>Percent Memory Grant Used</Label> <PropertyName>PercentMemoryGrantUsed</PropertyName> </ListItem> <ListItem> <Label>Average Maximum Memory Grant (KB)</Label> <PropertyName>AvgMaxMemoryGrant</PropertyName> </ListItem> <ListItem> <Label>Minimum Spills</Label> <PropertyName>MinSpills</PropertyName> </ListItem> <ListItem> <Label>Maximum Spills</Label> <PropertyName>MaxSpills</PropertyName> </ListItem> <ListItem> <Label>Total Spills</Label> <PropertyName>TotalSpills</PropertyName> </ListItem> <ListItem> <Label>Average Spills</Label> <PropertyName>AvgSpills</PropertyName> </ListItem> <ListItem> <Label>Query Plan Cost</Label> <PropertyName>QueryPlanCost</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisFileStats-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisFileStats</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzAnalysisFileStats-GroupingFormat</CustomControlName> <ScriptBlock>$($_.ServerName + '&' + $_.PhysicalPath)</ScriptBlock> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Check Date</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Size On Disk (MB)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Size On Disk Growth (MB)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Max IO Stall Read (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Max IO Stall Read Average (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Number of Reads</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Megabytes Read</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Max IO Stall Write (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Max IO Stall Write Average (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Number of Writes</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Megabytes Written</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>CheckDate</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SizeOnDiskMB</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SizeOnDiskMBgrowth</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>max_io_stall_read_ms</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>max_io_stall_read_ms_average</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>num_of_reads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>megabytes_read</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>max_io_stall_write_ms</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>max_io_stall_write_ms_average</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>num_of_writes</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>megabytes_written</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisFileStats-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisFileStats</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Name</Label> <PropertyName>ServerName</PropertyName> </ListItem> <ListItem> <Label>Check Date</Label> <PropertyName>CheckDate</PropertyName> </ListItem> <ListItem> <Label>IO Stall Breached (ms)</Label> <PropertyName>io_stall_ms_breached</PropertyName> </ListItem> <ListItem> <Label>Physical Path</Label> <PropertyName>PhysicalPath</PropertyName> </ListItem> <ListItem> <Label>Size On Disk (MB)</Label> <PropertyName>SizeOnDiskMB</PropertyName> </ListItem> <ListItem> <Label>Size On Disk Growth (MB)</Label> <PropertyName>SizeOnDiskMBgrowth</PropertyName> </ListItem> <ListItem> <Label>Max IO Stall Read (ms)</Label> <PropertyName>max_io_stall_read_ms</PropertyName> </ListItem> <ListItem> <Label>Max IO Stall Read Average (ms)</Label> <PropertyName>max_io_stall_read_ms_average</PropertyName> </ListItem> <ListItem> <Label>Is Stall Read Threshold (ms)</Label> <PropertyName>is_stall_read_ms_threshold</PropertyName> </ListItem> <ListItem> <Label>Number of Reads</Label> <PropertyName>num_of_reads</PropertyName> </ListItem> <ListItem> <Label>Megabytes Read</Label> <PropertyName>megabytes_read</PropertyName> </ListItem> <ListItem> <Label>Max IO Stall Write (ms)</Label> <PropertyName>max_io_stall_write_ms</PropertyName> </ListItem> <ListItem> <Label>Max IO Stall Write Average (ms)</Label> <PropertyName>max_io_stall_write_ms_average</PropertyName> </ListItem> <ListItem> <Label>IO Stall Write Average (ms)</Label> <PropertyName>io_stall_write_ms_average</PropertyName> </ListItem> <ListItem> <Label>Number of Writes</Label> <PropertyName>num_of_writes</PropertyName> </ListItem> <ListItem> <Label>Megabytes Written</Label> <PropertyName>megabytes_written</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisFirst-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisFirst</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzAnalysis-GroupingFormat</CustomControlName> <PropertyName>ServerName</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Check Date</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Check ID</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Priority</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Finding</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Details</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>HowToStopIt</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>CheckDate</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>CheckID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Priority</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Finding</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Details</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>HowToStopIt</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisFirst-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisFirst</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Name</Label> <PropertyName>ServerName</PropertyName> </ListItem> <ListItem> <Label>Check Date</Label> <PropertyName>CheckDate</PropertyName> </ListItem> <ListItem> <Label>Check ID</Label> <PropertyName>CheckID</PropertyName> </ListItem> <ListItem> <Label>Priority</Label> <PropertyName>Priority</PropertyName> </ListItem> <ListItem> <Label>Finding</Label> <PropertyName>Finding</PropertyName> </ListItem> <ListItem> <Label>URL</Label> <PropertyName>URL</PropertyName> </ListItem> <ListItem> <Label>Details</Label> <PropertyName>Details</PropertyName> </ListItem> <ListItem> <Label>How To Stop It</Label> <PropertyName>HowToStopIt</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>QueryPlan</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>QueryText</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisFirstSummary-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisFirstSummary</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Priority</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Findings Group</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Finding</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total Occurrences</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>First Occurrence</Label> <Width>28</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Last Occurrence</Label> <Width>28</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>Priority</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FindingsGroup</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Finding</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalOccurrences</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FirstOccurrence</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LastOccurrence</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisFirstSummary-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisFirstSummary</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Priority</Label> <PropertyName>Priority</PropertyName> </ListItem> <ListItem> <Label>Findings Group</Label> <PropertyName>FindingsGroup</PropertyName> </ListItem> <ListItem> <Label>Finding</Label> <PropertyName>Finding</PropertyName> </ListItem> <ListItem> <Label>Total Occurrences</Label> <PropertyName>TotalOccurrences</PropertyName> </ListItem> <ListItem> <Label>First Occurrence</Label> <PropertyName>FirstOccurrence</PropertyName> </ListItem> <ListItem> <Label>Last Occurrence</Label> <PropertyName>LastOccurrence</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisPerfmonStats-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisPerfmonStats</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzAnalysis-GroupingFormat</CustomControlName> <PropertyName>CheckDate</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Counter Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Object Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Instance Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Counter Value</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>counter_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>object_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>instance_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>cntr_value</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisPerfmonStats-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisPerfmonStats</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Name</Label> <PropertyName>ServerName</PropertyName> </ListItem> <ListItem> <Label>Check Date</Label> <PropertyName>CheckDate</PropertyName> </ListItem> <ListItem> <Label>Counter Name</Label> <PropertyName>counter_name</PropertyName> </ListItem> <ListItem> <Label>Object Name</Label> <PropertyName>object_name</PropertyName> </ListItem> <ListItem> <Label>Instance Name</Label> <PropertyName>instance_name</PropertyName> </ListItem> <ListItem> <Label>Counter Value</Label> <PropertyName>cntr_value</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisWaitStats-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisWaitStats</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzAnalysisWaitStats-GroupingFormat</CustomControlName> <PropertyName>CheckDate</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Wait Type</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Waits Rank</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Category</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Ignorable</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Elapsed Seconds</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Time Per Wait (ms)</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>wait_type</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>WaitsRank</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>WaitCategory</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Ignorable</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ElapsedSeconds</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>wait_time_ms_per_wait</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisWaitStats-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisWaitStats</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Name</Label> <PropertyName>ServerName</PropertyName> </ListItem> <ListItem> <Label>Check Date</Label> <PropertyName>CheckDate</PropertyName> </ListItem> <ListItem> <Label>Wait Type</Label> <PropertyName>wait_type</PropertyName> </ListItem> <ListItem> <Label>Waits Rank</Label> <PropertyName>WaitsRank</PropertyName> </ListItem> <ListItem> <Label>Wait Category</Label> <PropertyName>WaitCategory</PropertyName> </ListItem> <ListItem> <Label>Ignorable</Label> <PropertyName>Ignorable</PropertyName> </ListItem> <ListItem> <Label>Elapsed Seconds</Label> <PropertyName>ElapsedSeconds</PropertyName> </ListItem> <ListItem> <Label>Wait Time Delta (ms)</Label> <PropertyName>wait_time_ms_delta</PropertyName> </ListItem> <ListItem> <Label>Wait Time Delta (minutes)</Label> <PropertyName>wait_time_minutes_delta</PropertyName> </ListItem> <ListItem> <Label>Wait Time Minutes Per Minute</Label> <PropertyName>wait_time_minutes_per_minute</PropertyName> </ListItem> <ListItem> <Label>Signal Wait Time Delta (ms)</Label> <PropertyName>signal_wait_time_ms_delta</PropertyName> </ListItem> <ListItem> <Label>Waiting Tasks Count Delta</Label> <PropertyName>waiting_tasks_count_delta</PropertyName> </ListItem> <ListItem> <Label>Wait Time Per Wait (ms)</Label> <PropertyName>wait_time_ms_per_wait</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzAnalysisWho-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisWho</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzAnalysis-GroupingFormat</CustomControlName> <PropertyName>CheckDate</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Elapsed Time</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Session ID</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Database Name</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Query Cost</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Top Session Waits</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Blocking Session ID</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Request CPU Time (ms)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Logical Reads (MB)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Logical Writes (MB)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>elapsed_time</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>session_id</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>database_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>query_cost</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>top_session_waits</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>blocking_session_id</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>request_cpu_time</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Logical_Reads_MB</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Logical_Writes_MB</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzAnalysisWho-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzAnalysisWho</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Name</Label> <PropertyName>ServerName</PropertyName> </ListItem> <ListItem> <Label>Check Date</Label> <PropertyName>CheckDate</PropertyName> </ListItem> <ListItem> <Label>Elapsed Time</Label> <PropertyName>elapsed_time</PropertyName> </ListItem> <ListItem> <Label>Session ID</Label> <PropertyName>session_id</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>database_name</PropertyName> </ListItem> <ListItem> <Label>Query Text Snippet</Label> <PropertyName>query_text_snippet</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>query_plan</PropertyName> </ListItem> <ListItem> <Label>Live Query Plan</Label> <PropertyName>live_query_plan</PropertyName> </ListItem> <ListItem> <Label>Query Cost</Label> <PropertyName>query_cost</PropertyName> </ListItem> <ListItem> <Label>Status</Label> <PropertyName>status</PropertyName> </ListItem> <ListItem> <Label>Wait Information</Label> <PropertyName>wait_info</PropertyName> </ListItem> <ListItem> <Label>Top Session Waits</Label> <PropertyName>top_session_waits</PropertyName> </ListItem> <ListItem> <Label>Blocking Session ID</Label> <PropertyName>blocking_session_id</PropertyName> </ListItem> <ListItem> <Label>Open Transaction Count</Label> <PropertyName>open_transaction_count</PropertyName> </ListItem> <ListItem> <Label>Is Implicit Transaction</Label> <PropertyName>is_implicit_transaction</PropertyName> </ListItem> <ListItem> <Label>NT Domain</Label> <PropertyName>nt_domain</PropertyName> </ListItem> <ListItem> <Label>Host Name</Label> <PropertyName>host_name</PropertyName> </ListItem> <ListItem> <Label>Login Name</Label> <PropertyName>login_name</PropertyName> </ListItem> <ListItem> <Label>NT User Name</Label> <PropertyName>nt_user_name</PropertyName> </ListItem> <ListItem> <Label>Program Name</Label> <PropertyName>program_name</PropertyName> </ListItem> <ListItem> <Label>Fix Parameter Sniffing</Label> <PropertyName>fix_parameter_sniffing</PropertyName> </ListItem> <ListItem> <Label>Client Interface Name</Label> <PropertyName>client_interface_name</PropertyName> </ListItem> <ListItem> <Label>Login Time</Label> <PropertyName>login_time</PropertyName> </ListItem> <ListItem> <Label>Start Time</Label> <PropertyName>start_time</PropertyName> </ListItem> <ListItem> <Label>Request Time</Label> <PropertyName>request_time</PropertyName> </ListItem> <ListItem> <Label>Request CPU Time (ms)</Label> <PropertyName>request_cpu_time</PropertyName> </ListItem> <ListItem> <Label>Degree of Parallelism</Label> <PropertyName>degree_of_parallelism</PropertyName> </ListItem> <ListItem> <Label>Request Logical Reads</Label> <PropertyName>request_logical_reads</PropertyName> </ListItem> <ListItem> <Label>Logical Reads (MB)</Label> <PropertyName>Logical_Reads_MB</PropertyName> </ListItem> <ListItem> <Label>Request Writes</Label> <PropertyName>request_writes</PropertyName> </ListItem> <ListItem> <Label>Logical Writes (MB)</Label> <PropertyName>Logical_Writes_MB</PropertyName> </ListItem> <ListItem> <Label>Request Physical Reads</Label> <PropertyName>request_physical_reads</PropertyName> </ListItem> <ListItem> <Label>Physical Reads (MB)</Label> <PropertyName>Physical_reads_MB</PropertyName> </ListItem> <ListItem> <Label>Session CPU</Label> <PropertyName>session_cpu</PropertyName> </ListItem> <ListItem> <Label>Session Logical Reads</Label> <PropertyName>session_logical_reads</PropertyName> </ListItem> <ListItem> <Label>Session Logical Reads (MB)</Label> <PropertyName>session_logical_reads_MB</PropertyName> </ListItem> <ListItem> <Label>Session Physical Reads</Label> <PropertyName>session_physical_reads</PropertyName> </ListItem> <ListItem> <Label>Session Physical Reads (MB)</Label> <PropertyName>session_physical_reads_MB</PropertyName> </ListItem> <ListItem> <Label>Session Writes</Label> <PropertyName>session_writes</PropertyName> </ListItem> <ListItem> <Label>Session Writes (MB)</Label> <PropertyName>session_writes_MB</PropertyName> </ListItem> <ListItem> <Label>Tempdb Allocations (MB)</Label> <PropertyName>tempdb_allocations_mb</PropertyName> </ListItem> <ListItem> <Label>Memory Usage (8k pages)</Label> <PropertyName>memory_usage</PropertyName> </ListItem> <ListItem> <Label>Estimated Completion Time (ms)</Label> <PropertyName>estimated_completion_time</PropertyName> </ListItem> <ListItem> <Label>Percent Complete</Label> <PropertyName>percent_complete</PropertyName> </ListItem> <ListItem> <Label>Deadlock Priority</Label> <PropertyName>deadlock_priority</PropertyName> </ListItem> <ListItem> <Label>Transaction Isolation Level</Label> <PropertyName>transaction_isolation_level</PropertyName> </ListItem> <ListItem> <Label>Last DOP</Label> <PropertyName>last_dop</PropertyName> </ListItem> <ListItem> <Label>Minimum DOP</Label> <PropertyName>min_dop</PropertyName> </ListItem> <ListItem> <Label>Maximum DOP</Label> <PropertyName>max_dop</PropertyName> </ListItem> <ListItem> <Label>Last Grant (kb)</Label> <PropertyName>last_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Minimum Grant (kb)</Label> <PropertyName>min_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Grant (kb)</Label> <PropertyName>max_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Last Used Grant (kb)</Label> <PropertyName>last_used_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Minimum Used Grant (kb)</Label> <PropertyName>min_used_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Used Grant (kb)</Label> <PropertyName>max_used_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Last Ideal Grant (kb)</Label> <PropertyName>last_ideal_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Minimum Ideal Grant (kb)</Label> <PropertyName>min_ideal_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Ideal Grant (kb)</Label> <PropertyName>max_ideal_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Last Reserved Threads</Label> <PropertyName>last_reserved_threads</PropertyName> </ListItem> <ListItem> <Label>Minimum Reserved Threads</Label> <PropertyName>min_reserved_threads</PropertyName> </ListItem> <ListItem> <Label>Maximum Reserved Threads</Label> <PropertyName>max_reserved_threads</PropertyName> </ListItem> <ListItem> <Label>Last Used Threads</Label> <PropertyName>last_used_threads</PropertyName> </ListItem> <ListItem> <Label>Minimum Used Threads</Label> <PropertyName>min_used_threads</PropertyName> </ListItem> <ListItem> <Label>Maximum Used Threads</Label> <PropertyName>max_used_threads</PropertyName> </ListItem> <ListItem> <Label>Grant Time</Label> <PropertyName>grant_time</PropertyName> </ListItem> <ListItem> <Label>Requested Memory (kb)</Label> <PropertyName>requested_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Grant Memory (kb)</Label> <PropertyName>grant_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Is Request Granted</Label> <PropertyName>is_request_granted</PropertyName> </ListItem> <ListItem> <Label>Required Memory (kb)</Label> <PropertyName>required_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Query Memory Grant Used Memory (kb)</Label> <PropertyName>query_memory_grant_used_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Ideal Memory (kb)</Label> <PropertyName>ideal_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Is Small</Label> <PropertyName>is_small</PropertyName> </ListItem> <ListItem> <Label>Timeout (sec)</Label> <PropertyName>timeout_sec</PropertyName> </ListItem> <ListItem> <Label>Resource Semaphore ID</Label> <PropertyName>resource_semaphore_id</PropertyName> </ListItem> <ListItem> <Label>Wait Order</Label> <PropertyName>wait_order</PropertyName> </ListItem> <ListItem> <Label>Wait Time (ms)</Label> <PropertyName>wait_time_ms</PropertyName> </ListItem> <ListItem> <Label>Next Candidate for Memory Grant</Label> <PropertyName>next_candidate_for_memory_grant</PropertyName> </ListItem> <ListItem> <Label>Target Memory (kb)</Label> <PropertyName>target_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Target Memory (kb)</Label> <PropertyName>max_target_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Total Memory (kb)</Label> <PropertyName>total_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Available Memory (kb)</Label> <PropertyName>available_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Granted Memory (kb)</Label> <PropertyName>granted_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Query Resource Semaphore Used Memory (kb)</Label> <PropertyName>query_resource_semaphore_used_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Grantee Count</Label> <PropertyName>grantee_count</PropertyName> </ListItem> <ListItem> <Label>Waiter Count</Label> <PropertyName>waiter_count</PropertyName> </ListItem> <ListItem> <Label>Timeout Error Count</Label> <PropertyName>timeout_error_count</PropertyName> </ListItem> <ListItem> <Label>Forced Grant Count</Label> <PropertyName>forced_grant_count</PropertyName> </ListItem> <ListItem> <Label>Workload Group Name</Label> <PropertyName>workload_group_name</PropertyName> </ListItem> <ListItem> <Label>Resource Pool Name</Label> <PropertyName>resource_pool_name</PropertyName> </ListItem> <ListItem> <Label>Context Information</Label> <PropertyName>context_info</PropertyName> </ListItem> <ListItem> <Label>Query Hash</Label> <PropertyName>query_hash</PropertyName> </ListItem> <ListItem> <Label>Query Plan Hash</Label> <PropertyName>query_plan_hash</PropertyName> </ListItem> <ListItem> <Label>SQL Handle</Label> <PropertyName>sql_handle</PropertyName> </ListItem> <ListItem> <Label>Plan Handle</Label> <PropertyName>plan_handle</PropertyName> </ListItem> <ListItem> <Label>Statement Start Offset</Label> <PropertyName>statement_start_offset</PropertyName> </ListItem> <ListItem> <Label>Statement End Offset</Label> <PropertyName>statement_end_offset</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzCache-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzCache</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>ID</Label> <PropertyName>ID</PropertyName> </ListItem> <ListItem> <Label>Pass</Label> <PropertyName>Pass</PropertyName> </ListItem> <ListItem> <Label>Sample Time ()</Label> <PropertyName>SampleTime</PropertyName> </ListItem> <ListItem> <Label>Sql Handle</Label> <PropertyName>sql_handle</PropertyName> </ListItem> <ListItem> <Label>Statement Start Offset</Label> <PropertyName>statement_start_offset</PropertyName> </ListItem> <ListItem> <Label>Statement End Offset</Label> <PropertyName>statement_end_offset</PropertyName> </ListItem> <ListItem> <Label>Plan Generation Number</Label> <PropertyName>plan_generation_num</PropertyName> </ListItem> <ListItem> <Label>Plan Handle</Label> <PropertyName>plan_handle</PropertyName> </ListItem> <ListItem> <Label>Execution Count</Label> <PropertyName>execution_count</PropertyName> </ListItem> <ListItem> <Label>Total Worker Time (ms)</Label> <PropertyName>total_worker_time</PropertyName> </ListItem> <ListItem> <Label>Total Physical Reads</Label> <PropertyName>total_physical_reads</PropertyName> </ListItem> <ListItem> <Label>Total Logical Writes</Label> <PropertyName>total_logical_writes</PropertyName> </ListItem> <ListItem> <Label>Total Logical Reads</Label> <PropertyName>total_logical_reads</PropertyName> </ListItem> <ListItem> <Label>Total CLR Time (ms)</Label> <PropertyName>total_clr_time</PropertyName> </ListItem> <ListItem> <Label>Total Elapsed Time (ms)</Label> <PropertyName>total_elapsed_time</PropertyName> </ListItem> <ListItem> <Label>Creation Time</Label> <PropertyName>creation_time</PropertyName> </ListItem> <ListItem> <Label>Query Hash</Label> <PropertyName>query_hash</PropertyName> </ListItem> <ListItem> <Label>Query Plan Hash</Label> <PropertyName>query_plan_hash</PropertyName> </ListItem> <ListItem> <Label>Points</Label> <PropertyName>Points</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzFirst-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzFirst</TypeName> <TypeName>FirstResponderKit.BlitzFirstExpert</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzFirst-GroupingFormat</CustomControlName> <PropertyName>ServerInstance</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Priority</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>FindingsGroup</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Finding</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>URL</Label> <Width>40</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap/> <TableColumnItems> <TableColumnItem> <PropertyName>Priority</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FindingsGroup</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Finding</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>URL</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzFirst-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzFirst</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Priority</Label> <PropertyName>Priority</PropertyName> </ListItem> <ListItem> <Label>Findings Group</Label> <PropertyName>FindingsGroup</PropertyName> </ListItem> <ListItem> <Label>Finding</Label> <PropertyName>Finding</PropertyName> </ListItem> <ListItem> <Label>URL</Label> <PropertyName>URL</PropertyName> </ListItem> <ListItem> <Label>Details</Label> <PropertyName>Details</PropertyName> </ListItem> <ListItem> <Label>How To Stop It</Label> <PropertyName>HowToStopIt</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>QueryText</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>QueryPlan</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzFirstExpertResult-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzFirstExpertResult</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Priority</Label> <PropertyName>Priority</PropertyName> </ListItem> <ListItem> <Label>Findings Group</Label> <PropertyName>FindingsGroup</PropertyName> </ListItem> <ListItem> <Label>Finding</Label> <PropertyName>Finding</PropertyName> </ListItem> <ListItem> <Label>URL</Label> <PropertyName>URL</PropertyName> </ListItem> <ListItem> <Label>Details</Label> <PropertyName>Details</PropertyName> </ListItem> <ListItem> <Label>How To Stop It</Label> <PropertyName>HowToStopIt</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>QueryText</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>QueryPlan</PropertyName> </ListItem> <ListItem> <Label>Check ID</Label> <PropertyName>CheckID</PropertyName> </ListItem> <ListItem> <Label>Start Time</Label> <PropertyName>StartTime</PropertyName> </ListItem> <ListItem> <Label>Login Name</Label> <PropertyName>LoginName</PropertyName> </ListItem> <ListItem> <Label>NT User Name</Label> <PropertyName>NTUserName</PropertyName> </ListItem> <ListItem> <Label>Original Login Name</Label> <PropertyName>OriginalLoginName</PropertyName> </ListItem> <ListItem> <Label>Program Name</Label> <PropertyName>ProgramName</PropertyName> </ListItem> <ListItem> <Label>Host Name</Label> <PropertyName>HostName</PropertyName> </ListItem> <ListItem> <Label>Database ID</Label> <PropertyName>DatabaseID</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Open Transaction Count</Label> <PropertyName>OpenTransactionCount</PropertyName> </ListItem> <ListItem> <Label>Plan Handle</Label> <PropertyName>PlanHandle</PropertyName> </ListItem> <ListItem> <Label>Sql Handle</Label> <PropertyName>SqlHandle</PropertyName> </ListItem> <ListItem> <Label>Statement Start Offset</Label> <PropertyName>StatementStartOffset</PropertyName> </ListItem> <ListItem> <Label>Statement End Offset</Label> <PropertyName>StatementEndOffset</PropertyName> </ListItem> <ListItem> <Label>Executions</Label> <PropertyName>Executions</PropertyName> </ListItem> <ListItem> <Label>Executions Percent</Label> <PropertyName>ExecutionsPercent</PropertyName> </ListItem> <ListItem> <Label>Duration (ms)</Label> <PropertyName>Duration</PropertyName> </ListItem> <ListItem> <Label>Duration Percent</Label> <PropertyName>DurationPercent</PropertyName> </ListItem> <ListItem> <Label>CPU</Label> <PropertyName>CPU</PropertyName> </ListItem> <ListItem> <Label>CPU Percent</Label> <PropertyName>CPUPercent</PropertyName> </ListItem> <ListItem> <Label>Reads</Label> <PropertyName>Reads</PropertyName> </ListItem> <ListItem> <Label>Reads Percent</Label> <PropertyName>ReadsPercent</PropertyName> </ListItem> <ListItem> <Label>Plan Creation Time</Label> <PropertyName>PlanCreationTime</PropertyName> </ListItem> <ListItem> <Label>Total Executions</Label> <PropertyName>TotalExecutions</PropertyName> </ListItem> <ListItem> <Label>Total Executions Percent</Label> <PropertyName>TotalExecutionsPercent</PropertyName> </ListItem> <ListItem> <Label>Total Duration (ms)</Label> <PropertyName>TotalDuration</PropertyName> </ListItem> <ListItem> <Label>Total Duration Percent</Label> <PropertyName>TotalDurationPercent</PropertyName> </ListItem> <ListItem> <Label>Total CPU</Label> <PropertyName>TotalCPU</PropertyName> </ListItem> <ListItem> <Label>Total CPU Percent</Label> <PropertyName>TotalCPUPercent</PropertyName> </ListItem> <ListItem> <Label>Total Reads</Label> <PropertyName>TotalReads</PropertyName> </ListItem> <ListItem> <Label>Total Reads Percent</Label> <PropertyName>TotalReadsPercent</PropertyName> </ListItem> <ListItem> <Label>Details Int</Label> <PropertyName>DetailsInt</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzFirstTop10-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzFirstTop10</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>BlitzFirst-GroupingFormat</CustomControlName> <PropertyName>ServerInstance</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Hours</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Thread Time (hours)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Type</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Category</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Time (hours)</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Per Core Per Hour</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Number of Waits</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Avg ms Per Wait</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>HoursSample</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ThreadTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>wait_type</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>wait_category</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>WaitTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PerCorePerHour</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>NumberOfWaits</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AvgMsPerWait</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzFirstTop10-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzFirstTop10</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Hours Sample</Label> <PropertyName>HoursSample</PropertyName> </ListItem> <ListItem> <Label>Thread Time (hours)</Label> <PropertyName>ThreadTime</PropertyName> </ListItem> <ListItem> <Label>Wait Type</Label> <PropertyName>wait_type</PropertyName> </ListItem> <ListItem> <Label>Wait Category</Label> <PropertyName>wait_category</PropertyName> </ListItem> <ListItem> <Label>Wait Time (hours)</Label> <PropertyName>WaitTime</PropertyName> </ListItem> <ListItem> <Label>Per Core per Hour</Label> <PropertyName>PerCorePerHour</PropertyName> </ListItem> <ListItem> <Label>Number Of Waits</Label> <PropertyName>NumberOfWaits</PropertyName> </ListItem> <ListItem> <Label>Average ms per Wait</Label> <PropertyName>AvgMsPerWait</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzVersion-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzVersion</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Version</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Version Date</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Version</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>VersionDate</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzWho-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzWho</TypeName> <TypeName>FirstResponderKit.BlitzWhoExpert</TypeName> <TypeName>FirstResponderKit.BlitzWhoResult</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Elapsed Time</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Session Id</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Blocking Session Id</Label> <Width>9</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Database Name</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Query Cost</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Status</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Information</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Login Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>elapsed_time</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>session_id</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>blocking_session_id</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>database_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock>[math]::Round($_.query_cost, 3)</ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>status</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>wait_info</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>login_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>BlitzWho-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzWho</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Run Date</Label> <PropertyName>run_date</PropertyName> </ListItem> <ListItem> <Label>Elapsed Time</Label> <PropertyName>elapsed_time</PropertyName> </ListItem> <ListItem> <Label>Session Id</Label> <PropertyName>session_id</PropertyName> </ListItem> <ListItem> <Label>Blocking Session Id</Label> <PropertyName>blocking_session_id</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>database_name</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>query_text</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>query_plan</PropertyName> </ListItem> <ListItem> <Label>Live Query Plan</Label> <PropertyName>live_query_plan</PropertyName> </ListItem> <ListItem> <Label>Cached Parameter Information</Label> <PropertyName>Cached_Parameter_Info</PropertyName> </ListItem> <ListItem> <Label>Query Cost</Label> <PropertyName>query_cost</PropertyName> </ListItem> <ListItem> <Label>Status</Label> <PropertyName>status</PropertyName> </ListItem> <ListItem> <Label>Wait Information</Label> <PropertyName>wait_info</PropertyName> </ListItem> <ListItem> <Label>Wait Resource</Label> <PropertyName>wait_resource</PropertyName> </ListItem> <ListItem> <Label>Top Session Waits</Label> <PropertyName>top_session_waits</PropertyName> </ListItem> <ListItem> <Label>Open Transaction Count</Label> <PropertyName>open_transaction_count</PropertyName> </ListItem> <ListItem> <Label>Is Implicit Transaction</Label> <PropertyName>is_implicit_transaction</PropertyName> </ListItem> <ListItem> <Label>NT Domain</Label> <PropertyName>nt_domain</PropertyName> </ListItem> <ListItem> <Label>Host Name</Label> <PropertyName>host_name</PropertyName> </ListItem> <ListItem> <Label>Login Name</Label> <PropertyName>login_name</PropertyName> </ListItem> <ListItem> <Label>NT User Name</Label> <PropertyName>nt_user_name</PropertyName> </ListItem> <ListItem> <Label>Program Name</Label> <PropertyName>program_name</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzWhoExpert-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzWhoExpert</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Server Instance</Label> <PropertyName>ServerInstance</PropertyName> </ListItem> <ListItem> <Label>Blitz Version</Label> <PropertyName>BlitzVersion</PropertyName> </ListItem> <ListItem> <Label>Run Date</Label> <PropertyName>run_date</PropertyName> </ListItem> <ListItem> <Label>Elapsed Time</Label> <PropertyName>elapsed_time</PropertyName> </ListItem> <ListItem> <Label>Session Id</Label> <PropertyName>session_id</PropertyName> </ListItem> <ListItem> <Label>Blocking Session Id</Label> <PropertyName>blocking_session_id</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>database_name</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>query_text</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>query_plan</PropertyName> </ListItem> <ListItem> <Label>Live Query Plan</Label> <PropertyName>live_query_plan</PropertyName> </ListItem> <ListItem> <Label>Cached Parameter Information</Label> <PropertyName>Cached_Parameter_Info</PropertyName> </ListItem> <ListItem> <Label>Query Cost</Label> <PropertyName>query_cost</PropertyName> </ListItem> <ListItem> <Label>Status</Label> <PropertyName>status</PropertyName> </ListItem> <ListItem> <Label>Wait Information</Label> <PropertyName>wait_info</PropertyName> </ListItem> <ListItem> <Label>Wait Resource</Label> <PropertyName>wait_resource</PropertyName> </ListItem> <ListItem> <Label>Top Session Waits</Label> <PropertyName>top_session_waits</PropertyName> </ListItem> <ListItem> <Label>Open Transaction Count</Label> <PropertyName>open_transaction_count</PropertyName> </ListItem> <ListItem> <Label>Is Implicit Transaction</Label> <PropertyName>is_implicit_transaction</PropertyName> </ListItem> <ListItem> <Label>NT Domain</Label> <PropertyName>nt_domain</PropertyName> </ListItem> <ListItem> <Label>Host Name</Label> <PropertyName>host_name</PropertyName> </ListItem> <ListItem> <Label>Login Name</Label> <PropertyName>login_name</PropertyName> </ListItem> <ListItem> <Label>NT User Name</Label> <PropertyName>nt_user_name</PropertyName> </ListItem> <ListItem> <Label>Program Name</Label> <PropertyName>program_name</PropertyName> </ListItem> <ListItem> <Label>Fix Parameter Sniffing</Label> <PropertyName>fix_parameter_sniffing</PropertyName> </ListItem> <ListItem> <Label>Client Interface Name</Label> <PropertyName>client_interface_name</PropertyName> </ListItem> <ListItem> <Label>Login Time</Label> <PropertyName>login_time</PropertyName> </ListItem> <ListItem> <Label>Start Time</Label> <PropertyName>start_time</PropertyName> </ListItem> <ListItem> <Label>Request Time</Label> <PropertyName>request_time</PropertyName> </ListItem> <ListItem> <Label>Request CPU Time (ms)</Label> <PropertyName>request_cpu_time</PropertyName> </ListItem> <ListItem> <Label>Request Logical Reads</Label> <PropertyName>request_logical_reads</PropertyName> </ListItem> <ListItem> <Label>Request Physical Reads</Label> <PropertyName>request_physical_reads</PropertyName> </ListItem> <ListItem> <Label>Request Writes</Label> <PropertyName>request_writes</PropertyName> </ListItem> <ListItem> <Label>Session CPU</Label> <PropertyName>session_cpu</PropertyName> </ListItem> <ListItem> <Label>Session Logical Reads</Label> <PropertyName>session_logical_reads</PropertyName> </ListItem> <ListItem> <Label>Session Physical Reads</Label> <PropertyName>session_physical_reads</PropertyName> </ListItem> <ListItem> <Label>Session Writes</Label> <PropertyName>session_writes</PropertyName> </ListItem> <ListItem> <Label>Tempdb Allocations (MB)</Label> <PropertyName>tempdb_allocations_mb</PropertyName> </ListItem> <ListItem> <Label>Memory Usage (Pages)</Label> <PropertyName>memory_usage</PropertyName> </ListItem> <ListItem> <Label>Estimated Completion Time</Label> <PropertyName>estimated_completion_time</PropertyName> </ListItem> <ListItem> <Label>Percent Complete</Label> <PropertyName>percent_complete</PropertyName> </ListItem> <ListItem> <Label>Deadlock Priority</Label> <PropertyName>deadlock_priority</PropertyName> </ListItem> <ListItem> <Label>Transaction Isolation Level</Label> <PropertyName>transaction_isolation_level</PropertyName> </ListItem> <ListItem> <Label>Degree of Parallelism</Label> <PropertyName>degree_of_parallelism</PropertyName> </ListItem> <ListItem> <Label>Last DOP</Label> <PropertyName>last_dop</PropertyName> </ListItem> <ListItem> <Label>Minimum DOP</Label> <PropertyName>min_dop</PropertyName> </ListItem> <ListItem> <Label>Maximum DOP</Label> <PropertyName>max_dop</PropertyName> </ListItem> <ListItem> <Label>Last Grant (kb)</Label> <PropertyName>last_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Minimum Grant (kb)</Label> <PropertyName>min_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Grant (kb)</Label> <PropertyName>max_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Last Used Grant (kb)</Label> <PropertyName>last_used_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Minimum Used Grant (kb)</Label> <PropertyName>min_used_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Used Grant (kb)</Label> <PropertyName>max_used_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Last Ideal Grant (kb)</Label> <PropertyName>last_ideal_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Minimum Ideal Grant (kb)</Label> <PropertyName>min_ideal_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Ideal Grant (kb)</Label> <PropertyName>max_ideal_grant_kb</PropertyName> </ListItem> <ListItem> <Label>Last Reserved Threads</Label> <PropertyName>last_reserved_threads</PropertyName> </ListItem> <ListItem> <Label>Minimum Reserved Threads</Label> <PropertyName>min_reserved_threads</PropertyName> </ListItem> <ListItem> <Label>Maximum Reserved Threads</Label> <PropertyName>max_reserved_threads</PropertyName> </ListItem> <ListItem> <Label>Last Used Threads</Label> <PropertyName>last_used_threads</PropertyName> </ListItem> <ListItem> <Label>Minimum Used Threads</Label> <PropertyName>min_used_threads</PropertyName> </ListItem> <ListItem> <Label>Maximum Used Threads</Label> <PropertyName>max_used_threads</PropertyName> </ListItem> <ListItem> <Label>Grant Time</Label> <PropertyName>grant_time</PropertyName> </ListItem> <ListItem> <Label>Requested Memory (kb)</Label> <PropertyName>requested_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Grant Memory (kb)</Label> <PropertyName>grant_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Is Request Granted</Label> <PropertyName>is_request_granted</PropertyName> </ListItem> <ListItem> <Label>Required Memory (kb)</Label> <PropertyName>required_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Query Memory Grant Used Memory (kb)</Label> <PropertyName>query_memory_grant_used_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Ideal Memory (kb)</Label> <PropertyName>ideal_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Is Small</Label> <PropertyName>is_small</PropertyName> </ListItem> <ListItem> <Label>Timeout (sec)</Label> <PropertyName>timeout_sec</PropertyName> </ListItem> <ListItem> <Label>Resource Semaphore ID</Label> <PropertyName>resource_semaphore_id</PropertyName> </ListItem> <ListItem> <Label>Wait Order</Label> <PropertyName>wait_order</PropertyName> </ListItem> <ListItem> <Label>Wait Time (ms)</Label> <PropertyName>wait_time_ms</PropertyName> </ListItem> <ListItem> <Label>Next Candidate for Memory Grant</Label> <PropertyName>next_candidate_for_memory_grant</PropertyName> </ListItem> <ListItem> <Label>Target Memory (kb)</Label> <PropertyName>target_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Maximum Target Memory (kb)</Label> <PropertyName>max_target_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Total Memory (kb)</Label> <PropertyName>total_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Available Memory (kb)</Label> <PropertyName>available_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Granted Memory (kb)</Label> <PropertyName>granted_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Query Resource Semaphore Used Memory (kb)</Label> <PropertyName>query_resource_semaphore_used_memory_kb</PropertyName> </ListItem> <ListItem> <Label>Grantee Count</Label> <PropertyName>grantee_count</PropertyName> </ListItem> <ListItem> <Label>Waiter Count</Label> <PropertyName>waiter_count</PropertyName> </ListItem> <ListItem> <Label>Timeout Error Count</Label> <PropertyName>timeout_error_count</PropertyName> </ListItem> <ListItem> <Label>Forced Grant Count</Label> <PropertyName>forced_grant_count</PropertyName> </ListItem> <ListItem> <Label>Workload Group Name</Label> <PropertyName>workload_group_name</PropertyName> </ListItem> <ListItem> <Label>Resource Pool Name</Label> <PropertyName>resource_pool_name</PropertyName> </ListItem> <ListItem> <Label>Context Information</Label> <PropertyName>context_info</PropertyName> </ListItem> <ListItem> <Label>Query Hash</Label> <PropertyName>query_hash</PropertyName> </ListItem> <ListItem> <Label>Query Plan Hash</Label> <PropertyName>query_plan_hash</PropertyName> </ListItem> <ListItem> <Label>SQL Handle</Label> <PropertyName>sql_handle</PropertyName> </ListItem> <ListItem> <Label>Plan Handle</Label> <PropertyName>plan_handle</PropertyName> </ListItem> <ListItem> <Label>Statement Start Offset</Label> <PropertyName>statement_start_offset</PropertyName> </ListItem> <ListItem> <Label>Statement End Offset</Label> <PropertyName>statement_end_offset</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>BlitzWhoResult-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.BlitzWhoResult</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Run Date</Label> <PropertyName>run_date</PropertyName> </ListItem> <ListItem> <Label>Elapsed Time</Label> <PropertyName>elapsed_time</PropertyName> </ListItem> <ListItem> <Label>Session Id</Label> <PropertyName>session_id</PropertyName> </ListItem> <ListItem> <Label>Blocking Session Id</Label> <PropertyName>blocking_session_id</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>database_name</PropertyName> </ListItem> <ListItem> <Label>Query Text</Label> <PropertyName>query_text</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>query_plan</PropertyName> </ListItem> <ListItem> <Label>Live Query Plan</Label> <PropertyName>live_query_plan</PropertyName> </ListItem> <ListItem> <Label>Cached Parameter Information</Label> <PropertyName>Cached_Parameter_Info</PropertyName> </ListItem> <ListItem> <Label>Query Cost</Label> <PropertyName>query_cost</PropertyName> </ListItem> <ListItem> <Label>Status</Label> <PropertyName>status</PropertyName> </ListItem> <ListItem> <Label>Wait Information</Label> <PropertyName>wait_info</PropertyName> </ListItem> <ListItem> <Label>Wait Resource</Label> <PropertyName>wait_resource</PropertyName> </ListItem> <ListItem> <Label>Top Session Waits</Label> <PropertyName>top_session_waits</PropertyName> </ListItem> <ListItem> <Label>Open Transaction Count</Label> <PropertyName>open_transaction_count</PropertyName> </ListItem> <ListItem> <Label>Is Implicit Transaction</Label> <PropertyName>is_implicit_transaction</PropertyName> </ListItem> <ListItem> <Label>NT Domain</Label> <PropertyName>nt_domain</PropertyName> </ListItem> <ListItem> <Label>Host Name</Label> <PropertyName>host_name</PropertyName> </ListItem> <ListItem> <Label>Login Name</Label> <PropertyName>login_name</PropertyName> </ListItem> <ListItem> <Label>NT User Name</Label> <PropertyName>nt_user_name</PropertyName> </ListItem> <ListItem> <Label>Program Name</Label> <PropertyName>program_name</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>FileStats-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.FileStats</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>FileStats-GroupingFormat</CustomControlName> <ScriptBlock>$($_.Pattern + '&' + $_.SampleTime)</ScriptBlock> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Sample (s)</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>File Name</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Drive</Label> <Width>5</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Number Reads / Writes</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>MB Read / Written</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Avg Stall (ms)</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>File Physical Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Database Name</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Stall Rank</Label> <Width>5</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Sample</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FileName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Drive</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>NoReadsWrites</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MBReadWritten</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AvgStall</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock> ([System.IO.FileInfo]$_.FilePhysicalName).Name </ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>StallRank</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>FileStats-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.FileStats</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Pattern</Label> <PropertyName>Pattern</PropertyName> </ListItem> <ListItem> <Label>Sample Time</Label> <PropertyName>SampleTime</PropertyName> </ListItem> <ListItem> <Label>Sample (seconds)</Label> <PropertyName>Sample</PropertyName> </ListItem> <ListItem> <Label>File Name</Label> <PropertyName>FileName</PropertyName> </ListItem> <ListItem> <Label>Drive</Label> <PropertyName>Drive</PropertyName> </ListItem> <ListItem> <Label>Number of Reads/Writes</Label> <PropertyName>NoReadsWrites</PropertyName> </ListItem> <ListItem> <Label>MB Read/Written</Label> <PropertyName>MBReadWritten</PropertyName> </ListItem> <ListItem> <Label>Average Stall (ms)</Label> <PropertyName>AvgStall</PropertyName> </ListItem> <ListItem> <Label>File Physical Name</Label> <PropertyName>FilePhysicalName</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Stall Rank</Label> <PropertyName>StallRank</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>PerfmonStats-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.PerfmonStats</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>PerfmonStats-GroupingFormat</CustomControlName> <ScriptBlock>$($_.Pattern + '&' + $_.object_name + '&' + $_.counter_name)</ScriptBlock> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Instance Name</Label> <Width>28</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>First Sample Time</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>First Sample Value</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Last Sample Time</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Last Sample Value</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Value Delta</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Value Per Second</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>instance_name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock>$_.FirstSampleTime.DateTime</ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FirstSampleValue</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock>$_.LastSampleTime.DateTime</ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LastSampleValue</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ValueDelta</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock>[math]::Round($_.ValuePerSecond, 3)</ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>PerfmonStats-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.PerfmonStats</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Pattern</Label> <PropertyName>Pattern</PropertyName> </ListItem> <ListItem> <Label>Object Name</Label> <PropertyName>object_name</PropertyName> </ListItem> <ListItem> <Label>Counter Name</Label> <PropertyName>counter_name</PropertyName> </ListItem> <ListItem> <Label>Instance Name</Label> <PropertyName>instance_name</PropertyName> </ListItem> <ListItem> <Label>First Sample Time</Label> <PropertyName>FirstSampleTime</PropertyName> </ListItem> <ListItem> <Label>First Sample Value</Label> <PropertyName>FirstSampleValue</PropertyName> </ListItem> <ListItem> <Label>Last Sample Time</Label> <PropertyName>LastSampleTime</PropertyName> </ListItem> <ListItem> <Label>Last Sample Value</Label> <PropertyName>LastSampleValue</PropertyName> </ListItem> <ListItem> <Label>Value Delta</Label> <PropertyName>ValueDelta</PropertyName> </ListItem> <ListItem> <Label>Value per Second</Label> <PropertyName>ValuePerSecond</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>ProcedureCache-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.ProcedureCache</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Avg CPU</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total CPU</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>% CPU</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Avg Duration</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total Duration</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>% Duration</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Avg Reads</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total Reads</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>% Reads</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Exec Count</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>% Exec</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Exec / Minute</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Sql Handle</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>AvgCPU</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalCPU</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentCPU</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AvgDuration</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalDuration</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentDuration</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AvgReads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalReads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentReads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>execution_count</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentExecutions</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>executions_per_minute</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock>[System.BitConverter]::ToString($_.sql_handle).Replace("-", "")</ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>ProcedureCache-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.ProcedureCache</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Average CPU</Label> <PropertyName>AvgCPU</PropertyName> </ListItem> <ListItem> <Label>Total CPU</Label> <PropertyName>TotalCPU</PropertyName> </ListItem> <ListItem> <Label>Percent CPU</Label> <PropertyName>PercentCPU</PropertyName> </ListItem> <ListItem> <Label>Average Duration</Label> <PropertyName>AvgDuration</PropertyName> </ListItem> <ListItem> <Label>Total Duration</Label> <PropertyName>TotalDuration</PropertyName> </ListItem> <ListItem> <Label>Percent Duration</Label> <PropertyName>PercentDuration</PropertyName> </ListItem> <ListItem> <Label>Average Reads</Label> <PropertyName>AvgReads</PropertyName> </ListItem> <ListItem> <Label>Total Reads</Label> <PropertyName>TotalReads</PropertyName> </ListItem> <ListItem> <Label>Percent Reads</Label> <PropertyName>PercentReads</PropertyName> </ListItem> <ListItem> <Label>Execution Count</Label> <PropertyName>execution_count</PropertyName> </ListItem> <ListItem> <Label>Percent Executions</Label> <PropertyName>PercentExecutions</PropertyName> </ListItem> <ListItem> <Label>Executions Per Minute</Label> <PropertyName>executions_per_minute</PropertyName> </ListItem> <ListItem> <Label>Plan Creation Time</Label> <PropertyName>plan_creation_time</PropertyName> </ListItem> <ListItem> <Label>Last Execution Time</Label> <PropertyName>last_execution_time</PropertyName> </ListItem> <ListItem> <Label>Text</Label> <PropertyName>text</PropertyName> </ListItem> <ListItem> <Label>Filtered Text</Label> <PropertyName>text_filtered</PropertyName> </ListItem> <ListItem> <Label>Query Plan</Label> <PropertyName>query_plan</PropertyName> </ListItem> <ListItem> <Label>Filtered Query Plan</Label> <PropertyName>query_plan_filtered</PropertyName> </ListItem> <ListItem> <Label>Sql Handle</Label> <PropertyName>sql_handle</PropertyName> </ListItem> <ListItem> <Label>Query Hash</Label> <PropertyName>query_hash</PropertyName> </ListItem> <ListItem> <Label>Plan Handle</Label> <PropertyName>plan_handle</PropertyName> </ListItem> <ListItem> <Label>Query Plan Hash</Label> <PropertyName>query_plan_hash</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>WaitStats-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.WaitStats</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>WaitStats-GroupingFormat</CustomControlName> <ScriptBlock>$($_.Pattern + '&' + $_.SampleEnded + '&' + $_.SecondsSample) + '&' + $_.TotalThreadTime</ScriptBlock> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Wait Type</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Category</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Time (s)</Label> <Width>5</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Signal Wait Time (s)</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Percent Signal Waits</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Number of Waits</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Avg ms Per Wait</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>URL</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>wait_type</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>wait_category</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>WaitTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SignalWaitTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentSignalWaits</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>NumberOfWaits</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AvgMsPerWait</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>URL</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>WaitStats-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.WaitStats</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Pattern</Label> <PropertyName>Pattern</PropertyName> </ListItem> <ListItem> <Label>Sample Ended</Label> <PropertyName>SampleEnded</PropertyName> </ListItem> <ListItem> <Label>Seconds Sample</Label> <PropertyName>SecondsSample</PropertyName> </ListItem> <ListItem> <Label>Total Thread Time (seconds)</Label> <PropertyName>TotalThreadTime</PropertyName> </ListItem> <ListItem> <Label>Wait Type</Label> <PropertyName>wait_type</PropertyName> </ListItem> <ListItem> <Label>Wait Category</Label> <PropertyName>wait_category</PropertyName> </ListItem> <ListItem> <Label>Wait Time (seconds)</Label> <PropertyName>WaitTime</PropertyName> </ListItem> <ListItem> <Label>Per Core Per Second</Label> <PropertyName>PerCorePerSecond</PropertyName> </ListItem> <ListItem> <Label>Signal Wait Time (seconds)</Label> <PropertyName>SignalWaitTime</PropertyName> </ListItem> <ListItem> <Label>Percent Signal Waits</Label> <PropertyName>PercentSignalWaits</PropertyName> </ListItem> <ListItem> <Label>Number of Waits</Label> <PropertyName>NumberOfWaits</PropertyName> </ListItem> <ListItem> <Label>Average ms per Wait</Label> <PropertyName>AvgMsPerWait</PropertyName> </ListItem> <ListItem> <Label>URL</Label> <PropertyName>URL</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>WaitStatsSinceStartup-Table</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.WaitStatsSinceStartup</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>WaitStatsSinceStartup-GroupingFormat</CustomControlName> <ScriptBlock>$($_.Pattern + '&' + $_.SampleEnded + '&' + $_.HoursSample) + '&' + $_.ThreadTime</ScriptBlock> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Wait Type</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Category</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Wait Time (h)</Label> <Width>5</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Signal Wait Time (h)</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Percent Signal Waits</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Number of Waits</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Avg ms Per Wait</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>URL</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>wait_type</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>wait_category</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>WaitTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SignalWaitTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentSignalWaits</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>NumberOfWaits</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AvgMsPerWait</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>URL</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>WaitStatsSinceStartup-List</Name> <ViewSelectedBy> <TypeName>FirstResponderKit.WaitStatsSinceStartup</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Pattern</Label> <PropertyName>Pattern</PropertyName> </ListItem> <ListItem> <Label>Sample Ended</Label> <PropertyName>SampleEnded</PropertyName> </ListItem> <ListItem> <Label>Hours Sample</Label> <PropertyName>HoursSample</PropertyName> </ListItem> <ListItem> <Label>Total Thread Time (hours)</Label> <PropertyName>TotalThreadTime</PropertyName> </ListItem> <ListItem> <Label>Wait Type</Label> <PropertyName>wait_type</PropertyName> </ListItem> <ListItem> <Label>Wait Category</Label> <PropertyName>wait_category</PropertyName> </ListItem> <ListItem> <Label>Wait Time (hours)</Label> <PropertyName>WaitTime</PropertyName> </ListItem> <ListItem> <Label>Per Core Per Hour</Label> <PropertyName>PerCorePerHour</PropertyName> </ListItem> <ListItem> <Label>Signal Wait Time (hours)</Label> <PropertyName>SignalWaitTime</PropertyName> </ListItem> <ListItem> <Label>Percent Signal Waits</Label> <PropertyName>PercentSignalWaits</PropertyName> </ListItem> <ListItem> <Label>Number of Waits</Label> <PropertyName>NumberOfWaits</PropertyName> </ListItem> <ListItem> <Label>Average ms per Wait</Label> <PropertyName>AvgMsPerWait</PropertyName> </ListItem> <ListItem> <Label>URL</Label> <PropertyName>URL</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> </ViewDefinitions> </Configuration> |