on 09-07-2010 7:26 AM
Hi All,
I have Windows SQL server.
Now i want to find out the Table space history for last one year,but in DB02 -->statistics i get the table space history but the sample dates are not of present.
All the DB collector jobs are running fine .
Can someone help me in finding the last one year table space history?
Also in DB02 in fastest growing tables i get only 16 tables.
Please help me in knowing how can i find out 100 fastest growing tables.
Thanks and regards
Tushar
FIRST OF ALL.....................
MS SQL SERVER HAS NO TABLESPACE CONCEPT LIKE ORACLE...............
work on SQL server database to find the data files and logs.
You can resize data files as per your requirement.
Also check if the Full backup was taken recently so that that log files are truncated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sharib,
This program gives a dump in my enviornment.
Is there any other way of finding the fastest growing tables?
One more thing in DB02 space statistics i i get the data showing "Sample dates" which is not same for every table.
Please let me know what this sample date means and why is it diffrent for all tables.
Regards
Tushar Pathak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sharib,
I am not clear what "RSMSSTABGROW" is?
Can you please explain hoe to get the fastest growing tables using this.?
Thanks and regards
Tushar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check this:
RSMSSTABGROW MS SQL Server Display Top Growning Tables
Regards,
Sharib Tasneem
Edited by: T.sharib on Sep 7, 2010 9:22 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Note Note 1027512 - MSSQL: DBA cockpit for basis release 7.00 and later
would address your problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.