Skip to content

Instantly share code, notes, and snippets.

@MasayukiOzawa
Created August 3, 2018 08:36
Show Gist options
  • Save MasayukiOzawa/09ce3d77f60d034e85460d56d3cea312 to your computer and use it in GitHub Desktop.
Save MasayukiOzawa/09ce3d77f60d034e85460d56d3cea312 to your computer and use it in GitHub Desktop.
-- バックアップによるスループットの発生の確認
SELECT GETDATE(), instance_name, cntr_value
FROM sys.dm_os_performance_counters
WHERE counter_name LIKE '%Backup%' AND instance_name = '_Total'
-- 完全バックアップの発生タイミングの確認 (完全バックアップが発生すると 値が減る)
SELECT modified_extent_page_count
FROM sys.dm_db_file_space_usage
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment