calculate database size

Question

Post reply

calculate database size

LOVER OF SQL

SSCommitted

Points: 1900
More actions
September 27, 2013 at 1:29 pm

#298415

Friends,
how can i calculate database size with this information:
Processed 8192240 pages for database 'DBOLTP', file 'rm' on file 1. ??
(8192240 *8) = 65537920 (bytes) / 1024 / 1024 = 62MB?
Thanks...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

kevaburg SSCoach Points: 18131 More actions · Answer 1

Are you looking too deep into a simple problem?

Would this not provide the answer you need?

select name, size from sys.master_files;

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

LOVER OF SQL (9/27/2013)
Friends,
how can i calculate database size with this information:
Processed 8192240 pages for database 'DBOLTP', file 'rm' on file 1. ??
(8192240 *8) = 65537920 (bytes) / 1024 / 1024 = 62MB?
Thanks...

Any size given in pages can be converted to binary (1024^³) MB just by dividing by 128.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

That won't allow you to calculate the size of the database files. It will allow you to calculate the total size of the allocated extents in the database. If you want the size of the files, query sys.database_files.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

awworrell SSC Rookie Points: 45 More actions · Answer 4

Each time I have been asked to return the size of the databases for the systems I manage, I tend to use this query. It returns the size for all databases found in master.

USE master

go

exec sp_helpdb

Here is the relevant Microsoft Article on it.

kevaburg SSCoach Points: 18131 More actions · Answer 5

saso_yns (10/8/2013)
??? ??? ???? ??????
??? ??? ??? ??? ???????
??? ??? ??? ??? ??????

ahhhhh......Everything seems so much clearer now....:-D

sql-noob SSC-Addicted Points: 437 More actions · Answer 6

Execute EXEC sp_spaceused towards the database, the reserved size shows the exact size of the database (Even the backup size for the database)