|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Selecting the databases item will display varying information depending upon the version. For 7.0 databases, you will simply get a list of the databases with the date they were created. If you display databases on a 6.5 or earlier server, it will also include the allocated size and the last time the tran log was dumped.
Double clicking one of the databases in the right hand pane will bring up the database editor. From here you can add space to the database or tran log. The options tab allows you to set any database options and the DDL tab provides the DDL required to create the database. The space tab shown below gives you a graphical depiction of where your space is allocated within the database. You will note negative numbers appearing. The numbers reported suffer from the same inaccuracies that Enterprise Manager has carried around for years. I generally ignore the numbers and utilize the pie graphs to determine where my space is allocated. (The pie graphs are accurate for some strange reason even when the numbers are not.)
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
