Thursday, March 22, 2012

DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advanceIn Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:
>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? or
>perhaps point me to performance tables which contain this data?
>Thanks in advance

No comments:

Post a Comment