December 4, 2002 at 12:00 am
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"
December 5, 2002 at 1:56 pm
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.
December 5, 2002 at 3:34 pm
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"
December 5, 2002 at 5:26 pm
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
June 10, 2008 at 10:07 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy