Today I will explain what information this DMV gives and a simple query that you can use in combination with the yesterday’s DMV, sys.dm_io_pending_io_requests. This is a Dynamic Management Function which returns very useful information and as most of other stats DMVs provides the cumulative data. One of the most important IO related DMVs is sys.dm_io_virtual_file_stats. For the complete list in the series please click here. As we go ahead in this series we will also talk about the usage, linking between DMVs and some scenarios where these DMVs will be helpful while you are using SQL Server. In this series of blogs I will be exploring and explaining the most useful DMVs in SQL Server. Hello Geeks and welcome to the Day 7 of the long series of One DMV a day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |