"No","テストID","対象ファイル","対象クラス/関数","対象メソッド","テスト観点","テストケース名","前提条件","入力値","期待結果","優先度","備考"
"1","UT-BLC-001","sp_BlitzCache.sql","sp_BlitzCache","メイン処理","正常系","@Help=1でヘルプ情報が表示されること","SQL Server 2008以降","@Help=1","パラメータ説明、カラム説明、設定パラメータ説明が表示される","中","ヘルプ機能の基本テスト"
"2","UT-BLC-002","sp_BlitzCache.sql","sp_BlitzCache","メイン処理","正常系","デフォルトパラメータで正常実行されること","SQL Server 2008以降、プランキャッシュにデータあり","パラメータなし（デフォルト）","CPU順でTop10のクエリ情報が返却される","高","基本機能テスト"
"3","UT-BLC-003","sp_BlitzCache.sql","sp_BlitzCache","メイン処理","正常系","@VersionCheckMode=1でバージョン情報のみ返却されること","SQL Server 2008以降","@VersionCheckMode=1","@Version、@VersionDateに値がセットされ、すぐにRETURN","中","バージョンチェック機能"
"4","UT-BLC-004","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='CPU'でCPU順にソートされること","プランキャッシュにデータあり","@SortOrder='CPU'","TotalCPU降順でソートされた結果","高","ソート機能の基本テスト"
"5","UT-BLC-005","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='Reads'でReads順にソートされること","プランキャッシュにデータあり","@SortOrder='Reads'","TotalReads降順でソートされた結果","高","ソート機能テスト"
"6","UT-BLC-006","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='Writes'でWrites順にソートされること","プランキャッシュにデータあり","@SortOrder='Writes'","TotalWrites降順でソートされた結果","高","ソート機能テスト"
"7","UT-BLC-007","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='Duration'でDuration順にソートされること","プランキャッシュにデータあり","@SortOrder='Duration'","TotalDuration降順でソートされた結果","高","ソート機能テスト"
"8","UT-BLC-008","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='Executions'で実行回数順にソートされること","プランキャッシュにデータあり","@SortOrder='Executions'","ExecutionCount降順でソートされた結果","高","ソート機能テスト"
"9","UT-BLC-009","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='Memory Grant'でメモリグラント順にソートされること","SQL Server 2012以降","@SortOrder='Memory Grant'","MaxGrantKB降順でソートされた結果","中","メモリグラント対応バージョン要"
"10","UT-BLC-010","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='Spills'でスピル順にソートされること","SQL Server 2016以降","@SortOrder='Spills'","MaxSpills降順でソートされた結果","中","スピル対応バージョン要"
"11","UT-BLC-011","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='avg cpu'で平均CPU順にソートされること","プランキャッシュにデータあり","@SortOrder='avg cpu'","AverageCPU降順でソートされた結果","高","平均値ソート機能"
"12","UT-BLC-012","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='compiles'でコンパイル時間順にソートされること","プランキャッシュにデータあり","@SortOrder='compiles'","PlanCreationTime降順でソートされた結果","中","コンパイルソート機能"
"13","UT-BLC-013","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='query hash'でクエリハッシュソートが動作すること","プランキャッシュに重複クエリあり","@SortOrder='query hash'","重複するクエリハッシュが特定され、CPU順で表示","中","クエリハッシュソート機能"
"14","UT-BLC-014","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='duplicate'で重複プランソートが動作すること","プランキャッシュに重複プランあり","@SortOrder='duplicate'","100以上の重複を持つクエリハッシュが表示される","中","重複プランソート機能"
"15","UT-BLC-015","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","正常系","@SortOrder='all'で全ソート順が実行されること","プランキャッシュにデータあり","@SortOrder='all'","各ソート順でTop5のデータが結合されて返却される","中","全ソート機能"
"16","UT-BLC-016","sp_BlitzCache.sql","sp_BlitzCache","@SortOrder","異常系","無効な@SortOrderがCPUにリバートされること","プランキャッシュにデータあり","@SortOrder='invalid_value'","警告メッセージが出力され、CPU順でソートされる","高","入力バリデーション"
"17","UT-BLC-017","sp_BlitzCache.sql","sp_BlitzCache","@Top","正常系","@Top指定で件数が制限されること","プランキャッシュにデータあり","@Top=5","5件のみ結果が返却される","高","件数制限機能"
"18","UT-BLC-018","sp_BlitzCache.sql","sp_BlitzCache","@Top","境界値","@Top=1で1件のみ返却されること","プランキャッシュにデータあり","@Top=1","1件のみ結果が返却される","中","境界値テスト"
"19","UT-BLC-019","sp_BlitzCache.sql","sp_BlitzCache","@Top","境界値","@Top=NULLでデフォルト値が適用されること","プランキャッシュにデータあり","@Top=NULL","@SortOrderに応じたデフォルト値（5または10）が適用","中","NULL値処理"
"20","UT-BLC-020","sp_BlitzCache.sql","sp_BlitzCache","@DatabaseName","正常系","特定データベースでフィルタリングされること","指定DBにプランあり","@DatabaseName='TestDB'","指定データベースのクエリのみ返却される","高","データベースフィルタ機能"
"21","UT-BLC-021","sp_BlitzCache.sql","sp_BlitzCache","@DatabaseName","異常系","存在しないデータベース名でエラーになること","存在しないDB名","@DatabaseName='NonExistentDB'","エラーメッセージ「The database you specified does not exist」","高","入力バリデーション"
"22","UT-BLC-022","sp_BlitzCache.sql","sp_BlitzCache","@DatabaseName","異常系","読み取り不可データベースでエラーになること","オフラインDB","@DatabaseName='OfflineDB'","エラーメッセージ「The database you specified is not readable」","中","可用性チェック"
"23","UT-BLC-023","sp_BlitzCache.sql","sp_BlitzCache","@QueryFilter","正常系","@QueryFilter='all'で全クエリタイプが返却されること","各種クエリタイプがキャッシュにあり","@QueryFilter='all'","Statement、Procedure、Function、Triggerが含まれる","高","クエリフィルタ機能"
"24","UT-BLC-024","sp_BlitzCache.sql","sp_BlitzCache","@QueryFilter","正常系","@QueryFilter='procedures'でストアドプロシージャのみ返却されること","プロシージャがキャッシュにあり","@QueryFilter='procedures'","Procedureタイプのみ返却される","高","クエリフィルタ機能"
"25","UT-BLC-025","sp_BlitzCache.sql","sp_BlitzCache","@QueryFilter","正常系","@QueryFilter='statements'でステートメントのみ返却されること","ステートメントがキャッシュにあり","@QueryFilter='statements'","Statementタイプのみ返却される","高","クエリフィルタ機能"
"26","UT-BLC-026","sp_BlitzCache.sql","sp_BlitzCache","@QueryFilter","正常系","@QueryFilter='functions'で関数のみ返却されること","SQL Server 2016以降、関数がキャッシュにあり","@QueryFilter='functions'","Functionタイプのみ返却される","中","SQL Server 2016以降で有効"
"27","UT-BLC-027","sp_BlitzCache.sql","sp_BlitzCache","@QueryFilter","異常系","無効な@QueryFilterがallにリバートされること","プランキャッシュにデータあり","@QueryFilter='invalid'","警告メッセージが出力され、allとして動作","中","入力バリデーション"
"28","UT-BLC-028","sp_BlitzCache.sql","sp_BlitzCache","@IgnoreSystemDBs","正常系","@IgnoreSystemDBs=1でシステムDBが除外されること","システムDBにプランあり","@IgnoreSystemDBs=1","master、model、msdb、tempdbのプランが除外される","高","システムDBフィルタ"
"29","UT-BLC-029","sp_BlitzCache.sql","sp_BlitzCache","@IgnoreSystemDBs","正常系","@IgnoreSystemDBs=0でシステムDBが含まれること","システムDBにプランあり","@IgnoreSystemDBs=0","システムDBのプランも結果に含まれる","中","システムDB含める"
"30","UT-BLC-030","sp_BlitzCache.sql","sp_BlitzCache","@DurationFilter","正常系","@DurationFilterで平均実行時間フィルタが適用されること","様々な実行時間のプランあり","@DurationFilter=5.0","平均実行時間5秒以上のクエリのみ返却される","高","実行時間フィルタ"
"31","UT-BLC-031","sp_BlitzCache.sql","sp_BlitzCache","@DurationFilter","境界値","@DurationFilter=0で全クエリが対象になること","プランキャッシュにデータあり","@DurationFilter=0","全クエリが結果に含まれる","中","境界値テスト"
"32","UT-BLC-032","sp_BlitzCache.sql","sp_BlitzCache","@MinimumExecutionCount","正常系","最小実行回数フィルタが適用されること","様々な実行回数のプランあり","@MinimumExecutionCount=100","実行回数100以上のクエリのみ返却される","高","実行回数フィルタ"
"33","UT-BLC-033","sp_BlitzCache.sql","sp_BlitzCache","@MinimumExecutionCount","境界値","@MinimumExecutionCount=0で全クエリが対象になること","プランキャッシュにデータあり","@MinimumExecutionCount=0","全クエリが結果に含まれる","中","境界値テスト"
"34","UT-BLC-034","sp_BlitzCache.sql","sp_BlitzCache","@MinutesBack","正常系","@MinutesBackで時間フィルタが適用されること","最近実行されたプランあり","@MinutesBack=60","過去60分以内に実行されたクエリのみ返却される","高","時間フィルタ機能"
"35","UT-BLC-035","sp_BlitzCache.sql","sp_BlitzCache","@MinutesBack","正常系","正の値が負の値に変換されること","プランキャッシュにデータあり","@MinutesBack=60","内部で-60として処理される","中","値変換ロジック"
"36","UT-BLC-036","sp_BlitzCache.sql","sp_BlitzCache","@MinutesBack","境界値","@MinutesBack=0が-1に変換されること","プランキャッシュにデータあり","@MinutesBack=0","内部で-1として処理される（警告メッセージ付き）","中","境界値テスト"
"37","UT-BLC-037","sp_BlitzCache.sql","sp_BlitzCache","@OnlyQueryHashes","正常系","特定クエリハッシュでフィルタリングされること","対象クエリハッシュがキャッシュにあり","@OnlyQueryHashes='0x1234567890ABCDEF'","指定されたクエリハッシュのプランのみ返却される","高","クエリハッシュフィルタ"
"38","UT-BLC-038","sp_BlitzCache.sql","sp_BlitzCache","@OnlyQueryHashes","正常系","複数クエリハッシュがカンマ区切りで指定可能なこと","複数対象クエリハッシュがキャッシュにあり","@OnlyQueryHashes='0x1234,0x5678'","指定された全クエリハッシュのプランが返却される","中","複数指定機能"
"39","UT-BLC-039","sp_BlitzCache.sql","sp_BlitzCache","@IgnoreQueryHashes","正常系","特定クエリハッシュが除外されること","対象クエリハッシュがキャッシュにあり","@IgnoreQueryHashes='0x1234567890ABCDEF'","指定されたクエリハッシュが結果から除外される","高","クエリハッシュ除外"
"40","UT-BLC-040","sp_BlitzCache.sql","sp_BlitzCache","@OnlySqlHandles","正常系","特定SQLハンドルでフィルタリングされること","対象SQLハンドルがキャッシュにあり","@OnlySqlHandles='0x1234...'","指定されたSQLハンドルのプランのみ返却される","高","SQLハンドルフィルタ"
"41","UT-BLC-041","sp_BlitzCache.sql","sp_BlitzCache","@IgnoreSqlHandles","正常系","特定SQLハンドルが除外されること","対象SQLハンドルがキャッシュにあり","@IgnoreSqlHandles='0x1234...'","指定されたSQLハンドルが結果から除外される","中","SQLハンドル除外"
"42","UT-BLC-042","sp_BlitzCache.sql","sp_BlitzCache","@StoredProcName","正常系","特定ストアドプロシージャのプランが返却されること","対象プロシージャがキャッシュにあり","@StoredProcName='usp_Test'","指定されたストアドプロシージャのプランのみ返却される","高","プロシージャフィルタ"
"43","UT-BLC-043","sp_BlitzCache.sql","sp_BlitzCache","@SlowlySearchPlansFor","正常系","プラン内テキスト検索が動作すること","検索対象文字列を含むプランあり","@SlowlySearchPlansFor='CONVERT_IMPLICIT'","指定文字列を含むプランのみ返却される","中","テキスト検索機能（低速）"
"44","UT-BLC-044","sp_BlitzCache.sql","sp_BlitzCache","@SlowlySearchPlansFor","正常系","ワイルドカード検索が動作すること","検索対象パターンを含むプランあり","@SlowlySearchPlansFor='%IndexScan%'","パターンに一致するプランが返却される","中","ワイルドカード検索"
"45","UT-BLC-045","sp_BlitzCache.sql","sp_BlitzCache","@ExpertMode","正常系","@ExpertMode=0で基本カラムのみ返却されること","プランキャッシュにデータあり","@ExpertMode=0","基本的な分析カラムのみ返却される","高","出力モード制御"
"46","UT-BLC-046","sp_BlitzCache.sql","sp_BlitzCache","@ExpertMode","正常系","@ExpertMode=1で追加カラムが返却されること","プランキャッシュにデータあり","@ExpertMode=1","詳細な分析カラムが追加で返却される","高","エキスパートモード"
"47","UT-BLC-047","sp_BlitzCache.sql","sp_BlitzCache","@ExpertMode","正常系","@ExpertMode=2でOpserver最適化出力されること","プランキャッシュにデータあり","@ExpertMode=2","Opserver用に最適化された出力形式","中","Opserverモード"
"48","UT-BLC-048","sp_BlitzCache.sql","sp_BlitzCache","@ExportToExcel","正常系","@ExportToExcel=1でExcel用フォーマットになること","プランキャッシュにデータあり","@ExportToExcel=1","改行除去、クエリプラン非表示のExcel用出力","中","Excel出力機能"
"49","UT-BLC-049","sp_BlitzCache.sql","sp_BlitzCache","@HideSummary","正常系","@HideSummary=1でサマリが非表示になること","プランキャッシュにデータあり","@HideSummary=1","FindingsGroupサマリ結果セットが表示されない","中","サマリ非表示機能"
"50","UT-BLC-050","sp_BlitzCache.sql","sp_BlitzCache","@Reanalyze","正常系","@Reanalyze=1で既存データを再分析すること","##BlitzCacheProcsにデータあり","@Reanalyze=1","既存の##BlitzCacheProcsデータを再分析して表示","中","再分析機能"
"51","UT-BLC-051","sp_BlitzCache.sql","sp_BlitzCache","@Reanalyze","異常系","##BlitzCacheProcsがない場合にReanalyzeが無効化されること","##BlitzCacheProcsが存在しない","@Reanalyze=1","警告メッセージが出力され、通常分析が実行される","中","再分析エラー処理"
"52","UT-BLC-052","sp_BlitzCache.sql","sp_BlitzCache","@SkipAnalysis","正常系","@SkipAnalysis=1で詳細分析がスキップされること","プランキャッシュにデータあり","@SkipAnalysis=1","警告分析がスキップされ、サマリが非表示","中","分析スキップ機能"
"53","UT-BLC-053","sp_BlitzCache.sql","sp_BlitzCache","@BringThePain","正常系","@BringThePain=1で大量データ取得が許可されること","@SortOrder='all'、@Top=20","@BringThePain=1, @SortOrder='all', @Top=20","@Top>10の全ソート処理が実行される","中","大量データ処理許可"
"54","UT-BLC-054","sp_BlitzCache.sql","sp_BlitzCache","@BringThePain","異常系","@BringThePain=0で大量データ取得がエラーになること","@SortOrder='all'、@Top=20","@BringThePain=0, @SortOrder='all', @Top=20","エラーメッセージが返却される","中","大量データ処理制限"
"55","UT-BLC-055","sp_BlitzCache.sql","sp_BlitzCache","@OutputType","正常系","@OutputType='TABLE'で通常出力されること","プランキャッシュにデータあり","@OutputType='TABLE'","結果セットがテーブル形式で返却される","高","出力タイプ制御"
"56","UT-BLC-056","sp_BlitzCache.sql","sp_BlitzCache","@OutputType","正常系","@OutputType='NONE'で結果セットなしになること","@Output*パラメータが全て指定","@OutputType='NONE', @OutputDatabaseName='DB', @OutputSchemaName='dbo', @OutputTableName='Results'","結果セットが返却されず、テーブルに保存される","中","NONE出力タイプ"
"57","UT-BLC-057","sp_BlitzCache.sql","sp_BlitzCache","@OutputType","異常系","@OutputType='NONE'で@Output*パラメータ不足時エラーになること","@OutputDatabaseName等が未指定","@OutputType='NONE'","エラーメッセージが返却される","高","入力バリデーション"
"58","UT-BLC-058","sp_BlitzCache.sql","sp_BlitzCache","出力テーブル","正常系","既存テーブルへの出力が動作すること","出力先テーブルが存在","@OutputDatabaseName='DB', @OutputSchemaName='dbo', @OutputTableName='Results'","指定テーブルにデータが挿入される","高","テーブル出力機能"
"59","UT-BLC-059","sp_BlitzCache.sql","sp_BlitzCache","出力テーブル","正常系","新規テーブルへの出力が動作すること","出力先テーブルが存在しない","@OutputDatabaseName='DB', @OutputSchemaName='dbo', @OutputTableName='NewResults'","テーブルが作成され、データが挿入される","高","テーブル自動作成"
"60","UT-BLC-060","sp_BlitzCache.sql","sp_BlitzCache","出力テーブル","正常系","グローバル一時テーブル(##)への出力が動作すること","出力先が##テーブル","@OutputTableName='##TempResults'","グローバル一時テーブルが作成され、データが挿入される","中","一時テーブル出力"
"61","UT-BLC-061","sp_BlitzCache.sql","sp_BlitzCache","出力テーブル","異常系","ローカル一時テーブル(#)への出力がエラーになること","出力先が#テーブル","@OutputTableName='#TempResults'","エラーメッセージ（##のみサポート）","中","一時テーブル制限"
"62","UT-BLC-062","sp_BlitzCache.sql","sp_BlitzCache","出力テーブル","異常系","予約テーブル名への出力がエラーになること","予約名を指定","@OutputTableName='##BlitzCacheProcs'","エラーメッセージ（予約名は使用不可）","中","予約名チェック"
"63","UT-BLC-063","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Missing Indexが検出されること","欠落インデックスを持つプランあり","デフォルトパラメータ","Warnings列に「Missing Indexes」が含まれる","高","警告検出機能"
"64","UT-BLC-064","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Implicit Conversionが検出されること","暗黙変換を持つプランあり","デフォルトパラメータ","Warnings列に「Implicit Conversions」が含まれる","高","警告検出機能"
"65","UT-BLC-065","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Parameter Sniffingが検出されること","パラメータスニッフィング問題のあるプランあり","デフォルトパラメータ","Warnings列に「Parameter Sniffing」が含まれる","高","警告検出機能"
"66","UT-BLC-066","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Parallel Planが検出されること","並列プランあり","デフォルトパラメータ","Warnings列に「Parallel」が含まれる","中","警告検出機能"
"67","UT-BLC-067","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Long Running Queryが検出されること","長時間実行クエリあり","デフォルトパラメータ","Warnings列に「Long Running Query」が含まれる","高","警告検出機能"
"68","UT-BLC-068","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Table Variableが検出されること","テーブル変数を使用するプランあり","デフォルトパラメータ","Warnings列に「Table Variables」が含まれる","中","警告検出機能"
"69","UT-BLC-069","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Cursorが検出されること","カーソルを使用するプランあり","デフォルトパラメータ","Warnings列に「Cursor」が含まれる","中","警告検出機能"
"70","UT-BLC-070","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Forced Planが検出されること","強制プランあり","デフォルトパラメータ","Warnings列に「Forced Plan」が含まれる","中","警告検出機能"
"71","UT-BLC-071","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Key Lookupが検出されること","高コストKey Lookupを持つプランあり","デフォルトパラメータ","Warnings列に「Expensive Key Lookup」が含まれる","高","警告検出機能"
"72","UT-BLC-072","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Table Scanが検出されること","テーブルスキャンを持つプランあり","デフォルトパラメータ","Warnings列に「Table Scans」が含まれる","中","警告検出機能"
"73","UT-BLC-073","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Expensive Sortが検出されること","高コストソートを持つプランあり","デフォルトパラメータ","Warnings列に「Expensive Sort」が含まれる","中","警告検出機能"
"74","UT-BLC-074","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Spillsが検出されること","SQL Server 2016以降、スピルを持つプランあり","デフォルトパラメータ","Warnings列に「>500mb spills」が含まれる","高","警告検出機能"
"75","UT-BLC-075","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Compile Timeoutが検出されること","コンパイルタイムアウトを持つプランあり","デフォルトパラメータ","Warnings列に「Compilation Timeout」が含まれる","高","警告検出機能"
"76","UT-BLC-076","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Unparameterized Queryが検出されること","@ExpertMode=1、パラメータ化されていないクエリあり","@ExpertMode=1","Warnings分析でunparameterized_query=1が設定される","中","警告検出機能"
"77","UT-BLC-077","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","TVF Joinが検出されること","TVFとJOINするプランあり","デフォルトパラメータ","Warnings列に「Function Join」が含まれる","中","警告検出機能"
"78","UT-BLC-078","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Non-SARGable predicateが検出されること","SARGable でない述語を持つプランあり","デフォルトパラメータ","Warnings列に「non-SARGables」が含まれる","高","警告検出機能"
"79","UT-BLC-079","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Multiple Plansが検出されること","同一クエリに複数プランあり","デフォルトパラメータ","Warnings列に「Multiple Plans」が含まれる","中","警告検出機能"
"80","UT-BLC-080","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Trivial Planが検出されること","Trivialプランあり","デフォルトパラメータ","Warnings列に「Trivial Plans」が含まれる","低","警告検出機能"
"81","UT-BLC-081","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","Row Goalsが検出されること","SQL Server 2017以降、Row Goalを持つプランあり","デフォルトパラメータ","Warnings列に「Row Goals」が含まれる","中","警告検出機能"
"82","UT-BLC-082","sp_BlitzCache.sql","sp_BlitzCache","警告検出","正常系","警告がない場合のメッセージが表示されること","問題のないプランのみ","デフォルトパラメータ","Warnings列に「No warnings detected」が含まれる","低","警告なし検出"
"83","UT-BLC-083","sp_BlitzCache.sql","sp_BlitzCache","@UseTriggersAnyway","正常系","@UseTriggersAnyway=1でトリガー情報が含まれること","SQL Server 2008R2、トリガーがキャッシュにあり","@UseTriggersAnyway=1","トリガー実行統計が結果に含まれる（不正確な可能性あり）","低","レガシートリガーサポート"
"84","UT-BLC-084","sp_BlitzCache.sql","sp_BlitzCache","@Debug","正常系","@Debug=1でデバッグ情報が出力されること","プランキャッシュにデータあり","@Debug=1","動的SQL、中間テーブルデータが出力される","低","デバッグモード"
"85","UT-BLC-085","sp_BlitzCache.sql","sp_BlitzCache","@KeepCRLF","正常系","@KeepCRLF=1で改行が保持されること","複数行クエリがキャッシュにあり","@KeepCRLF=1","QueryText内の改行が保持される","低","改行保持機能"
"86","UT-BLC-086","sp_BlitzCache.sql","sp_BlitzCache","@KeepCRLF","正常系","@KeepCRLF=0で改行が削除されること","複数行クエリがキャッシュにあり","@KeepCRLF=0","QueryText内の改行がスペースに置換される","低","改行削除機能"
"87","UT-BLC-087","sp_BlitzCache.sql","sp_BlitzCache","Configuration Table","正常系","設定テーブルから閾値が読み込まれること","設定テーブルが存在","@ConfigurationDatabaseName='DB', @ConfigurationSchemaName='dbo', @ConfigurationTableName='Config'","設定テーブルの値が分析閾値として使用される","中","外部設定機能"
"88","UT-BLC-088","sp_BlitzCache.sql","sp_BlitzCache","@IgnoreReadableReplicaDBs","正常系","@IgnoreReadableReplicaDBs=1で可用性グループセカンダリが除外されること","AGセカンダリDBあり","@IgnoreReadableReplicaDBs=1","読み取り可能セカンダリのプランが除外される","中","AG対応機能"
"89","UT-BLC-089","sp_BlitzCache.sql","sp_BlitzCache","バージョンチェック","異常系","SQL Server 2008より前のバージョンでエラーになること","SQL Server 2005","実行","エラーメッセージ「sp_BlitzCache doesn't work on versions of SQL prior to 2008」","高","バージョン互換性"
"90","UT-BLC-090","sp_BlitzCache.sql","sp_BlitzCache","Azure対応","異常系","Azure SQL DBで別データベース指定時エラーになること","Azure SQL DB","@DatabaseName='OtherDB'（現在のDBと異なる）","エラーメッセージ「Azure SQL DB does not allow you to change databases」","高","Azure互換性"
"91","UT-BLC-091","sp_BlitzCache.sql","sp_BlitzCache","AI機能","正常系","@AI=1でAIアドバイスが取得されること","Azure SQL DB、sp_invoke_external_rest_endpoint利用可、AIクレデンシャル設定済","@AI=1, @ExpertMode=1（自動設定）","ai_advice列にAIからのアドバイスが格納される","中","AI分析機能"
"92","UT-BLC-092","sp_BlitzCache.sql","sp_BlitzCache","AI機能","正常系","@AI=2でAIプロンプトのみ生成されること","プランキャッシュにデータあり","@AI=2","ai_prompt列にプロンプトが格納され、ai_adviceには未送信メッセージ","中","AIプロンプト生成"
"93","UT-BLC-093","sp_BlitzCache.sql","sp_BlitzCache","AI機能","正常系","@AIModelでモデル指定が動作すること","AI設定済","@AI=1, @AIModel='gpt-4.1-mini'","指定モデルでAIリクエストが実行される","低","AIモデル指定"
"94","UT-BLC-094","sp_BlitzCache.sql","sp_BlitzCache","AI機能","正常系","@AIURLでカスタムエンドポイントが使用されること","AI設定済","@AI=1, @AIURL='https://custom.api.com/v1/chat'","指定URLにAIリクエストが送信される","低","AIエンドポイント指定"
"95","UT-BLC-095","sp_BlitzCache.sql","sp_BlitzCache","AI機能","正常系","@AIConfigテーブルから設定が読み込まれること","AI設定テーブルが存在","@AI=1, @AIConfig='dbo.AI_Services'","設定テーブルからモデル、URL、クレデンシャルが読み込まれる","低","AI設定テーブル"
"96","UT-BLC-096","sp_BlitzCache.sql","sp_BlitzCache","AI機能","異常系","sp_invoke_external_rest_endpointがない場合@AI=2に降格すること","非Azure環境","@AI=1","警告メッセージが出力され、@AI=2として動作","中","AI機能降格"
"97","UT-BLC-097","sp_BlitzCache.sql","sp_BlitzCache","AI機能","異常系","AI設定不足時にエラーになること","設定不完全","@AI=1, @AIModel=NULL, @AIURL=NULL（設定テーブルもなし）","エラーメッセージが返却される","中","AI設定バリデーション"
"98","UT-BLC-098","sp_BlitzCache.sql","sp_BlitzCache","リンクサーバー出力","正常系","リンクサーバー経由で出力可能なこと","リンクサーバー設定済、永続テーブル指定","@OutputServerName='LinkedServer', @OutputDatabaseName='DB', @OutputSchemaName='dbo', @OutputTableName='Results'","リンクサーバー上のテーブルにデータが挿入される","低","リンクサーバー出力"
"99","UT-BLC-099","sp_BlitzCache.sql","sp_BlitzCache","リンクサーバー出力","異常系","リンクサーバーへの一時テーブル出力がエラーになること","リンクサーバー設定済","@OutputServerName='LinkedServer', @OutputTableName='##TempResults'","エラーメッセージ「outputting to a linked server requires a permanent table」","低","リンクサーバー制限"
"100","UT-BLC-100","sp_BlitzCache.sql","sp_BlitzCache","パラメータバリデーション","異常系","必須パラメータがNULLの場合エラーになること","パラメータがNULL設定","@Top=NULL, @SortOrder=NULL, @QueryFilter=NULL, @Reanalyze=NULL","エラーメッセージ「Several parameters are required. Do not set them to NULL」","高","入力バリデーション"
"101","UT-BLC-101","sp_BlitzCache.sql","sp_BlitzCache","サマリ出力","正常系","FindingsGroupサマリが正しく出力されること","様々な問題を持つプランあり","@HideSummary=0","##BlitzCacheResultsから優先度順にサマリが表示される","高","サマリ出力機能"
"102","UT-BLC-102","sp_BlitzCache.sql","sp_BlitzCache","サマリ出力","正常系","Plan Cache Stability情報が出力されること","プランキャッシュにデータあり","デフォルトパラメータ","プラン作成時間分布（24時間、4時間、1時間）が表示される","中","キャッシュ安定性分析"
"103","UT-BLC-103","sp_BlitzCache.sql","sp_BlitzCache","サマリ出力","正常系","Duplicate Plans情報が出力されること","重複プランあり","デフォルトパラメータ","重複プランの割合情報が表示される","中","重複プラン分析"
"104","UT-BLC-104","sp_BlitzCache.sql","sp_BlitzCache","サマリ出力","正常系","Single-Use Plans情報が出力されること","単一使用プランあり","デフォルトパラメータ","単一使用プランの割合情報が表示される","中","単一使用プラン分析"
"105","UT-BLC-105","sp_BlitzCache.sql","sp_BlitzCache","サマリ出力","正常系","Global Trace Flags情報が出力されること","SQL Server 2012以降、トレースフラグ有効","デフォルトパラメータ","有効なグローバルトレースフラグが表示される","低","トレースフラグ検出"
"106","UT-BLC-106","sp_BlitzCache.sql","sp_BlitzCache","QueryPlanCost","正常系","QueryPlanCostが正しく計算されること","コストを持つプランあり","デフォルトパラメータ","QueryPlanCost列に正しいコスト値が格納される","中","コスト計算機能"
"107","UT-BLC-107","sp_BlitzCache.sql","sp_BlitzCache","Missing Index詳細","正常系","Missing Index詳細情報が取得されること","欠落インデックスを持つプランあり、@ExpertMode=1","@ExpertMode=1","missing_indexes列にXML形式の詳細情報が格納される","中","欠落インデックス詳細"
"108","UT-BLC-108","sp_BlitzCache.sql","sp_BlitzCache","Implicit Conversion詳細","正常系","Implicit Conversion詳細情報が取得されること","暗黙変換を持つプランあり、@ExpertMode=1","@ExpertMode=1","implicit_conversion_info列にXML形式の詳細情報が格納される","中","暗黙変換詳細"
"109","UT-BLC-109","sp_BlitzCache.sql","sp_BlitzCache","Air Quote Actual Plans","正常系","SQL Server 2019以降でActual Plansが取得されること","SQL Server 2019以降、dm_exec_query_plan_stats利用可","デフォルトパラメータ","より詳細な実行プランが取得される","中","実行プラン拡張"
"110","UT-BLC-110","sp_BlitzCache.sql","sp_BlitzCache","メモリプレッシャー検出","正常系","USERSTORE_TOKENPERM肥大化が検出されること","トークンストアが大きい環境","デフォルトパラメータ","サマリに「Large USERSTORE_TOKENPERM cache」警告が表示される","中","メモリ問題検出"
