|
|
|
SSCommitted
      
Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928,
Visits: 224
|
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:22 PM
Points: 66,
Visits: 483
|
|
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
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Saturday, February 09, 2013 4:45 PM
Points: 584,
Visits: 49
|
|
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.
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893,
Visits: 26,765
|
|
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."
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Sunday, May 01, 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 ...
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, October 04, 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.
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: 2 days ago @ 10:29 AM
Points: 889,
Visits: 931
|
|
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
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, October 04, 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.
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893,
Visits: 26,765
|
|
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."
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, August 07, 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... 
|
|
|
|