Keeping watch on database size, drive size, table size, index size
etc. are few of the primary duty of DBA. I have already written few
articles to cover this type of subject, for example:
Keep watch on your disk size
Keep watch on your database size
Calculate size of index
Today I am going to introduce two more TSQL Script which covers the size of each Table and size of each Schema in your SQL Server database. I used to have log of table size for each date so that I can compare the growth of table for future disk & other resource planning. It is really very mandatory for DBA to know the actual size of each table along with total number or rows available in that table, in order to make operation smooth and successful.
Click Here to read full article.
Keep watch on your disk size
Keep watch on your database size
Calculate size of index
Today I am going to introduce two more TSQL Script which covers the size of each Table and size of each Schema in your SQL Server database. I used to have log of table size for each date so that I can compare the growth of table for future disk & other resource planning. It is really very mandatory for DBA to know the actual size of each table along with total number or rows available in that table, in order to make operation smooth and successful.
Click Here to read full article.
0 comments:
Post a Comment