Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

The Basics of Sizing a SQL Server Database Expand / Collapse
Author
Message
Posted Sunday, July 22, 2001 12:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Post #632
Posted Friday, June 30, 2006 4:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 3:45 AM
Points: 66, Visits: 534

 

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

Post #291461
Posted Friday, June 30, 2006 5:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 10:04 AM
Points: 585, 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.

Post #291476
Posted Friday, June 30, 2006 5:59 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 35,366, Visits: 31,906
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #291478
Posted Friday, June 30, 2006 6:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 1, 2011 11:39 AM
Points: 1, 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 ...
Post #291495
Posted Friday, June 30, 2006 8:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 4, 2012 11:13 AM
Points: 257, 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.

Post #291540
Posted Friday, June 30, 2006 9:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:55 AM
Points: 934, Visits: 1,007

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




Post #291555
Posted Friday, July 7, 2006 12:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 4, 2012 11:13 AM
Points: 257, 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.

Post #292902
Posted Sunday, July 1, 2007 11:36 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 35,366, Visits: 31,906

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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #378113
Posted Thursday, July 5, 2007 12:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 7, 2007 2:34 PM
Points: 2, 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...

Post #379332
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse