March 19, 2003 at 1:50 pm
Hi,
In an effort to estimate database growth for next 5 yrs, I totalled the pages used by all system and application tables and multiplied the number by 8 KB (2,045,422 pages * 8 KB = 16,363,376 KB or 16.5 GB approx).
1. My current db size is 23.5 GB, what else is using 7 GB(23.5-16.5) of space?
2. I realize that there are 8 types of pages (data, index, test image, free space etc.) but does the value of pages scanned in DBCC SHOWCONTIG include all 8 page types or is it just data page.
3. Is this approach correct?
Approach:
1. Get total pages (dbcc showcontig's scanned pages value) used by system and app tables.
2. Total them and since each page is 8 KB, multiply by 8 to know how much space is utilized by data in the database.
Thanks,
Sarat.
March 19, 2003 at 2:05 pm
You also have the IAM pages, that increase when you have more pages. I don't remember the exact value but it think you have one page for every 8000 data pages. And also have the file attributes pages.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply