InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:07:40 GMT20http://www.sqlservercentral.com/Forums/Topic8508-75-1.aspxBest 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 appreciatedhere is a sample attached.Tue, 10 Jun 2008 10:07:29 GMTphoenixrising1599http://www.sqlservercentral.com/Forums/Topic8508-75-1.aspxGood 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.Andyhttp://www.sqlservercentral.com/columnists/awarren/Thu, 05 Dec 2002 17:26:00 GMTAndy Warrenhttp://www.sqlservercentral.com/Forums/Topic8508-75-1.aspxNo probs, thanks for the feedback. Thu, 05 Dec 2002 15:34:00 GMTckempstehttp://www.sqlservercentral.com/Forums/Topic8508-75-1.aspxI 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. Thu, 05 Dec 2002 13:56:00 GMTScorpion_66http://www.sqlservercentral.com/Forums/Topic8508-75-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/ckempster/filestatsexample.asp>http://www.sqlservercentral.com/columnists/ckempster/filestatsexample.asp</A>Sat, 30 Nov 2002 00:00:00 GMTckempste