"No","テストID","対象ファイル","対象クラス/関数","対象メソッド","テスト観点","テストケース名","前提条件","入力値","期待結果","優先度","備考"
"1","UT-BLF-001","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","ヘルプ表示が正しく動作すること","SQL Server接続済み","@Help = 1","ヘルプメッセージが表示されRETURN","高","基本機能：ヘルプ表示"
"2","UT-BLF-002","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","バージョンチェックモードが正しく動作すること","SQL Server接続済み","@VersionCheckMode = 1","@Version, @VersionDateが設定されRETURN","高","基本機能：バージョン確認"
"3","UT-BLF-003","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","デフォルトパラメータで実行できること","SQL Server接続済み","パラメータなし（デフォルト値）","診断結果が返却される","高","基本機能：デフォルト実行"
"4","UT-BLF-004","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","ExpertModeで詳細情報が取得できること","SQL Server接続済み","@ExpertMode = 1","BlitzWho結果を含む詳細な診断結果が返却される","高","ExpertMode機能"
"5","UT-BLF-005","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","SinceStartup=1でサーバー起動以降の統計を取得できること","SQL Server接続済み","@SinceStartup = 1","サーバー起動以降の累積統計が返却される","高","SinceStartup機能"
"6","UT-BLF-006","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","指定秒数のサンプリングが正しく動作すること","SQL Server接続済み","@Seconds = 10","10秒間のサンプリング結果が返却される","高","サンプリング時間指定"
"7","UT-BLF-007","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","OutputType=SCHEMAでスキーマ情報が取得できること","SQL Server接続済み","@OutputType = 'SCHEMA'","結果セットのスキーマ情報（FieldList）が返却される","中","OutputType機能"
"8","UT-BLF-008","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","OutputType=Top10で上位10件が取得できること","SQL Server接続済み","@OutputType = 'Top10'","上位10件の診断結果が返却される","中","OutputType機能"
"9","UT-BLF-009","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessageが正しく保存されること","出力テーブル存在","@LogMessage = 'Test Message', @OutputDatabaseName等設定","メッセージがテーブルに保存される","高","ログメッセージ機能"
"10","UT-BLF-010","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","AsOfパラメータで過去データが参照できること","出力テーブルに過去データ存在","@AsOf = '2024-01-01 12:00:00', @OutputDatabaseName等設定","指定時刻付近の過去データが返却される","中","過去データ参照機能"
"11","UT-BLF-011","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","データベースフィルタが正しく動作すること","複数データベース存在","@FilterPlansByDatabase = 'master,tempdb'","指定データベースのみのプラン情報が取得される","中","データベースフィルタ機能"
"12","UT-BLF-012","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","USERフィルタで非システムDBのみ取得できること","ユーザーデータベース存在","@FilterPlansByDatabase = 'USER'","ユーザーデータベースのみのプラン情報が取得される","中","データベースフィルタ機能"
"13","UT-BLF-013","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","出力テーブルへの保存が正しく動作すること","出力先データベース存在","@OutputDatabaseName, @OutputSchemaName, @OutputTableName指定","結果がテーブルに保存される","高","出力テーブル機能"
"14","UT-BLF-014","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","FileStats出力テーブルが正しく作成・保存されること","出力先データベース存在","@OutputTableNameFileStats指定","ファイル統計がテーブルに保存される","中","FileStats出力機能"
"15","UT-BLF-015","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","PerfmonStats出力テーブルが正しく作成・保存されること","出力先データベース存在","@OutputTableNamePerfmonStats指定","Perfmon統計がテーブルに保存される","中","PerfmonStats出力機能"
"16","UT-BLF-016","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","WaitStats出力テーブルが正しく作成・保存されること","出力先データベース存在","@OutputTableNameWaitStats指定","待機統計がテーブルに保存される","中","WaitStats出力機能"
"17","UT-BLF-017","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","BlitzCache出力テーブルが正しく作成・保存されること","出力先データベース存在, sp_BlitzCache存在","@OutputTableNameBlitzCache指定","BlitzCache結果がテーブルに保存される","中","BlitzCache出力機能"
"18","UT-BLF-018","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","BlitzWho出力テーブルが正しく作成・保存されること","出力先データベース存在, sp_BlitzWho存在","@OutputTableNameBlitzWho指定","BlitzWho結果がテーブルに保存される","中","BlitzWho出力機能"
"19","UT-BLF-019","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","OutputResultSetsで出力結果セットを制御できること","SQL Server接続済み","@OutputResultSets = 'Findings|WaitStats'","指定した結果セットのみ返却される","中","OutputResultSets機能"
"20","UT-BLF-020","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","OutputTableRetentionDaysで古いデータが削除されること","出力テーブルに古いデータ存在","@OutputTableRetentionDays = 7","7日より古いデータが削除される","中","データ保持期間機能"
"21","UT-BLF-021","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","CheckProcedureCache=1でプランキャッシュ分析が実行されること","SQL Server接続済み","@CheckProcedureCache = 1","プランキャッシュの分析結果が含まれる","中","プランキャッシュ分析機能"
"22","UT-BLF-022","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","ShowSleepingSPIDs=1で休止中セッションが表示されること","休止中セッション存在","@ShowSleepingSPIDs = 1","休止中のセッション情報が含まれる","低","ShowSleepingSPIDs機能"
"23","UT-BLF-023","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","FileLatencyThresholdMSでしきい値を変更できること","ディスクI/O発生中","@FileLatencyThresholdMS = 50","50ms以上のレイテンシが検出される","中","ファイルレイテンシしきい値機能"
"24","UT-BLF-024","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","MemoryGrantThresholdPctでメモリ付与しきい値を変更できること","メモリ付与が発生中","@MemoryGrantThresholdPct = 10.00","10%以上のメモリ付与が検出される","中","メモリ付与しきい値機能"
"25","UT-BLF-025","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","Debug=1でデバッグ情報が出力されること","SQL Server接続済み","@Debug = 1","RAISERRORによるデバッグメッセージが出力される","低","デバッグモード機能"
"26","UT-BLF-026","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 1","正常系","バックアップ実行中の検出が正しく動作すること","バックアップが5分以上実行中","@Seconds > 0","CheckID 1: Backup Runningが検出される","高","メンテナンスタスク検出"
"27","UT-BLF-027","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 2","正常系","DBCC CHECK実行中の検出が正しく動作すること","DBCC CHECKDBが実行中","@Seconds > 0","CheckID 2: DBCC CHECK* Runningが検出される","高","メンテナンスタスク検出"
"28","UT-BLF-028","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 3","正常系","リストア実行中の検出が正しく動作すること","リストアが実行中","@Seconds > 0","CheckID 3: Restore Runningが検出される","高","メンテナンスタスク検出"
"29","UT-BLF-029","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 4","正常系","データベースファイル拡張中の検出が正しく動作すること","ファイル拡張が発生中","@Seconds > 0","CheckID 4: Database File Growingが検出される","高","SQL Server内部メンテナンス検出"
"30","UT-BLF-030","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 5","正常系","長時間実行クエリによるブロッキングの検出が正しく動作すること","LCK待機が30秒以上発生中","@Seconds > 0","CheckID 5: Long-Running Query Blocking Othersが検出される","高","クエリ問題検出"
"31","UT-BLF-031","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 6","正常系","待機統計の上位10件が正しく取得されること","SQL Server接続済み","@Seconds > 0","CheckID 6: Wait Stats上位10件が返却される","高","待機統計分析"
"32","UT-BLF-032","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 7","正常系","プランキャッシュクリア直後の検出が正しく動作すること","DBCC FREEPROCCACHEが15分以内に実行された","デフォルトパラメータ","CheckID 7: Plan Cache Erased Recentlyが検出される","中","クエリ問題検出"
"33","UT-BLF-033","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 8","正常系","トランザクション開いたまま休止中のクエリ検出が正しく動作すること","open_tran > 0でsleeping状態のセッション存在","@Seconds > 0","CheckID 8: Sleeping Query with Open Transactionsが検出される","高","クエリ問題検出"
"34","UT-BLF-034","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 9","正常系","ロールバック中のクエリ検出が正しく動作すること","ロールバック実行中のセッション存在","@Seconds > 0","CheckID 9: Query Rolling Backが検出される","高","クエリ問題検出"
"35","UT-BLF-035","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 11","正常系","データファイル読み取り遅延の検出が正しく動作すること","PAGEIOLATCHが発生中かつ読み取り遅延あり","@Seconds > 0, @FileLatencyThresholdMS = 100","CheckID 11: Slow Data File Readsが検出される","高","パフォーマンス問題検出"
"36","UT-BLF-036","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 12","正常系","ログファイル書き込み遅延の検出が正しく動作すること","WRITELOGが発生中かつ書き込み遅延あり","@Seconds > 0, @FileLatencyThresholdMS = 100","CheckID 12: Slow Log File Writesが検出される","高","パフォーマンス問題検出"
"37","UT-BLF-037","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 13","正常系","ログファイル拡張の検出が正しく動作すること","ログファイル拡張が発生","@Seconds > 0","CheckID 13: Log File Growingが検出される","中","SQL Server内部メンテナンス検出"
"38","UT-BLF-038","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 14","正常系","ログファイル縮小の検出が正しく動作すること","ログファイル縮小が発生","@Seconds > 0","CheckID 14: Log File Shrinkingが検出される","中","SQL Server内部メンテナンス検出"
"39","UT-BLF-039","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 15","正常系","コンパイル率高の検出が正しく動作すること","コンパイルがバッチ要求の10%以上","@Seconds > 0","CheckID 15: Compilations/Sec Highが検出される","中","クエリ問題検出"
"40","UT-BLF-040","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 16","正常系","再コンパイル率高の検出が正しく動作すること","再コンパイルがバッチ要求の10%以上","@Seconds > 0","CheckID 16: Re-Compilations/Sec Highが検出される","中","クエリ問題検出"
"41","UT-BLF-041","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 17","正常系","リソース消費クエリの検出が正しく動作すること","@CheckProcedureCache = 1","@Seconds >= 10, @CheckProcedureCache = 1","CheckID 17: Most Resource-Intensive Queriesが検出される","中","クエリ統計分析"
"42","UT-BLF-042","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 19","正常系","バッチ要求/秒の情報が正しく取得されること","SQL Server接続済み","@Seconds > 0","CheckID 19: Batch Requests per Secが返却される","中","サーバー情報取得"
"43","UT-BLF-043","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 21","正常系","データベースサイズ合計が正しく取得されること","SQL Server接続済み","デフォルトパラメータ","CheckID 21: Database Size, Total GBが返却される","中","サーバー情報取得"
"44","UT-BLF-044","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 22","正常系","データベース数が正しく取得されること","SQL Server接続済み","デフォルトパラメータ","CheckID 22: Database Countが返却される","中","サーバー情報取得"
"45","UT-BLF-045","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 23","正常系","CPU使用率情報が正しく取得されること","SQL Server接続済み","@Seconds < 30","CheckID 23: CPU Utilizationが返却される","中","サーバー情報取得"
"46","UT-BLF-046","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 24","正常系","高CPU使用率の検出が正しく動作すること","CPU使用率50%以上","@Seconds < 30","CheckID 24: High CPU Utilizationが検出される","高","パフォーマンス問題検出"
"47","UT-BLF-047","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 28","正常系","非SQLプロセスによる高CPU使用率の検出が正しく動作すること","非SQLプロセスのCPU使用率25%以上","@Seconds < 30","CheckID 28: High CPU Utilization - Not SQLが検出される","中","パフォーマンス問題検出"
"48","UT-BLF-048","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 29","正常系","Forwarded Fetch率高の検出が正しく動作すること","ヒープテーブルにforwarded recordsあり","@Seconds > 0","CheckID 29: Forwarded Fetches/Sec Highが検出される","中","テーブル問題検出"
"49","UT-BLF-049","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 30","正常系","Poison Waitの検出が正しく動作すること","THREADPOOL等のPoison Wait発生中","@Seconds > 0","CheckID 30: Poison Wait Detectedが検出される","高","パフォーマンス問題検出"
"50","UT-BLF-050","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 31","正常系","In-Memory OLTPガベージコレクションの検出が正しく動作すること","In-Memory OLTPガベージコレクション発生中","@Seconds > 0","CheckID 31: Garbage Collection in Progressが検出される","低","In-Memory OLTP問題検出"
"51","UT-BLF-051","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 32","正常系","In-Memory OLTPトランザクション中止の検出が正しく動作すること","In-Memory OLTPトランザクション中止発生","@Seconds > 0","CheckID 32: Transactions Abortedが検出される","低","In-Memory OLTP問題検出"
"52","UT-BLF-052","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 33","正常系","サブオプティマルプランの検出が正しく動作すること","サブオプティマルプラン発生","@Seconds > 0","CheckID 33: Suboptimal Plans/Sec Highが検出される","中","クエリ問題検出"
"53","UT-BLF-053","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 34","正常系","過剰な空きメモリの検出が正しく動作すること","空きメモリ20GB以上かつ合計の30%以上","デフォルトパラメータ","CheckID 34: Too Much Free Memoryが検出される","中","パフォーマンス問題検出"
"54","UT-BLF-054","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 35","正常系","ターゲットメモリ低下の検出が正しく動作すること","ターゲットメモリがmax server memoryの2/3以下","デフォルトパラメータ","CheckID 35: Target Memory Lower Than Maxが検出される","高","パフォーマンス問題検出"
"55","UT-BLF-055","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 37","正常系","暗黙的トランザクションの検出が正しく動作すること","暗黙的トランザクションが開いているセッション存在","@Seconds > 0","CheckID 37: Implicit Transactionsが検出される","中","クエリ問題検出"
"56","UT-BLF-056","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 39","正常系","メモリ付与待ちの検出が正しく動作すること","メモリ付与待ちのクエリ存在","デフォルトパラメータ","CheckID 39: Memory Grants Pendingが検出される","高","パフォーマンス問題検出"
"57","UT-BLF-057","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 40","正常系","メモリ付与/ワークスペース情報が正しく取得されること","SQL Server接続済み","デフォルトパラメータ","CheckID 40: Memory Grant/Workspace infoが返却される","中","サーバー情報取得"
"58","UT-BLF-058","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 41","正常系","Azure SQL DatabaseのDTU上限検出が正しく動作すること","Azure SQL Database, DTU90%以上","Azure SQL Database環境","CheckID 41: Database is Maxed Outが検出される","高","Azure固有の問題検出"
"59","UT-BLF-059","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 42","正常系","カーディナリティ推定エラーの検出が正しく動作すること","実行中クエリにカーディナリティ誤推定あり","@Seconds > 0","CheckID 42: Queries with 10000x cardinality misestimationsが検出される","中","クエリ問題検出"
"60","UT-BLF-060","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 43","正常系","並列処理の偏りの検出が正しく動作すること","並列クエリでスレッド間の処理量に偏りあり","@Seconds > 0","CheckID 43: Queries with 10000x skewed parallelismが検出される","中","クエリ問題検出"
"61","UT-BLF-061","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 45","正常系","USERSTORE_TOKENPERMメモリリークの検出が正しく動作すること","USERSTORE_TOKENPERMがバッファプールの10%以上使用","デフォルトパラメータ","CheckID 45: Memory Leak in USERSTORE_TOKENPERM Cacheが検出される","中","メモリ問題検出"
"62","UT-BLF-062","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 46","正常系","高メモリ付与クエリの検出が正しく動作すること","メモリ付与がワークスペースの15%以上のクエリ存在","@MemoryGrantThresholdPct = 15.00","CheckID 46: Query with a memory grant exceeding 15%が検出される","中","クエリ問題検出"
"63","UT-BLF-063","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 47","正常系","Runnableクエリ高比率の検出が正しく動作すること","Runnableステータスのクエリが20%以上","@Seconds > 0","CheckID 47: High Percentage Of Runnable Queriesが検出される","中","パフォーマンス問題検出"
"64","UT-BLF-064","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 50","正常系","スレッド時間情報が正しく取得されること","SQL Server接続済み","@Seconds > 0","CheckID 50: Thread Timeが返却される","低","サーバー情報取得"
"65","UT-BLF-065","sp_BlitzFirst.sql","sp_BlitzFirst","CheckID 51","正常系","デッドロックの検出が正しく動作すること","サンプル期間中にデッドロック発生","@Seconds > 0","CheckID 51: Deadlocksが検出される","高","クエリ問題検出"
"66","UT-BLF-066","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","異常系","OutputType=NONEで出力テーブル未指定時にエラーが発生すること","SQL Server接続済み","@OutputType = 'NONE', @OutputTableName = NULL","エラーメッセージが返却される","高","入力検証"
"67","UT-BLF-067","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","異常系","LogMessage指定で出力テーブルが存在しない場合にエラーが発生すること","出力テーブル未存在","@LogMessage = 'Test', @OutputDatabaseName = '[NonExistent]'","エラーメッセージが返却される","高","入力検証"
"68","UT-BLF-068","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","異常系","単一#一時テーブル指定でエラーが発生すること","SQL Server接続済み","@OutputTableName = '#LocalTemp'","エラーメッセージが返却される（##のみサポート）","中","入力検証"
"69","UT-BLF-069","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","境界値","Seconds=0でサーバー起動以降の統計が取得されること","SQL Server接続済み","@Seconds = 0","サーバー起動以降の累積統計が返却される","中","境界値テスト"
"70","UT-BLF-070","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","境界値","Seconds=1の最小サンプリング時間が正しく動作すること","SQL Server接続済み","@Seconds = 1","1秒間のサンプリング結果が返却される","中","境界値テスト"
"71","UT-BLF-071","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","境界値","OutputTableRetentionDays=1で古いデータが正しく削除されること","出力テーブルに2日以上前のデータ存在","@OutputTableRetentionDays = 1","1日より古いデータが削除される","中","境界値テスト"
"72","UT-BLF-072","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","境界値","FileLatencyThresholdMS=1の最小しきい値が正しく動作すること","ディスクI/O発生中","@FileLatencyThresholdMS = 1","1ms以上のレイテンシがすべて検出される","低","境界値テスト"
"73","UT-BLF-073","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","境界値","MemoryGrantThresholdPct=0.01の最小しきい値が正しく動作すること","メモリ付与発生中","@MemoryGrantThresholdPct = 0.01","0.01%以上のメモリ付与がすべて検出される","低","境界値テスト"
"74","UT-BLF-074","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","状態","Azure SQL Databaseで正しく動作すること","Azure SQL Database環境","デフォルトパラメータ","Azure SQL Database用の検出ロジックが実行される","高","環境依存テスト"
"75","UT-BLF-075","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","状態","Linuxで正しく動作すること","Linux上のSQL Server","デフォルトパラメータ","Linux用のCPU使用率計算ロジックが使用される","中","環境依存テスト"
"76","UT-BLF-076","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","状態","Availability Groups環境で正しく動作すること","Always On AG構成","デフォルトパラメータ","読み取り専用セカンダリが適切に除外される","中","環境依存テスト"
"77","UT-BLF-077","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","状態","sp_BlitzWho未インストール時に警告が表示されること","sp_BlitzWhoが存在しない","@ExpertMode = 1, @Seconds > 0","sp_BlitzWho未インストールの警告メッセージが表示される","低","依存関係テスト"
"78","UT-BLF-078","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","状態","sp_BlitzCache未インストール時でも動作すること","sp_BlitzCacheが存在しない","@OutputTableNameBlitzCache指定","エラーなく実行完了（BlitzCache結果は除く）","低","依存関係テスト"
"79","UT-BLF-079","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","グローバル一時テーブル出力が正しく動作すること","SQL Server接続済み","@OutputTableName = '##BlitzFirstResults'","結果がグローバル一時テーブルに保存される","中","出力テーブル機能"
"80","UT-BLF-080","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","OutputXMLasNVARCHAR=1でXMLがNVARCHARに変換されること","SQL Server接続済み","@OutputXMLasNVARCHAR = 1","QueryPlan等のXML列がNVARCHARとして出力される","低","出力形式変換機能"
"81","UT-BLF-081","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","CheckServerInfo=0でサーバー情報が除外されること","SQL Server接続済み","@CheckServerInfo = 0","サーバー情報（CheckID 21-23等）が除外される","低","出力制御機能"
"82","UT-BLF-082","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","BlitzCacheSkipAnalysis=0で詳細分析が実行されること","SQL Server接続済み, sp_BlitzCache存在","@BlitzCacheSkipAnalysis = 0","BlitzCacheの詳細分析が実行される","低","BlitzCache連携機能"
"83","UT-BLF-083","sp_BlitzFirst.sql","sp_BlitzFirst","Output Views","正常系","FileStats Deltasビューが正しく作成されること","出力テーブル存在","@OutputTableNameFileStats指定","[OutputTableNameFileStats]_Deltasビューが作成される","中","ビュー作成機能"
"84","UT-BLF-084","sp_BlitzFirst.sql","sp_BlitzFirst","Output Views","正常系","PerfmonStats Deltasビューが正しく作成されること","出力テーブル存在","@OutputTableNamePerfmonStats指定","[OutputTableNamePerfmonStats]_Deltasビューが作成される","中","ビュー作成機能"
"85","UT-BLF-085","sp_BlitzFirst.sql","sp_BlitzFirst","Output Views","正常系","PerfmonStats Actualsビューが正しく作成されること","出力テーブル存在","@OutputTableNamePerfmonStats指定","[OutputTableNamePerfmonStats]_Actualsビューが作成される","中","ビュー作成機能"
"86","UT-BLF-086","sp_BlitzFirst.sql","sp_BlitzFirst","Output Views","正常系","WaitStats Deltasビューが正しく作成されること","出力テーブル存在","@OutputTableNameWaitStats指定","[OutputTableNameWaitStats]_Deltasビューが作成される","中","ビュー作成機能"
"87","UT-BLF-087","sp_BlitzFirst.sql","sp_BlitzFirst","Output Views","正常系","WaitStats Categoriesテーブルが正しく作成されること","出力テーブル存在","@OutputTableNameWaitStats指定","[OutputTableNameWaitStats]_Categoriesテーブルが作成される","中","テーブル作成機能"
"88","UT-BLF-088","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","複数回実行時に出力テーブルにデータが追加されること","出力テーブル存在、既存データあり","@OutputTableName指定で複数回実行","既存データに追加される形で結果が保存される","中","累積データ保存機能"
"89","UT-BLF-089","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessageCheckIDパラメータが正しく適用されること","出力テーブル存在","@LogMessage設定, @LogMessageCheckID = 99","CheckID=99でメッセージが保存される","低","ログメッセージ機能"
"90","UT-BLF-090","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessagePriorityパラメータが正しく適用されること","出力テーブル存在","@LogMessage設定, @LogMessagePriority = 5","Priority=5でメッセージが保存される","低","ログメッセージ機能"
"91","UT-BLF-091","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessageFindingsGroupパラメータが正しく適用されること","出力テーブル存在","@LogMessage設定, @LogMessageFindingsGroup = 'Custom Group'","FindingsGroup='Custom Group'でメッセージが保存される","低","ログメッセージ機能"
"92","UT-BLF-092","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessageFindingパラメータが正しく適用されること","出力テーブル存在","@LogMessage設定, @LogMessageFinding = 'Custom Finding'","Finding='Custom Finding'でメッセージが保存される","低","ログメッセージ機能"
"93","UT-BLF-093","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessageURLパラメータが正しく適用されること","出力テーブル存在","@LogMessage設定, @LogMessageURL = 'http://example.com'","URL='http://example.com'でメッセージが保存される","低","ログメッセージ機能"
"94","UT-BLF-094","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","LogMessageCheckDateパラメータが正しく適用されること","出力テーブル存在","@LogMessage設定, @LogMessageCheckDate = '2024-01-01'","CheckDate='2024-01-01'でメッセージが保存される","低","ログメッセージ機能"
"95","UT-BLF-095","sp_BlitzFirst.sql","sp_BlitzFirst","Wait Categories","正常系","待機カテゴリテーブルが正しく作成・利用されること","SQL Server接続済み","デフォルトパラメータ","##WaitCategoriesテーブルが作成され527行が挿入される","中","待機カテゴリ機能"
"96","UT-BLF-096","sp_BlitzFirst.sql","sp_BlitzFirst","Wait Categories","正常系","既存の待機カテゴリテーブルが再利用されること","##WaitCategoriesテーブル存在","デフォルトパラメータ","既存の##WaitCategoriesテーブルが再利用される","低","待機カテゴリ機能"
"97","UT-BLF-097","sp_BlitzFirst.sql","sp_BlitzFirst","Perfmon Counters","正常系","カスタムPerfmonカウンタが利用できること","#CustomPerfmonCountersテーブル存在","#CustomPerfmonCountersに値設定","カスタムカウンタが収集される","低","カスタムPerfmon機能"
"98","UT-BLF-098","sp_BlitzFirst.sql","sp_BlitzFirst","Perfmon Counters","正常系","デフォルトPerfmonカウンタが正しく収集されること","SQL Server接続済み","デフォルトパラメータ","約100種類のPerfmonカウンタが収集される","中","Perfmon収集機能"
"99","UT-BLF-099","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","EXECUTE AS CALLERで呼び出し元のコンテキストで実行されること","適切な権限を持つユーザー","デフォルトパラメータ","呼び出し元ユーザーの権限で実行される","中","セキュリティ機能"
"100","UT-BLF-100","sp_BlitzFirst.sql","sp_BlitzFirst","Main Procedure","正常系","RECOMPILEオプションで毎回新しいプランが生成されること","SQL Server接続済み","デフォルトパラメータ","毎回実行時に新しい実行プランが生成される","低","実行プラン機能"
