SQL 2000, 20005, 2008

Question

Post reply

SQL 2000, 20005, 2008

balasach82

SSCrazy Eights

Points: 9653
More actions
June 29, 2010 at 6:39 am

#141141

Rather than seeing from the properties of a db for its MAX size limit, is there any system table which can be used for the same?

Viewing 5 posts - 1 through 4 (of 4 total)

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

george sibbald SSC Guru Points: 104210 More actions · Answer 1

select db_name(database_id),name,size,max_Size from sys.master_files

size and max_size are in 8K pages.

max_size = -1 means unlimited

---------------------------------------------------------------------

balasach82 SSCrazy Eights Points: 9653 More actions · Answer 2

Thanks for the query.

Present size of DB is around 940MB and the max limit is set to 1000MB(i.e. restricted growth to 1000MB). So what would happen on reaching the 1000MB? Would no queries be executed against the DB?

Also, the max_size divided by 1024 gives me 125. Is this correct?

george sibbald SSC Guru Points: 104210 More actions · Answer 3

balasach82 (6/29/2010)
Thanks for the query.
Present size of DB is around 940MB and the max limit is set to 1000MB(i.e. restricted growth to 1000MB). So what would happen on reaching the 1000MB? Would no queries be executed against the DB?
Also, the max_size divided by 1024 gives me 125. Is this correct?

Once spaceused = 1000MB the first database action (update or insert) that required to take out a new extent would fail. All database activity then would stop.

max size / 1024 would give 125 but not sure why you want to do that?

max_size should = 128000 ((128000X8192)/1024)/1024 = 1000MB

---------------------------------------------------------------------

balasach82 SSCrazy Eights Points: 9653 More actions · Answer 4

once again thanks for the info..

am poor in math:-D. Thanks for the calculation explanation.