troubleshooting Question

dm_io_virtual_file_stats and backupset co-relation

Avatar of 25112
25112 asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
2 Comments1 Solution524 ViewsLast Modified:
#1)select sum(num_of_reads) from sys.dm_io_virtual_file_stats(null,null) where database_id = db_id ('VERTAS') -- capture sum(num_of_reads) at 9am on Thursday
the database is backed up every half hour (Transaction log) and couple of full backups also.
#2)select sum(num_of_reads) from sys.dm_io_virtual_file_stats(null,null) where database_id = db_id ('VERTAS') -- capture sum(num_of_reads) at 9am on Friday
#3)select sum(backup_size) from msdb..backupset where backup_start_date between '2012-02-09 09:00:00.000' and '2012-02-10 09:00:00.000'
and database_name = 'VERTAS'
the system is not rebooted in the 24 hours.

Will #2-#3-#1 give the amount read of the database in the 24 hour period? Is this accurate?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros