January 15, 2013 at 5:38 am
Hi,
Why SQL Database files ware called "Virtual File" in sys.dm_io_virtual_file_stats - defination of this DMV is "Returns I/O statistics for data and log files. This dynamic management view replaces the fn_virtualfilestats function."
This DMV returns I/O Statistics for data and log files. Then why we cannot call this DMV as dm_io_physical_file_stats or dm_io_database_file_stats? why sql team suggest name "virtual_file"?
Ram
MSSQL DBA
January 15, 2013 at 6:44 am
There are details here on what virtual files are and how they work: http://msdn.microsoft.com/en-us/library/ms179355(v=SQL.105).aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2013 at 6:52 am
This has already been answered here
January 15, 2013 at 9:02 am
Ramdas Baghel (1/15/2013)
Hi,Why SQL Database files ware called "Virtual File" in sys.dm_io_virtual_file_stats - defination of this DMV is "Returns I/O statistics for data and log files. This dynamic management view replaces the fn_virtualfilestats function."
This DMV returns I/O Statistics for data and log files. Then why we cannot call this DMV as dm_io_physical_file_stats or dm_io_database_file_stats? why sql team suggest name "virtual_file"?
Why does the name bother you, it is just a name after all. What should matter is the informatioin that it provides. Plus, this function replaces the function fn_virtualfilestats used in previous versions of SQL Server. Based on this, I guess they chose to keep the naming consistant.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply