"No","テストID","対象ファイル","対象クラス/関数","対象メソッド","テスト観点","テストケース名","前提条件","入力値","期待結果","優先度","備考"
"1","UT-BLZ-001","sp_Blitz.sql","sp_Blitz","N/A","正常系","ヘルプモードで実行した場合にヘルプテキストが出力されること","SQL Server接続済み","@Help = 1","ヘルプテキストがPRINTで出力され、RETURNで終了","中","@Help = 1 でヘルプ情報を表示"
"2","UT-BLZ-002","sp_Blitz.sql","sp_Blitz","N/A","正常系","バージョンチェックモードで実行した場合に即時終了すること","SQL Server接続済み","@VersionCheckMode = 1","何も出力せずRETURNで終了","中","バージョン確認のみを行う軽量モード"
"3","UT-BLZ-003","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'TABLE' で結果がテーブル形式で返却されること","SQL Server接続済み","@OutputType = 'TABLE'","Priority, FindingsGroup, Finding, DatabaseName, URL, Details, QueryPlan, QueryPlanFiltered, CheckIDの列を持つ結果セットが返却","高","デフォルト出力形式"
"4","UT-BLZ-004","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'COUNT' で検出件数のみ返却されること","SQL Server接続済み","@OutputType = 'COUNT'","Warnings列に数値が返却される単一行の結果セット","中","カウントモード"
"5","UT-BLZ-005","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'SCHEMA' でスキーマ情報のみ返却されること","SQL Server接続済み","@OutputType = 'SCHEMA'","FieldList列にスキーマ定義文字列が返却","中","スキーマ確認用"
"6","UT-BLZ-006","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'CSV' でCSV形式の結果が返却されること","SQL Server接続済み","@OutputType = 'CSV'","カンマ区切りのResult列が返却","中","CSV出力形式"
"7","UT-BLZ-007","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'RSV' でRSV形式の結果が返却されること","SQL Server接続済み","@OutputType = 'RSV'","CHAR(31)区切りのResult列が返却","低","RSV出力形式"
"8","UT-BLZ-008","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'MARKDOWN' でMarkdown形式の結果が返却されること","SQL Server接続済み","@OutputType = 'MARKDOWN'","Markdown形式のテキストが返却","中","Markdown出力形式"
"9","UT-BLZ-009","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'XML' でXML形式の結果が返却されること","SQL Server接続済み","@OutputType = 'XML'","sp_Blitz_OutputをルートとするXMLが返却","中","XML出力形式"
"10","UT-BLZ-010","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputType = 'NONE' で結果が返却されないこと","SQL Server接続済み","@OutputType = 'NONE'","結果セットが返却されない","中","出力なしモード"
"11","UT-BLZ-011","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckUserDatabaseObjects = 1 でユーザーデータベースオブジェクトがチェックされること","SQL Server接続済み、ユーザーデータベースが存在","@CheckUserDatabaseObjects = 1","ユーザーデータベース関連のチェック結果が含まれる","高","ユーザーDB対象チェック"
"12","UT-BLZ-012","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckUserDatabaseObjects = 0 でユーザーデータベースオブジェクトがスキップされること","SQL Server接続済み","@CheckUserDatabaseObjects = 0","ユーザーデータベース関連のチェックがスキップされる","中","ユーザーDBスキップ"
"13","UT-BLZ-013","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckProcedureCache = 1 でプロシージャキャッシュがチェックされること","SQL Server接続済み、プロシージャキャッシュに実行計画が存在","@CheckProcedureCache = 1","プロシージャキャッシュ関連のチェック結果が含まれる","中","プロシージャキャッシュ分析"
"14","UT-BLZ-014","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputProcedureCache = 1 でプロシージャキャッシュ詳細が出力されること","SQL Server接続済み","@CheckProcedureCache = 1, @OutputProcedureCache = 1","プロシージャキャッシュの上位20件が2つ目の結果セットとして返却","中","キャッシュ詳細出力"
"15","UT-BLZ-015","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckProcedureCacheFilter = 'CPU' でCPU順にソートされること","SQL Server接続済み","@CheckProcedureCache = 1, @OutputProcedureCache = 1, @CheckProcedureCacheFilter = 'CPU'","total_worker_time降順でソートされた結果","中","CPUフィルタ"
"16","UT-BLZ-016","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckProcedureCacheFilter = 'Reads' でReads順にソートされること","SQL Server接続済み","@CheckProcedureCache = 1, @OutputProcedureCache = 1, @CheckProcedureCacheFilter = 'Reads'","total_logical_reads降順でソートされた結果","中","Readsフィルタ"
"17","UT-BLZ-017","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckProcedureCacheFilter = 'Duration' でDuration順にソートされること","SQL Server接続済み","@CheckProcedureCache = 1, @OutputProcedureCache = 1, @CheckProcedureCacheFilter = 'Duration'","total_elapsed_time降順でソートされた結果","中","Durationフィルタ"
"18","UT-BLZ-018","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckProcedureCacheFilter = 'ExecCount' で実行回数順にソートされること","SQL Server接続済み","@CheckProcedureCache = 1, @OutputProcedureCache = 1, @CheckProcedureCacheFilter = 'ExecCount'","execution_count降順でソートされた結果","中","ExecCountフィルタ"
"19","UT-BLZ-019","sp_Blitz.sql","sp_Blitz","N/A","正常系","@CheckServerInfo = 1 でサーバー情報が含まれること","SQL Server接続済み","@CheckServerInfo = 1","FindingsGroup = 'Server Info' のレコードが含まれる","中","サーバー情報チェック"
"20","UT-BLZ-020","sp_Blitz.sql","sp_Blitz","N/A","正常系","@IgnorePrioritiesBelow で指定値未満の優先度がフィルタされること","SQL Server接続済み","@IgnorePrioritiesBelow = 50","Priority < 50 のレコードが結果から除外される","中","優先度下限フィルタ"
"21","UT-BLZ-021","sp_Blitz.sql","sp_Blitz","N/A","正常系","@IgnorePrioritiesAbove で指定値超の優先度がフィルタされること","SQL Server接続済み","@IgnorePrioritiesAbove = 100","Priority > 100 のレコードが結果から除外される","中","優先度上限フィルタ"
"22","UT-BLZ-022","sp_Blitz.sql","sp_Blitz","N/A","正常系","@SummaryMode = 1 で重複結果がサマリー化されること","SQL Server接続済み","@SummaryMode = 1","同一Finding, FindingsGroup, Priorityのレコードが集約され件数付きで表示","中","サマリーモード"
"23","UT-BLZ-023","sp_Blitz.sql","sp_Blitz","N/A","正常系","@BringThePain = 1 で50以上のDBでもチェックが実行されること","SQL Server接続済み、50以上のデータベースが存在","@BringThePain = 1, @CheckUserDatabaseObjects = 1","大規模環境でもユーザーDBチェックが実行される","中","大規模環境対応"
"24","UT-BLZ-024","sp_Blitz.sql","sp_Blitz","N/A","正常系","@Debug = 1 でデバッグメッセージが出力されること","SQL Server接続済み","@Debug = 1","RAISERRORによるデバッグメッセージが出力される","低","デバッグモード1"
"25","UT-BLZ-025","sp_Blitz.sql","sp_Blitz","N/A","正常系","@Debug = 2 で動的SQLも出力されること","SQL Server接続済み","@Debug = 2","デバッグメッセージに加え、動的SQLがPRINTされる","低","デバッグモード2"
"26","UT-BLZ-026","sp_Blitz.sql","sp_Blitz","N/A","正常系","@SkipChecksTable 指定でスキップ対象チェックが除外されること","SQL Server接続済み、スキップテーブルが存在","@SkipChecksDatabase = 'DBAtools', @SkipChecksSchema = 'dbo', @SkipChecksTable = 'BlitzChecksToSkip'","スキップテーブルに登録されたチェックが結果から除外される","高","スキップチェック機能"
"27","UT-BLZ-027","sp_Blitz.sql","sp_Blitz","N/A","正常系","@SkipChecksServer 指定でリモートサーバーのスキップテーブルが参照されること","SQL Server接続済み、リンクサーバーとスキップテーブルが存在","@SkipChecksServer = 'LinkedServer', @SkipChecksDatabase = 'DBAtools', @SkipChecksSchema = 'dbo', @SkipChecksTable = 'BlitzChecksToSkip'","リンクサーバー上のスキップテーブルが参照される","中","リモートスキップチェック"
"28","UT-BLZ-028","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputDatabaseName/SchemaName/TableName で結果がテーブルに保存されること","SQL Server接続済み、出力先スキーマが存在","@OutputDatabaseName = 'DBAtools', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzResults'","指定テーブルに結果が挿入される","高","テーブル出力"
"29","UT-BLZ-029","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputServerName 指定でリンクサーバーに結果が出力されること","SQL Server接続済み、リンクサーバーと出力先DBが存在","@OutputServerName = 'LinkedServer', @OutputDatabaseName = 'DBAtools', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzResults'","リンクサーバー上のテーブルに結果が挿入される","中","リモートテーブル出力"
"30","UT-BLZ-030","sp_Blitz.sql","sp_Blitz","N/A","正常系","@OutputXMLasNVARCHAR = 1 でQueryPlanがNVARCHARとして出力されること","SQL Server接続済み","@OutputXMLasNVARCHAR = 1","QueryPlan列がXML型ではなくNVARCHAR(MAX)で返却","中","XMLをNVARCHAR変換"
"31","UT-BLZ-031","sp_Blitz.sql","sp_Blitz","N/A","正常系","@EmailRecipients 指定で結果がメール送信されること","SQL Server接続済み、Database Mailが設定済み","@EmailRecipients = 'admin@example.com'","sp_send_dbmailが呼び出され結果がCSV添付でメール送信される","中","メール送信機能"
"32","UT-BLZ-032","sp_Blitz.sql","sp_Blitz","N/A","正常系","@EmailProfile 指定で指定プロファイルでメール送信されること","SQL Server接続済み、Database Mailプロファイルが設定済み","@EmailRecipients = 'admin@example.com', @EmailProfile = 'DBMailProfile'","指定プロファイルでメールが送信される","中","メールプロファイル指定"
"33","UT-BLZ-033","sp_Blitz.sql","sp_Blitz","N/A","正常系","@UsualDBOwner 指定で期待オーナーと異なるDBが検出されること","SQL Server接続済み、DBが存在","@UsualDBOwner = 'sa'","DBオーナーがsaでないデータベースが検出される","中","DBオーナーチェック"
"34","UT-BLZ-034","sp_Blitz.sql","sp_Blitz","N/A","正常系","@UsualOwnerOfJobs 指定で期待オーナーと異なるジョブが検出されること","SQL Server接続済み、SQL Agentジョブが存在","@UsualOwnerOfJobs = 'sa'","ジョブオーナーがsaでないジョブが検出される","中","ジョブオーナーチェック"
"35","UT-BLZ-035","sp_Blitz.sql","sp_Blitz","N/A","正常系","@SkipBlockingChecks = 1 でブロッキングチェックがスキップされること","SQL Server接続済み","@SkipBlockingChecks = 1","ブロッキング関連のチェックがスキップされる","中","ブロッキングチェックスキップ"
"36","UT-BLZ-036","sp_Blitz.sql","sp_Blitz","N/A","正常系","@Version OUTPUT で現在のバージョンが取得できること","SQL Server接続済み","DECLARE @Ver VARCHAR(30); EXEC sp_Blitz @Version = @Ver OUTPUT","@Versionにバージョン文字列が設定される","中","バージョン取得"
"37","UT-BLZ-037","sp_Blitz.sql","sp_Blitz","N/A","正常系","@VersionDate OUTPUT で現在のバージョン日付が取得できること","SQL Server接続済み","DECLARE @VerDate DATETIME; EXEC sp_Blitz @VersionDate = @VerDate OUTPUT","@VersionDateにバージョン日付が設定される","中","バージョン日付取得"
"38","UT-BLZ-038","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 1: 7日以上バックアップされていないDBが検出されること","バックアップが7日以上前のDBが存在","デフォルトパラメータ","CheckID = 1, FindingsGroup = 'Backup', Finding = 'Backups Not Performed Recently' のレコード","高","バックアップ未実施チェック"
"39","UT-BLZ-039","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 2: フルリカバリモデルでログバックアップ未実施のDBが検出されること","フルリカバリモデルでログバックアップが7日以上前のDBが存在","デフォルトパラメータ","CheckID = 2, Finding = 'Full Recovery Model w/o Log Backups' のレコード","高","ログバックアップ未実施チェック"
"40","UT-BLZ-040","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 4: sysadminロールのログインが検出されること","sysadminロールに複数のログインが存在","デフォルトパラメータ","CheckID = 4, FindingsGroup = 'Security', Finding = 'Sysadmins' のレコード","高","sysadminチェック"
"41","UT-BLZ-041","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 6: ユーザーが所有するジョブが検出されること","sa以外がオーナーの有効ジョブが存在","デフォルトパラメータ","CheckID = 6, Finding = 'Jobs Owned By Users' のレコード","中","ジョブオーナーチェック"
"42","UT-BLZ-042","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 12: Auto-Close有効のDBが検出されること","is_auto_close_on = 1のDBが存在","デフォルトパラメータ","CheckID = 12, Finding = 'Auto-Close Enabled' のレコード","高","Auto-Closeチェック"
"43","UT-BLZ-043","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 13: Auto-Shrink有効のDBが検出されること","is_auto_shrink_on = 1のDBが存在","デフォルトパラメータ","CheckID = 13, Finding = 'Auto-Shrink Enabled' のレコード","高","Auto-Shrinkチェック"
"44","UT-BLZ-044","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 14: ページ検証がCHECKSUM以外のDBが検出されること","page_verify_option < 2のDBが存在","デフォルトパラメータ","CheckID = 14, Finding = 'Page Verification Not Optimal' のレコード","高","ページ検証チェック"
"45","UT-BLZ-045","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 21: TDE有効のDBが検出されること","is_encrypted = 1のDBが存在","デフォルトパラメータ","CheckID = 21, Finding = 'Database Encrypted' のレコード","中","TDEチェック"
"46","UT-BLZ-046","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 22: デフォルト以外のサーバー構成が検出されること","sp_configureの値がデフォルトと異なる設定が存在","デフォルトパラメータ","CheckID >= 1001, FindingsGroup = 'Non-Default Server Config' のレコード","中","サーバー構成チェック"
"47","UT-BLZ-047","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 68: 最新の正常DBCC CHECKDBが古いDBが検出されること","DBCC CHECKDBが7日以上前のDBが存在","sysadmin権限で実行","CheckID = 68 のレコード","高","DBCC CHECKDBチェック"
"48","UT-BLZ-048","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 69: VLF数が多いDBが検出されること","VLF数が50以上のDBが存在","sysadmin権限で実行","CheckID = 69 のレコード","中","VLFチェック"
"49","UT-BLZ-049","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 73: フェイルセーフオペレーターが未設定の場合に検出されること","フェイルセーフオペレーターが未設定","デフォルトパラメータ","CheckID = 73 のレコード","中","フェイルセーフオペレーターチェック"
"50","UT-BLZ-050","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 92: ドライブ空き容量情報が出力されること","@CheckServerInfo = 1","@CheckServerInfo = 1","CheckID = 92, Finding LIKE 'Drive%Space' のレコード","中","ドライブ空き容量"
"51","UT-BLZ-051","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 93: DBファイルと同じドライブにバックアップが検出されること","DBファイルと同じドライブにバックアップが存在","デフォルトパラメータ","CheckID = 93, Finding = 'Backing Up to Same Drive Where Databases Reside' のレコード","高","バックアップ先チェック"
"52","UT-BLZ-052","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 119: TDE証明書が30日以上バックアップされていない場合に検出されること","TDE証明書のバックアップが30日以上前","デフォルトパラメータ","CheckID = 119, Finding = 'TDE Certificate Not Backed Up Recently' のレコード","高","TDE証明書バックアップチェック"
"53","UT-BLZ-053","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 152: 待機統計の上位9件が出力されること","@CheckServerInfo = 1、待機統計が存在","@CheckServerInfo = 1","CheckID = 152, FindingsGroup = 'Wait Stats' のレコード（最大9件）","中","待機統計チェック"
"54","UT-BLZ-054","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 211: 電源プランが出力されること（Windows環境）","Windows環境で@CheckServerInfo = 1","@CheckServerInfo = 1","CheckID = 211, Finding = 'Power Plan' のレコード","中","電源プランチェック"
"55","UT-BLZ-055","sp_Blitz.sql","sp_Blitz","N/A","境界値","@IgnorePrioritiesBelow = 0 で全てのチェック結果が含まれること","SQL Server接続済み","@IgnorePrioritiesBelow = 0","Priority >= 0 の全レコードが含まれる","低","優先度下限境界値"
"56","UT-BLZ-056","sp_Blitz.sql","sp_Blitz","N/A","境界値","@IgnorePrioritiesAbove = 255 で全てのチェック結果が含まれること","SQL Server接続済み","@IgnorePrioritiesAbove = 255","Priority <= 255 の全レコードが含まれる","低","優先度上限境界値"
"57","UT-BLZ-057","sp_Blitz.sql","sp_Blitz","N/A","境界値","@IgnorePrioritiesBelow = 255 で結果がほぼ空になること","SQL Server接続済み","@IgnorePrioritiesBelow = 255","CheckID = -1（クレジット）以外の結果がほぼ空","低","優先度下限最大値"
"58","UT-BLZ-058","sp_Blitz.sql","sp_Blitz","N/A","境界値","データベースが0件（システムDBのみ）の場合にエラーなく完了すること","ユーザーDBが存在しない","デフォルトパラメータ","エラーなく実行完了、結果にユーザーDB関連チェックが含まれない","中","ユーザーDB 0件"
"59","UT-BLZ-059","sp_Blitz.sql","sp_Blitz","N/A","境界値","50以上のデータベースが存在する場合に警告が出力されること","50以上のユーザーDBが存在","@CheckUserDatabaseObjects = 1, @BringThePain = 0","CheckID = 201, Finding = '@CheckUserDatabaseObjects Disabled' が出力","中","50DB以上の境界"
"60","UT-BLZ-060","sp_Blitz.sql","sp_Blitz","N/A","境界値","サーバー起動から1日未満でもエラーなく完了すること","サーバー起動から1日未満","デフォルトパラメータ","@DaysUptime = 0.01 として計算され、エラーなく完了","中","サーバー稼働1日未満"
"61","UT-BLZ-061","sp_Blitz.sql","sp_Blitz","N/A","異常系","存在しない@SkipChecksDatabase指定時にエラーが発生しないこと","指定DBが存在しない","@SkipChecksDatabase = 'NonExistentDB', @SkipChecksSchema = 'dbo', @SkipChecksTable = 'SkipChecks'","スキップ処理がスキップされ、通常通り実行完了","中","存在しないスキップDB"
"62","UT-BLZ-062","sp_Blitz.sql","sp_Blitz","N/A","異常系","存在しない@OutputDatabaseName指定時にエラーが発生すること","指定DBが存在しない","@OutputDatabaseName = 'NonExistentDB', @OutputSchemaName = 'dbo', @OutputTableName = 'Results'","RAISERROR 'The specified output database was not found on this server' が発生","高","存在しない出力先DB"
"63","UT-BLZ-063","sp_Blitz.sql","sp_Blitz","N/A","異常系","存在しないリンクサーバー指定時にエラーが発生すること","リンクサーバーが存在しない","@OutputServerName = 'NonExistentServer', @OutputDatabaseName = 'DBAtools', @OutputSchemaName = 'dbo', @OutputTableName = 'Results'","RAISERROR 'The specified output server was not found' が発生","高","存在しないリンクサーバー"
"64","UT-BLZ-064","sp_Blitz.sql","sp_Blitz","N/A","異常系","リンクサーバー上の存在しないDB指定時にエラーが発生すること","リンクサーバーは存在するがDBが存在しない","@OutputServerName = 'ValidServer', @OutputDatabaseName = 'NonExistentDB', @OutputSchemaName = 'dbo', @OutputTableName = 'Results'","RAISERROR 'The specified database was not found on the output server' が発生","高","リンクサーバー上の存在しないDB"
"65","UT-BLZ-065","sp_Blitz.sql","sp_Blitz","N/A","異常系","ローカル一時テーブル名指定時にエラーが発生すること","なし","@OutputTableName = '#TempResults'","RAISERROR 'only global temp tables are supported' が発生","中","ローカル一時テーブル禁止"
"66","UT-BLZ-066","sp_Blitz.sql","sp_Blitz","N/A","異常系","リンクサーバーへの一時テーブル出力指定時にエラーが発生すること","リンクサーバーが存在","@OutputServerName = 'ValidServer', @OutputTableName = '##TempResults'","RAISERROR 'requires a permanent table' が発生","中","リンクサーバーへの一時テーブル禁止"
"67","UT-BLZ-067","sp_Blitz.sql","sp_Blitz","N/A","異常系","VIEW SERVER STATE権限がない場合にエラーが発生すること","VIEW SERVER STATE権限なし","デフォルトパラメータ","RAISERROR 'does not have VIEW SERVER STATE permissions' が発生しRETURN","高","権限チェック"
"68","UT-BLZ-068","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","sysadmin以外のユーザーで実行した場合に警告が出力されること","非sysadminユーザーで実行","デフォルトパラメータ","CheckID = 223, Finding = 'Some Checks Skipped' が出力","高","非sysadmin警告"
"69","UT-BLZ-069","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","Amazon RDS環境でRDS固有のチェックがスキップされること","Amazon RDS環境","デフォルトパラメータ","CheckID = 223, URL = 'https://aws.amazon.com/rds/sqlserver/' が出力","中","Amazon RDS対応"
"70","UT-BLZ-070","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","Azure Managed Instance環境でMI固有のチェックがスキップされること","Azure Managed Instance環境（EngineEdition = 8）","デフォルトパラメータ","CheckID = 223, URL LIKE '%managed-instance%' が出力","中","Azure MI対応"
"71","UT-BLZ-071","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","Express Edition環境でExpress固有のチェックがスキップされること","SQL Server Express Edition","デフォルトパラメータ","CheckID = 223 が出力、SQL Agent関連チェックがスキップ","中","Express Edition対応"
"72","UT-BLZ-072","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","互換性レベル90未満のDBが存在する場合に警告が出力されること","compatibility_level < 90のDBが存在","@CheckUserDatabaseObjects = 1","CheckID = 204, Finding = '@CheckUserDatabaseObjects Disabled' が出力","中","互換性レベル制限"
"73","UT-BLZ-073","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","Numeric_RoundAbort有効のDBが存在する場合にセッション設定が変更されること","is_numeric_roundabort_on = 1のDBが存在","デフォルトパラメータ","SET NUMERIC_ROUNDABORT OFF が実行され、終了時に復元","低","Numeric_RoundAbort対応"
"74","UT-BLZ-074","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","グローバル一時テーブルへの出力が正常に動作すること","なし","@OutputTableName = '##BlitzResults'","##BlitzResultsテーブルが作成され結果が挿入される","中","グローバル一時テーブル出力"
"75","UT-BLZ-075","sp_Blitz.sql","sp_Blitz","N/A","状態・条件","Linux環境でWindows固有のチェックがスキップされること","Linux環境（dm_os_host_info.host_platform <> 'Windows'）","デフォルトパラメータ","xp_fixeddrives、xp_regread等のWindows固有チェックがスキップ","中","Linux対応"
"76","UT-BLZ-076","sp_Blitz.sql","sp_Blitz","N/A","正常系","既存の出力テーブルが存在する場合にデータが追加されること","出力テーブルが既存","@OutputDatabaseName = 'DBAtools', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzResults'（既存テーブル）","既存テーブルに新規行が追加される（テーブルは再作成されない）","中","既存テーブルへの追加"
"77","UT-BLZ-077","sp_Blitz.sql","sp_Blitz","N/A","正常系","出力テーブルにServerName列が正しく記録されること","なし","@OutputDatabaseName, @OutputSchemaName, @OutputTableName を指定","ServerName列にSERVERPROPERTY('ServerName')の値が記録","中","ServerName記録"
"78","UT-BLZ-078","sp_Blitz.sql","sp_Blitz","N/A","正常系","出力テーブルにCheckDate列が正しく記録されること","なし","@OutputDatabaseName, @OutputSchemaName, @OutputTableName を指定","CheckDate列にSYSDATETIMEOFFSET()の値が記録","中","CheckDate記録"
"79","UT-BLZ-079","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 256: NULへのログバックアップが検出されること","NULへのログバックアップが実行されたDBが存在","デフォルトパラメータ","CheckID = 256, Finding = 'Log Backups to NUL' のレコード","高","NULバックアップチェック"
"80","UT-BLZ-080","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 3: バックアップ履歴が60日以上保持されている場合に警告されること","backupsetに60日以上前のレコードが存在","デフォルトパラメータ","CheckID = 3, Finding = 'MSDB Backup History Not Purged' のレコード","低","バックアップ履歴保持チェック"
"81","UT-BLZ-081","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 186: バックアップ履歴が2日未満しか保持されていない場合に警告されること","backupsetに2日以内のレコードのみ存在","デフォルトパラメータ","CheckID = 186, Finding = 'MSDB Backup History Purged Too Frequently' のレコード","中","バックアップ履歴削除過多チェック"
"82","UT-BLZ-082","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 178: スナップショットバックアップが検出されること","50GB以上のDBが60秒以内でバックアップ完了した履歴が存在","デフォルトパラメータ","CheckID = 178, Finding = 'Snapshot Backups Occurring' のレコード","中","スナップショットバックアップチェック"
"83","UT-BLZ-083","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 185: 待機統計がクリアされた場合に検出されること","DBCC SQLPERFで待機統計がクリアされた形跡がある","デフォルトパラメータ","CheckID = 185, Finding = 'Wait Stats Have Been Cleared' のレコード","低","待機統計クリアチェック"
"84","UT-BLZ-084","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 2301: 無効なWindowsログインが検出されること","sp_validateloginsで無効なログインが検出される","sysadmin権限で実行","CheckID = 2301, Finding = 'Invalid login defined with Windows Authentication' のレコード","中","無効ログインチェック"
"85","UT-BLZ-085","sp_Blitz.sql","sp_Blitz","N/A","正常系","dbatools/dbadmin/dbmaintenance/rdsadminデータベースが自動スキップされること","dbatools, dbadmin, dbmaintenance, rdsadminのいずれかが存在","デフォルトパラメータ","これらのDBに関するチェック結果が除外される","低","管理DB自動スキップ"
"86","UT-BLZ-086","sp_Blitz.sql","sp_Blitz","N/A","正常系","読み取り権限のないDBがスキップされること","SELECT権限のないDBが存在","非sysadminユーザーで実行","権限のないDBがSkipChecksに追加されチェックがスキップ","中","権限なしDBスキップ"
"87","UT-BLZ-087","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 84: ハードウェア情報が出力されること","@CheckServerInfo = 1","@CheckServerInfo = 1","CheckID = 84, Finding = 'Hardware' のレコード（CPU数、メモリ量）","低","ハードウェア情報"
"88","UT-BLZ-088","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 85: SQL Serverサービス情報が出力されること","@CheckServerInfo = 1","@CheckServerInfo = 1","CheckID = 85, Finding = 'SQL Server Service' のレコード（バージョン、エディション）","低","サービス情報"
"89","UT-BLZ-089","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 88: SQL Server最終起動日時が出力されること","@CheckServerInfo = 1","@CheckServerInfo = 1","CheckID = 88, Finding = 'SQL Server Last Restart' のレコード","低","最終起動日時"
"90","UT-BLZ-090","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 103: 仮想マシン情報が出力されること（VM環境）","@CheckServerInfo = 1、VM環境","@CheckServerInfo = 1","CheckID = 103, Finding = 'Virtual Server' のレコード","低","VM情報"
"91","UT-BLZ-091","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 156: 実行日時が出力されること","デフォルト実行","デフォルトパラメータ","CheckID = 156, FindingsGroup = 'Rundate' のレコード","低","実行日時記録"
"92","UT-BLZ-092","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID -1: クレジット情報が出力されること","デフォルト実行","デフォルトパラメータ","CheckID = -1, FindingsGroup = 'Thanks!' または 'sp_Blitz' のレコード","低","クレジット出力"
"93","UT-BLZ-093","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 260: SQLサービスがAdministratorsの場合に検出されること","SQLサービスアカウントがローカルAdministrators","xp_cmdshell有効、sysadmin権限","CheckID = 260, Finding = 'Dangerous Service Account' のレコード","高","サービスアカウントセキュリティ"
"94","UT-BLZ-094","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 261: SQL AgentサービスがAdministratorsの場合に検出されること","SQL AgentサービスアカウントがローカルAdministrators","xp_cmdshell有効、sysadmin権限","CheckID = 261, Finding = 'Dangerous Service Account' のレコード","高","Agentサービスアカウントセキュリティ"
"95","UT-BLZ-095","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 7: 起動時に実行されるストアドプロシージャが検出されること","ExecIsStartup = 1のプロシージャが存在","デフォルトパラメータ","CheckID = 7, Finding = 'Stored Procedure Runs at Startup' のレコード","中","起動プロシージャチェック"
"96","UT-BLZ-096","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 10: Resource Governorが有効の場合に検出されること","Resource Governorが有効","デフォルトパラメータ","CheckID = 10, Finding = 'Resource Governor Enabled' のレコード","中","Resource Governorチェック"
"97","UT-BLZ-097","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 11: サーバートリガーが有効の場合に検出されること","有効なサーバートリガーが存在","デフォルトパラメータ","CheckID = 11, Finding = 'Server Triggers Enabled' のレコード","中","サーバートリガーチェック"
"98","UT-BLZ-098","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 15: Auto-Create Stats無効のDBが検出されること","is_auto_create_stats_on = 0のDBが存在","デフォルトパラメータ","CheckID = 15, Finding = 'Auto-Create Stats Disabled' のレコード","中","統計自動作成チェック"
"99","UT-BLZ-099","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 16: Auto-Update Stats無効のDBが検出されること","is_auto_update_stats_on = 0のDBが存在","デフォルトパラメータ","CheckID = 16, Finding = 'Auto-Update Stats Disabled' のレコード","中","統計自動更新チェック"
"100","UT-BLZ-100","sp_Blitz.sql","sp_Blitz","N/A","正常系","CheckID 232: データサイズ情報が出力されること","@CheckServerInfo = 1","@CheckServerInfo = 1","CheckID = 232, Finding = 'Data Size' のレコード（DB数、合計サイズ）","低","データサイズ情報"
