The Percent Used column in Administrator is invaluable! What happened to it???
Subject: Just curious… What do you use it for?
Manual decision on when to compact a database?
Subject: See prev thread
Date
Topic
Author
"Space User" deliberately removed from the Admin client Files panel (Created by Harry Peebles on 10/13/2009)
We can't use DAOS, how do we get the view back? (Created by John M Gollner on 10/14/2009)
use an admin client 8.5.0 or earlier <eom> (Created by Harry Peebles on 10/14/2009)
Use Webadmin (Created by Gary Cousins on 10/14/2009)
Subject: For…
Creation of an IND.File to run a compact -B against the database with the most white space. Our server have about 1,5 TB on data, no chance of a compact in 48 hours against all databases.
Subject: ya, sort by % Used…
highlight biggest offenders and compact -B
Subject: Was very useful
While we didn’t often kick off manual installs or build lists, but due to the number of files on the server, our space saving full compacts were limited to the weekends.
This was helpful when people would approach the quota limit and were doing cleanup. Usually our helpd desk would help with the cleanup and, because we do run transaction logging and they could not initiate their own compacts, they would call to ask for a compact.
It was great to be able to see, at a glance, if it was worthwhile to even initiate the compact.
I realize that you can do this by checking DB properties from the file list, but I run into more problems with that kind of activity…
-
Admin Client crashes occasionally, just happened to me now.
-
Slow bringing up the properties box, add that to the time it takes to select the server, get a list of files, which I’m going to be stuck with regardless and it makes the process rather cumbersome.
-
Every so often when I check properties I run into a bug where it shows the DB Title on every property tab. Then if you check another user you see the properties for that user, but the title from the “problem” user shows up. Won’t go away until you restart the client.
-
Opening up the file itself to check this is counter productive and depending on the mood of the server you may have to drop users and flush the cache so it doesn’t think the DB is in use. Of course simply compacting it isn’t a great option either.
We’re not running DAOS on any production servers and with some may never do it… we’ve already sunk our money into the disk space (unfortunately) so that saves us little, the added complexities off set any gains when you aren’t saving things.