fn_virtualfilestats


	fn_virtualfilestats

Osolage

5-24-2007 9:54 AM

363 views

tags:

sql server, system functions

Osolage says:

Not exactly sure how this might help, but it's available... I found it in SQL Server Magazine's website and thought I'd clip it.

Add a Comment

Login to Comment. Not a member yet? Sign up

Today's Top Clips

visit the Top Clips page

View the Top Clips from May 24, 2007

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/a8063732-7d56-4ac0-a9aa-97123954047e/64A9ED7D-F71F-4F94-9524-AD89360F3D54/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.sqlmag.com/Article/ArticleID/15786/sql_server_15786.html" href="http://www.sqlmag.com/Article/ArticleID/15786/sql_server_15786.html" style="font-size: 11px;">www.sqlmag.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.sqlmag.com/Article/ArticleID/15786/sql_server_15786.html">Fn_virtualfilestats is a system table-valued function that provides statistical information about a file, such as the number of asynchronous I/Os. Table-valued functions return a result set that looks and acts like a table and to which you can assign the new Table data type. You can use a table function wherever T-SQL allows a regular table name.</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.sqlmag.com/Article/ArticleID/15786/sql_server_15786.html">
The fn_virtualfilestats function helps track how long users have to wait to read or write to a file. The function also helps identify files that experience a lot of I/O activity. From time to time, using I/O monitoring procedures that don't rely on Performance Monitor can be convenient, such as when you don't have administrator rights for running Performance Monitor on the NT machine or when you simply want to capture results in a SQL <A class="iAs" classname="iAs" href="#" target="_blank" itxtdid="3900075">Server</A> table for historical reporting. The fn_virtualfilestats function can prove handy in those situations.</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.sqlmag.com/Article/ArticleID/15786/sql_server_15786.html">fn_virtualfilestats ( [@DatabaseID=] database_id
    , [ @FileID = ] file_id )</blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/64A9ED7D-F71F-4F94-9524-AD89360F3D54/blog/" title="blog or email this clip"><img src="http://content7.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Copyright; Privacy; EULA

Search Options

Today's Top Clips