asked on

Capacity Planning and Query

Calculating Tablespace Size using Query

I normally use tools to view space utilization and free-space left in database. I have to work for 'Capacity Planning', I have around 50 database and have to find the 'space utilization' for all the databases.

1. Can i get a query which tells me the total space 'used' by all the tablespaces in database and total 'free-space' left in all the tablespaces for current database.

2. What are the other factors i have to work for Capacity Planning, Any suggestions/ideas most welcome.

Thanks
Daman

FlamingSword

Generally, count disk space
a) create file 10 rows by 10 columns
b) check disk space left
c) one row one column
d) check

e) continue for
100 rows 10 columns
10 rows 100 columns
100 rows 100 columns

f) go off to plot this out.
g) run a few more to smooth out the plot, as necessary

Capacity can also include totals, such as max for fields, tables, rows, columns, numbers, and networking bandwidth.

FlamingSword

> and free-space left in database

use good design, compression, and you don't have free space.

eg, when I say delete, I mean delete, not hide empty space

ASKER CERTIFIED SOLUTION

dbalaski

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nico5038

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- Answered by: dbalaski
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

Netminder

Per recommendation, force-accepted.

Netminder
CS Moderator