Skip to content

Instantly share code, notes, and snippets.

@MasayukiOzawa

MasayukiOzawa/Retrieve backup status of SQLDB.sql

Created August 3, 2018 08:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MasayukiOzawa/09ce3d77f60d034e85460d56d3cea312 to your computer and use it in GitHub Desktop.
Save MasayukiOzawa/09ce3d77f60d034e85460d56d3cea312 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Retrieve backup status of SQLDB.sql
-- バックアップによるスループットの発生の確認
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