Utilizing fn_virtualfilestats

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Chris Kempster » Utilizing fn_virtualfilestats

Utilizing fn_virtualfilestats

Rate Topic

Display Mode

Topic Options

Author

Message

ckempste

Posted Saturday, November 30, 2002 12:00 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ckempster/filestatsexample.asp

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

Post #8508

Scorpion_66

Posted Thursday, December 05, 2002 1:56 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 6:37 AM
Points: 593, Visits: 25

I implemented your code on on of my systems and followed your article to produce the same graphs that you created, and it proved to be a breakthrough in communictaion with some of my managers. Excellent article.

Post #48154

ckempste

Posted Thursday, December 05, 2002 3:34 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

No probs, thanks for the feedback.

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

Post #48155

Andy Warren

Posted Thursday, December 05, 2002 5:26 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Good article, but A+ on using OLAP. We need more OLAP content, so if you have other ideas?! I'd love to see a follow up that uses data mining to do some deeper analysis.

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #48156

phoenixrising1599

Posted Tuesday, June 10, 2008 10:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 01, 2013 9:52 AM
Points: 131, Visits: 304

Best place to post it as it doesnt warrant its own topic. If I have basic files for my databases (no file groups) and I execute fn_virtualfilesatats() against all databases, the data that is returned is cumulative from what point? The last checkpoint/log flush/instace restart? It would help me get a grip on the databases at my new job until I can get anaylsys services implemented and run your excellent solution.

But first I have to move all of the databases to new sql2005 servers and test the apps against them.

They have never had a full time DBA so I have a ton of work to do but need some basic insight into what are my busiest databases so I can better load balance when moving them to the new servers.

Management has no idea what activity is occuring on what database so I cant wait to get your solution implemented. Unfortunately, I am limited on time and prirorities. They are pushing to get everything moved over but I am holding out until I can benchmark the new servers with sqlio and find what databases are doing what so I know where to put them....pretty basic stuff....

your assistance in helping me understand the output I am getting would be appreciated

here is a sample attached.

'nix

Post Attachments

IODisk_PerformanceCheck.xls (28 views, 24.50 KB)

Post #514597

« Prev Topic | Next Topic »

Permissions