SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Basics of Sizing a SQL Server Database


The Basics of Sizing a SQL Server Database

Author
Message
Brian Knight
Brian Knight
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: Moderators
Points: 2545 Visits: 235
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/sizingadatabase.asp

Brian Knight
Free SQL Server Training Webinars
EugeneZ-162636
EugeneZ-162636
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 562

Nice try Brian,

But there is not much new ideas and info except advertisement of the Datatect 1.6 (BTW - good tool)

For example - Ok you calculated with Erwin or without a size of database->

Can you tell now how big HDD to buy? How big trans log files can be after reindex? Anything about recovery model in view of the Trans log file? and maintenances? what about statistics (size consuming too)...

Best regards,

EugeneZ


Mike Metcalf
Mike  Metcalf
SSC Eights!
SSC Eights! (847 reputation)SSC Eights! (847 reputation)SSC Eights! (847 reputation)SSC Eights! (847 reputation)SSC Eights! (847 reputation)SSC Eights! (847 reputation)SSC Eights! (847 reputation)SSC Eights! (847 reputation)

Group: General Forum Members
Points: 847 Visits: 53

I thought that it was a decent article, and one very close to my heart as our DB is currently 1.6TB and growing by 15-30 GB each and every week.


Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)

Group: General Forum Members
Points: 85222 Visits: 41078
I agree... a decent article... but it DOES sound like an advertisement and provides no real info as to how to do the sizing estimate if you don't have those tools.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Georges Belhadjali
Georges Belhadjali
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 3
Agree too, sounds interesting regarding Erwin, the same feature exist in Power AMC (Pub!), nevertheless I would have appreciate more info about how to size the transaction log ...
Brian Munier
Brian Munier
Old Hand
Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)

Group: General Forum Members
Points: 371 Visits: 80

Not much content.

ERwin WAS a great product, BUT Computer Associates (CA) as is their business model, has not released even bug fixes since they acquired the product. They have done new databases, but that's it.

If you have it, use it. If not buy something else.

If you want to buy the rights from them and revitalize development of the tool, lots of people would love it.


DavidSimpson
DavidSimpson
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1136 Visits: 1077

Not promoting one tool over another but CA has done quite a bit for Erwin. They even had a big focus on bug improvments to the point of holding off any improvements... I believe it was around release 4.14. This made a big difference on bugs with RE and complete compares. I'm not on the current release so I cannot make comments on it now.

As for the article, good article for a starting point on sizing issues with a database... as the title indicates. I think the tools mentioned give some basic direction on where to go for further 3rd party help. Listing out additional resources would have helped keep it from sounding a bit like an advertisement but it makes sense that you would focus on the ones you are familiar with.

Any plans for more indepth articles on the subject?

ds





Brian Munier
Brian Munier
Old Hand
Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)Old Hand (371 reputation)

Group: General Forum Members
Points: 371 Visits: 80

Well, If you say so, it must be recent development however. In Dec 2004 they were still on Version 3 which was the same as it had been 2 or 3 years before.

I met another DBA who worked for a company that got bought out by CA and after 3 or 4 years, they hadn't done any bug fixes.

I hope they do support it and improve it.


Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)

Group: General Forum Members
Points: 85222 Visits: 41078

Sorry for being a year late.

I thought the title of this article was "Sizing a Database"... not an advertisement for some 3rd party software.



--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
d-458788
d-458788
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 1

errr...ah...Where's the Beef?

Reads like someone spent too much time playing video games and hurridly tossed the article together to meet a deadline...


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search