1

Is there a way to monitor virtual filestats data with Extended Events, instead of doing (select * from sys.dm_io_virtual_file_stats) in SSMS?

1
  • What is it you're trying to accomplish? Jan 17, 2018 at 14:01

1 Answer 1

3

Extended Events is not a replacement for DMVs; they are a replacement for SQL Trace. Periodically querying the DMV is going to be less expensive than using an Extended Events Session.

The SQL Server storage engine always updates the file stats, whether you choose to query them or not.

Adding an Extended Event Session that captures each individual IO would introduce additional overhead for each read and write, and should only be done for debugging or troubleshooting, not performance monitoring.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.