Capacity Planning

Hello
I am very new to sql server, my experience is as a Progrss DBA. I want to
start monitoring the database growth on both all tables and database files
etc within SQL.
In a Progress Environment I could run table analysis job to display each
table, number of records, size/blocks used, min record size, max record site
,
and fragmentation etc.
How can I get similar stats from within SQL?
Many thanks for your help.
JasonHi
SQL Server Profiler is your friend.
http://www.sql-server-performance.c...ofiler_tips.asp
"new_sql_dba" <newsqldba@.discussions.microsoft.com> wrote in message
news:12E4B5A8-A3E6-49C9-9164-6061109E37C4@.microsoft.com...
> Hello
> I am very new to sql server, my experience is as a Progrss DBA. I want to
> start monitoring the database growth on both all tables and database files
> etc within SQL.
> In a Progress Environment I could run table analysis job to display each
> table, number of records, size/blocks used, min record size, max record
> site,
> and fragmentation etc.
> How can I get similar stats from within SQL?
> Many thanks for your help.
> Jason
>
>
>