Utilizing fn_virtualfilestats

  • ckempste

    SSCoach

    Points: 17983

    Comments posted to this topic are about the item Utilizing fn_virtualfilestats


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

  • Scorpion_66

    SSCertifiable

    Points: 7891

    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.

  • ckempste

    SSCoach

    Points: 17983

    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"

  • Andy Warren

    SSC Guru

    Points: 119655

    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/

  • NixIsTheNameSQLIsTheGame

    SSC Eights!

    Points: 886

    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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply