June 8, 2010 at 12:46 pm
1.How to check how big database without data but with tables?
2.How to check how big database with some tables that would have data and don't have data?
Thank you
June 8, 2010 at 2:20 pm
I guess I am confused by the question so I wanted to rephrase. you want to know how big the database would be if it had no data in any table? and you want to know how big the database would be if every table in the database had data?
Is that correct or did I miss what you where asking?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 9, 2010 at 6:46 am
correct
June 9, 2010 at 7:15 am
I do not beleive there are any tools for that but I am also not sure how that would be useful information. If you removed all data from a database and assuming you were to shrik that database after wards then even a 1TB+ database would become very very tiny. Most of the size required for a database is in the data and indexes. you could recreate a database on a test box if available and script all tables,indexs, and so on. then when you run the scripts on your test box you would be able to see the size of it empty. Even if you have thousands of tables though I would suspect you end up with a tiny database.
The second part you can determine with a little work but again I do not beleive there are any tools that would do such a thing. Each table would vary depending on what is stored and how much is stored. you could insert 100 rows into each of those tables and get an estimate based on that.
There are tools that would allow you to analyze how much space a given table is using but I do not know of any that would do what you are looking for.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply