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