|
Home > Archive > MS SQL Server > February 2006 > Capacity Planning
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| new_sql_dba 2006-02-06, 7:23 am |
| 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
| |
| Uri Dimant 2006-02-06, 7:23 am |
| Hi
SQL Server Profiler is your friend.
http://www.sql-server-performance.c...
tips.asp
"new_sql_dba" < newsqldba@discussion
s.microsoft.com> wrote in message
news:12E4B5A8-A3E6-49C9-9164- 6061109E37C4@microso
ft.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
>
>
>
>
>
|
|
|
|
|