Disk usage Report

There needs to be two levels of disk usage reports, one that just reads the meta data (similar to 2000 functionality), and displays the pretty graphs, and then the one that is currently available that does the index analysis and so on. I have a 1.2 TB database on 2005 and it takes forever to pull up that report (which my client has decided they love)...

Also, I do not know how hard it would be to keep a running analysis of database/index fragmentation, but that would be a nice feature also, even if it was an enterprise only feature.

Just a thought.

Hi Jake,

Thanks for the feedback. I'll pass it along to the PM who owns the reports in SSMS.

Cheers,
Dan

Disk space usage

SQL 7.0 SP4/NT 4.0
DB File is set to grow by 5%.
It's given that SQL preallocates its hard disk space so
that as records are added to the table, there is no
change to the hard drive space at the NT level.
Is there a way to see, at the SQL level, how much of the
space currently allocated, is available?
Thanks,
Donsp_spaceused will show you how much space is currently
allocated in a database.
Linchi
>--Original Message--
>SQL 7.0 SP4/NT 4.0
>DB File is set to grow by 5%.
>It's given that SQL preallocates its hard disk space so
>that as records are added to the table, there is no
>change to the hard drive space at the NT level.
>Is there a way to see, at the SQL level, how much of the
>space currently allocated, is available?
>Thanks,
>Don
>
>.
>