March 24, 2010 at 8:33 pm
Is using a backup command with STATISTICS IO a good way to calculate how much IO a backup will take? Any other options?
Dan
March 24, 2010 at 10:27 pm
Statistics IO will tell you the read information within the database. When performing a backup (particularly to disk) you would also need to capture the write information.
If you want disk IO during the database backup, you should probably use the Perfmon Counters for that
Avg. Disk sec/read
Avg Disk sec/write
You can also look at the other counters in the LogicalDisk group in perfmon.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 25, 2010 at 2:38 am
but the counters will give IO for all CRUD operations going on, including the backup, and hence may not be reflective of the backup?
March 25, 2010 at 9:14 am
Baseline your system before you do a backup. Compare the baseline to the counters taken during the backup. Backup will be most of the difference between the two.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply