udb.gather_io_file_stats

This procedure provides a standardized mechanism gather data from the DMV sys.dm_virtual_file_stats.  Data is  pulled as is from the DMV and inserted into the udb.io_file_stats table.  No changes are made to account for values resetting due to SQL Server service restarts or database or file drop and creations.  If a  new file or database is created with the same id value then information will be blended together based on that ID value.

Syntax

udb.gather_io_file_stats

Arguments

N/A

Return Codes

0 (success) or 1 (failure)

Result Sets

N/A

Remarks

This procedure has no parameters.

Examples

 

See Also

udb.io_file_stats

 

 

 

[First seen in Release 2.0]

[Last Changed in Release 2.0]

Last edited Aug 20, 2014 at 2:35 AM by sfibich, version 3

Comments

No comments yet.