Calculating Space

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ph3ng - 17 Jul 2008 04:32 GMT

Hi there

I am a junior dba - still trying to learn as much as I can. I would
like to calculate the current size of my DB as well as my DB server. I
am currently using DBArtisan however would like to know the syntax/
commands for calculating the space of the items I mentioned above as
oppose to using the GUI.

Thank you

Reply to this Message

Manish Negandhi - 17 Jul 2008 06:04 GMT

> Hi there
>
[quoted text clipped - 3 lines]
> commands for calculating the space of the items I mentioned above as
> oppose to using the GUI.

sp_helpdb dbname - gives you the size of the particular database .
When you say "size of server" are u looking for total size of all the
databases residing on the server ?

-HTH
Manish Negandhi
[TeamSybase]

Reply to this Message