"No","テストID","対象ファイル","対象クラス/関数","対象メソッド","テスト観点","テストケース名","前提条件","入力値","期待結果","優先度","備考"
"1","UT-BIX-001","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","パラメータなしでデフォルト実行","SQL Server 2008以降、有効なデータベース接続","パラメータなし（全デフォルト）","現在のデータベースに対してMode=0（Diagnose）で実行され、インデックス分析結果が返される","高","基本動作確認"
"2","UT-BIX-002","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Help=1でヘルプ表示","SQL Server接続済み","@Help=1","ヘルプメッセージが表示され、処理が終了する","中","ヘルプ機能"
"3","UT-BIX-003","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@VersionCheckMode=1でバージョン確認","SQL Server接続済み","@VersionCheckMode=1","バージョン情報が出力パラメータに設定され、即座にRETURN","中","バージョン確認機能"
"4","UT-BIX-004","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Mode=0（Diagnose）で実行","有効なデータベース","@DatabaseName='TestDB', @Mode=0","インデックス診断結果（重複インデックス、未使用インデックス等）が返される","高","診断モード"
"5","UT-BIX-005","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Mode=1（Summarize）で実行","有効なデータベース","@DatabaseName='TestDB', @Mode=1","インデックス使用状況のサマリーが返される","高","サマリーモード"
"6","UT-BIX-006","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Mode=2（Index Usage Detail）で実行","有効なデータベース","@DatabaseName='TestDB', @Mode=2","既存インデックスの詳細情報が返される","高","インデックス詳細モード"
"7","UT-BIX-007","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Mode=3（Missing Index Detail）で実行","有効なデータベース","@DatabaseName='TestDB', @Mode=3","欠落インデックスの詳細情報が返される","高","欠落インデックスモード"
"8","UT-BIX-008","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Mode=4（Diagnose Details）で実行","有効なデータベース","@DatabaseName='TestDB', @Mode=4","詳細診断結果（Priority 101+を含む）が返される","高","詳細診断モード"
"9","UT-BIX-009","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@ObjectNameで完全修飾テーブル名指定","指定テーブルが存在する","@ObjectName='TestDB.dbo.TestTable'","DatabaseName, SchemaName, TableNameが正しく解析され、該当テーブルの分析結果が返される","高","オブジェクト名解析"
"10","UT-BIX-010","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@DatabaseName, @SchemaName, @TableNameを個別指定","指定テーブルが存在する","@DatabaseName='TestDB', @SchemaName='dbo', @TableName='TestTable'","該当テーブルのインデックス詳細が返される","高","個別パラメータ指定"
"11","UT-BIX-011","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@GetAllDatabases=1で全データベース分析","複数のユーザーデータベースが存在","@GetAllDatabases=1","全ユーザーデータベースのインデックス分析が実行される","高","全データベース分析"
"12","UT-BIX-012","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Filter=1で低使用率警告を除外","有効なデータベース","@Mode=0, @Filter=1","読み取り0のオブジェクトに対する低使用率警告が除外される","中","フィルタ機能"
"13","UT-BIX-013","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Filter=2で500MB以上のオブジェクトのみ警告","有効なデータベース","@Mode=0, @Filter=2","500MB以上のオブジェクトに対してのみ警告が出力される","中","サイズフィルタ"
"14","UT-BIX-014","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@SkipPartitions=1でパーティション分析スキップ","パーティションテーブルが存在","@SkipPartitions=1","パーティション情報の収集がスキップされる","中","パーティションスキップ"
"15","UT-BIX-015","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@SkipStatistics=0で統計情報を収集","有効なデータベース","@SkipStatistics=0","統計情報が収集・分析される","中","統計情報収集"
"16","UT-BIX-016","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@ShowColumnstoreOnly=1でカラムストアのみ表示","カラムストアインデックスが存在","@ShowColumnstoreOnly=1","カラムストアインデックスのRow Group/Segment詳細のみが表示される","中","カラムストア専用"
"17","UT-BIX-017","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@BringThePain=1で50+データベース分析許可","50以上のデータベースが存在","@GetAllDatabases=1, @BringThePain=1","50以上のデータベースでも分析が実行される","中","大規模環境対応"
"18","UT-BIX-018","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@IgnoreDatabasesで特定DB除外","複数データベース存在","@GetAllDatabases=1, @IgnoreDatabases='DB1,DB2'","指定されたデータベースが分析から除外される","中","データベース除外"
"19","UT-BIX-019","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@ThresholdMBで結果フィルタリング","様々なサイズのテーブルが存在","@ThresholdMB=500","500MB以上のオブジェクトのみが基本結果に含まれる","中","サイズ閾値"
"20","UT-BIX-020","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@OutputType='TABLE'で結果表示","有効なデータベース","@OutputType='TABLE'","結果がテーブル形式で返される","高","出力タイプ指定"
"21","UT-BIX-021","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@OutputType='NONE'で出力テーブルに保存","出力テーブルが存在または作成可能","@OutputType='NONE', @OutputDatabaseName='DBA', @OutputSchemaName='dbo', @OutputTableName='BlitzIndexResults'","結果が指定テーブルに保存され、画面出力なし","中","テーブル出力"
"22","UT-BIX-022","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@IncludeInactiveIndexes=1で非アクティブインデックス含む","非アクティブインデックスが存在","@IncludeInactiveIndexes=1","読み書きのないインデックスも結果に含まれる","中","非アクティブ含む"
"23","UT-BIX-023","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@ShowAllMissingIndexRequests=1で全欠落インデックス表示","欠落インデックス情報が存在","@Mode=3, @ShowAllMissingIndexRequests=1","全ての欠落インデックス要求が表示される（閾値無視）","中","全欠落インデックス"
"24","UT-BIX-024","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@ShowPartitionRanges=1でパーティション範囲表示","パーティションテーブルが存在","@ShowPartitionRanges=1","カラムストアVisualizationにパーティション範囲値が追加される","低","パーティション範囲"
"25","UT-BIX-025","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@SortOrderでMode=2の並び順指定","有効なデータベース","@Mode=2, @SortOrder='size'","指定された並び順で結果が返される","低","並び順指定"
"26","UT-BIX-026","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@SortDirection='ASC'で昇順ソート","有効なデータベース","@Mode=2, @SortDirection='ASC'","昇順で結果が返される","低","ソート方向"
"27","UT-BIX-027","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@Debug=1でデバッグ出力","有効なデータベース","@Debug=1","実行されるDynamic SQLがPRINTで出力される","低","デバッグモード"
"28","UT-BIX-028","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@UsualStatisticsSamplingPercent指定","有効なデータベース","@SkipStatistics=0, @UsualStatisticsSamplingPercent=50","50%以外のサンプリング率の統計が報告される","低","統計サンプリング率"
"29","UT-BIX-029","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","OUTPUTパラメータでバージョン取得","SQL Server接続済み","@Version OUTPUT, @VersionDate OUTPUT","バージョン番号と日付がOUTPUTパラメータに設定される","中","OUTPUTパラメータ"
"30","UT-BIX-030","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","無効な@Mode値","SQL Server接続済み","@Mode=5","エラーメッセージ「Invalid @Mode parameter」が発生","高","パラメータ検証"
"31","UT-BIX-031","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","無効な@OutputType値","SQL Server接続済み","@OutputType='INVALID'","エラーメッセージ「Invalid value for parameter @OutputType」が発生","高","出力タイプ検証"
"32","UT-BIX-032","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@UsualStatisticsSamplingPercent=0","SQL Server接続済み","@UsualStatisticsSamplingPercent=0","エラーメッセージ「Invalid value for parameter @UsualStatisticsSamplingPercent」が発生","中","統計パーセント検証"
"33","UT-BIX-033","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@UsualStatisticsSamplingPercent=101","SQL Server接続済み","@UsualStatisticsSamplingPercent=101","エラーメッセージ「Invalid value for parameter @UsualStatisticsSamplingPercent」が発生","中","統計パーセント上限"
"34","UT-BIX-034","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","存在しないデータベース指定","SQL Server接続済み","@DatabaseName='NonExistentDB'","エラーメッセージ「Database does not exist or is not online/multi-user」が発生","高","データベース存在確認"
"35","UT-BIX-035","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","存在しないテーブル指定","有効なデータベース","@DatabaseName='TestDB', @SchemaName='dbo', @TableName='NonExistentTable'","エラーメッセージ「I can't find the table or indexed view」が発生","高","テーブル存在確認"
"36","UT-BIX-036","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@SchemaNameのみ指定（@TableNameなし）","有効なデータベース","@SchemaName='dbo', @TableName=NULL","エラーメッセージ「We can't run against a whole schema」が発生","中","スキーマ単独指定"
"37","UT-BIX-037","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@Mode<>0で@TableName指定","有効なデータベース","@Mode=1, @TableName='TestTable'","エラーメッセージ「Setting the @Mode doesn't change behavior」が発生","中","Mode/TableName競合"
"38","UT-BIX-038","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@Mode<>0で@Filter指定","有効なデータベース","@Mode=1, @Filter=1","エラーメッセージ「@Filter only applies when @Mode=0」が発生","中","Mode/Filter競合"
"39","UT-BIX-039","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@OutputType='NONE'で出力先不完全","SQL Server接続済み","@OutputType='NONE', @OutputDatabaseName='DBA', @OutputSchemaName=NULL, @OutputTableName=NULL","エラーメッセージ「This procedure should be called with a value for @OutputTableName」が発生","中","出力パラメータ不足"
"40","UT-BIX-040","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","@OutputServerName指定で他の出力パラメータ不足","SQL Server接続済み","@OutputType='NONE', @OutputServerName='LinkedServer', @OutputDatabaseName=NULL","エラーメッセージ「rest of @Output* parameters needs to also be specified」が発生","中","リンクサーバー出力"
"41","UT-BIX-041","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","SQL Server 2005で実行","SQL Server 2005","パラメータなし","エラーメッセージ「sp_BlitzIndex is only supported on SQL Server 2008 and higher」が発生","高","バージョン制限"
"42","UT-BIX-042","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","オフラインデータベース指定","オフラインDBが存在","@DatabaseName='OfflineDB'","エラーメッセージ「Database does not exist or is not online/multi-user」が発生","中","オフラインDB"
"43","UT-BIX-043","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","異常系","シングルユーザーモードDB指定","シングルユーザーDBが存在","@DatabaseName='SingleUserDB'","エラーメッセージ「Database does not exist or is not online/multi-user」が発生","中","シングルユーザーDB"
"44","UT-BIX-044","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@ThresholdMB=0","有効なデータベース","@ThresholdMB=0","0MB以上（全て）のオブジェクトが結果に含まれる","中","閾値最小"
"45","UT-BIX-045","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@ThresholdMB=2147483647（INT最大値）","有効なデータベース","@ThresholdMB=2147483647","極めて大きなオブジェクトのみが結果に含まれる（おそらく空結果）","低","閾値最大"
"46","UT-BIX-046","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@Mode=0（境界下限）","有効なデータベース","@Mode=0","有効なModeとして正常処理される","中","Mode下限"
"47","UT-BIX-047","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@Mode=4（境界上限）","有効なデータベース","@Mode=4","有効なModeとして正常処理される","中","Mode上限"
"48","UT-BIX-048","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@Filter=0（境界下限）","有効なデータベース","@Mode=0, @Filter=0","フィルタなしとして正常処理される","中","Filter下限"
"49","UT-BIX-049","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@Filter=2（境界上限）","有効なデータベース","@Mode=0, @Filter=2","500MBフィルタとして正常処理される","中","Filter上限"
"50","UT-BIX-050","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@UsualStatisticsSamplingPercent=1（下限）","有効なデータベース","@SkipStatistics=0, @UsualStatisticsSamplingPercent=1","1%として正常処理される","低","サンプリング下限"
"51","UT-BIX-051","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","@UsualStatisticsSamplingPercent=100（上限）","有効なデータベース","@SkipStatistics=0, @UsualStatisticsSamplingPercent=100","100%として正常処理される","低","サンプリング上限"
"52","UT-BIX-052","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","50データベースで@BringThePain=0","50データベースが存在","@GetAllDatabases=1, @BringThePain=0","警告メッセージが表示され、分析が中断される","中","DB数境界"
"53","UT-BIX-053","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","49データベースで@BringThePain=0","49データベースが存在","@GetAllDatabases=1, @BringThePain=0","警告なしで正常に分析が実行される","中","DB数境界-1"
"54","UT-BIX-054","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","100パーティションで@BringThePain=0","100パーティションのテーブルが存在","@SkipPartitions=0, @BringThePain=0","データベースがスキップされる警告が出力される","中","パーティション境界"
"55","UT-BIX-055","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","空のデータベース","テーブルが存在しないDB","@DatabaseName='EmptyDB'","空の結果セットまたは情報メッセージが返される","中","空DB"
"56","UT-BIX-056","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","インデックスのないテーブル","HEAPテーブルのみ存在","@DatabaseName='HeapOnlyDB'","HEAP関連の診断結果が返される","中","HEAPのみ"
"57","UT-BIX-057","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","Azure SQL DB上での実行","Azure SQL Database","@DatabaseName=NULL（Azure SQL DB）","現在のデータベースが自動設定され、正常に実行される","高","Azure対応"
"58","UT-BIX-058","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","AG セカンダリでの実行","読み取り可能AGセカンダリ","@GetAllDatabases=1","読み取り不可DBがスキップされ、警告が出力される","中","AG対応"
"59","UT-BIX-059","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","インデックスビューの分析","インデックス付きビューが存在","@TableName='IndexedViewName'","インデックス付きビューの分析結果が返される","中","インデックスビュー"
"60","UT-BIX-060","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","重複インデックスの検出（check_id 1）","重複キーのインデックスが存在","@Mode=0","重複インデックスがPriority 20で報告される","高","診断ルール"
"61","UT-BIX-061","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","類似インデックスの検出（check_id 2）","先頭キー列が同じインデックスが存在","@Mode=0","類似インデックスがPriority 30で報告される","高","診断ルール"
"62","UT-BIX-062","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","過剰インデックスの検出（check_id 20）","10以上のNCインデックスを持つテーブル","@Mode=0","過剰インデックスがPriority 10で報告される","高","診断ルール"
"63","UT-BIX-063","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","未使用NCインデックスの検出（check_id 22）","読み取り0、書き込み10000以上のNCインデックス","@Mode=0","未使用インデックスが報告される","高","診断ルール"
"64","UT-BIX-064","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","ロック待機時間長いインデックス検出（check_id 11）","ロック待機>5分のインデックス","@Mode=0","ロック競合インデックスがPriority 70で報告される","中","診断ルール"
"65","UT-BIX-065","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","一時停止中のResunable Index検出（check_id 122）","一時停止中の再開可能インデックス操作","@Mode=0","Priority 10で警告が報告される","高","Resumable Index"
"66","UT-BIX-066","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","実行中のResunable Index検出（check_id 123）","実行中の再開可能インデックス操作","@Mode=0","Priority 10で情報が報告される","中","Resumable Index"
"67","UT-BIX-067","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","欠落インデックスの検出","DMVに欠落インデックス情報が存在","@Mode=3","欠落インデックス詳細とCREATE INDEX文が返される","高","欠落インデックス"
"68","UT-BIX-068","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","外部キー制約のインデックス確認","インデックスのない外部キーが存在","@Mode=0","インデックスのない外部キーが報告される","中","外部キー分析"
"69","UT-BIX-069","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","統計情報の分析","古い統計情報が存在","@SkipStatistics=0, @Mode=0","古い統計情報が警告として報告される","中","統計分析"
"70","UT-BIX-070","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","フィルター付きインデックスの分析","フィルター付きインデックスが存在","@Mode=0または4","フィルター付きインデックスの詳細が報告される","中","フィルターインデックス"
"71","UT-BIX-071","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","テンポラルテーブルの分析","テンポラルテーブルが存在","@Mode=0または4","テンポラルテーブル関連の情報が報告される","低","テンポラル対応"
"72","UT-BIX-072","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","計算列の分析","計算列を持つテーブル","@Mode=0または4","計算列の情報が報告される","低","計算列"
"73","UT-BIX-073","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","CHECK制約の分析","CHECK制約が存在","@Mode=0または4","CHECK制約の情報が報告される","低","CHECK制約"
"74","UT-BIX-074","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","圧縮情報の表示","圧縮されたインデックスが存在","@Mode=2","データ圧縮情報が結果に含まれる","低","圧縮情報"
"75","UT-BIX-075","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","ID列分析","IDENTITY列が存在","@Mode=0","IDENTITY列の使用状況が分析される","中","ID列"
"76","UT-BIX-076","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","括弧付きテーブル名の解析","[schema].[table]形式の指定","@TableName='[dbo].[Test Table]'","括弧が正しく処理され、テーブルが特定される","中","特殊文字対応"
"77","UT-BIX-077","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","ドット含むテーブル名の解析","ドットを含むテーブル名","@TableName='[Test.Table]'","ドットがオブジェクト名の一部として正しく処理される","中","特殊文字対応"
"78","UT-BIX-078","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","@TableNameのみ指定（スキーマなし）","dboスキーマにテーブルが存在","@TableName='TestTable', @SchemaName=NULL","スキーマがdboとして自動設定される","中","デフォルトスキーマ"
"79","UT-BIX-079","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","XMLインデックスの分析","XMLインデックスが存在","@Mode=2","XMLインデックスが[XML]タグ付きで報告される","低","XMLインデックス"
"80","UT-BIX-080","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","空間インデックスの分析","空間インデックスが存在","@Mode=2","空間インデックスが[SPATIAL]タグ付きで報告される","低","空間インデックス"
"81","UT-BIX-081","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","JSON列インデックスの分析","JSONインデックスが存在","@Mode=2","JSONインデックスが[JSON]タグ付きで報告される","低","JSONインデックス"
"82","UT-BIX-082","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","インメモリOLTPテーブルの分析","インメモリテーブルが存在","@Mode=2","インメモリテーブルが[IN-MEMORY]タグ付きで報告される","低","インメモリOLTP"
"83","UT-BIX-083","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","無効化インデックスの検出","DISABLEDインデックスが存在","@Mode=0または2","無効化インデックスが[DISABLED]タグ付きで報告される","中","無効インデックス"
"84","UT-BIX-084","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","仮想インデックスの検出","HYPOTHETICALインデックスが存在","@Mode=2","仮想インデックスが[HYPOTHETICAL]タグ付きで報告される","低","仮想インデックス"
"85","UT-BIX-085","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","リンクサーバー経由の出力","リンクサーバーが設定済み","@OutputType='NONE', @OutputServerName='LinkedServer', @OutputDatabaseName='DBA', @OutputSchemaName='dbo', @OutputTableName='Results'","リンクサーバー上のテーブルに結果が保存される","低","リンクサーバー出力"
"86","UT-BIX-086","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","sp_BlitzCacheとの連携","@BringThePain=1","@Mode=3, @BringThePain=1, @DatabaseName='TestDB'","sp_BlitzCacheが呼び出され、関連クエリプランが表示される","中","sp_BlitzCache連携"
"87","UT-BIX-087","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","OPTIMIZE_FOR_SEQUENTIAL_KEY対応","SQL Server 2019以降","@Mode=2","optimize_for_sequential_key情報が含まれる","低","2019新機能"
"88","UT-BIX-088","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","ロックエスカレーション設定の表示","LOCK_ESCALATIONが設定されたテーブル","@Mode=2","ロックエスカレーション設定が結果に含まれる","低","ロック設定"
"89","UT-BIX-089","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","転送レコードの検出","HEAPに転送レコードが存在","@Mode=0","転送レコードがパフォーマンス問題として報告される","中","HEAP診断"
"90","UT-BIX-090","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","Incremental Statistics対応","インクリメンタル統計が存在","@SkipStatistics=0","インクリメンタル統計情報が報告される","低","増分統計"
"91","UT-BIX-091","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","エラーハンドリング","BEGIN TRY/CATCHでのエラー捕捉","エラーが発生する状況","エラーを発生させる入力","エラーメッセージが返され、トランザクションがロールバックされる","高","エラー処理"
"92","UT-BIX-092","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","エラーハンドリング","@dsqlがNULLの場合","内部エラー状況","内部処理でNULLが発生","エラーメッセージ「@dsql is null」が発生","中","NULL検出"
"93","UT-BIX-093","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","エラーハンドリング","システムデータベースへのアクセス","master/msdb/model/tempdb","@DatabaseName='master'","システムデータベースは@GetAllDatabases=1から除外される","中","システムDB除外"
"94","UT-BIX-094","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","エラーハンドリング","ReportServerデータベースの除外","ReportServerが存在","@GetAllDatabases=1","ReportServer%データベースが自動的に除外される","低","自動除外"
"95","UT-BIX-095","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","エラーハンドリング","配布データベースの除外","レプリケーション配布DBが存在","@GetAllDatabases=1","is_distributor=1のデータベースが除外される","低","自動除外"
"96","UT-BIX-096","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","CREATE INDEX文の生成","インデックスが存在","@Mode=0","推奨CREATE INDEX文が生成される（ONLINE=?形式）","中","DDL生成"
"97","UT-BIX-097","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","more_info列でのsp_BlitzIndex呼び出しコマンド","分析対象が存在","@Mode=0","各結果行にsp_BlitzIndexの追加呼び出しコマンドが含まれる","低","ヘルパー情報"
"98","UT-BIX-098","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","境界値","サーバー起動直後（DaysUptime=0）","サーバー起動直後","@Mode=0","DaysUptimeが0.01に設定され、ゼロ除算が回避される","中","起動直後対応"
"99","UT-BIX-099","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","トレースフラグの考慮","特定トレースフラグが有効","@Mode=0","トレースフラグの影響が考慮される","低","トレースフラグ"
"100","UT-BIX-100","sp_BlitzIndex.sql","sp_BlitzIndex","sp_BlitzIndex","正常系","照合順序の考慮","異なる照合順序のDB","@DatabaseName='DifferentCollationDB'","データベースの照合順序が正しく処理される","低","照合順序"
