SQL and DB Sizing for SMS 2003

re: SQL and DB Sizing for SMS 2003

Thu, 10 Jun 2004 16:08:00 GMT

Craig, under the heading "Detailed Analysis of DB Usage" you said "...the mistake many made was in not considering the storage needs of these new items and designing the extensions to utilize multiple tables and indexes."

As one who implemented many SMS2 MOF additions, I'd like to better understand the specifics of your comment. What are the considerations I should keep in mind in light of this comment as I tweak the SMS2003 MOF so I can avoid the problem referred to.

Thanks for an EXCELLENT overview of an often-misunderstood topic!

re: SQL and DB Sizing for SMS 2003

Matt G. — Tue, 15 Jun 2004 20:58:00 GMT

SO is there a tool coming or not???

re: SQL and DB Sizing for SMS 2003

SMSPerfGuy — Wed, 16 Jun 2004 00:18:00 GMT

For Hardware sizing and hierarchy capcity planning, yes.
At present this doesn't include SQL server sizing calculations. A future version likely will.
Using the "rules of thumb" in this article should steer you in the right direction thou.

Cheers
Craig

re: SQL and DB Sizing for SMS 2003

SQL and DB Sizing for SMS 2003 — Wed, 14 Jul 2004 18:35:00 GMT

ddd

This One IT Site » Blog Archive » SQL and DB Sizing for SMS 2003

This One IT Site » Blog Archive » SQL and DB Sizing for SMS 2003 — Tue, 08 Aug 2006 23:05:21 GMT

PingBack from http://netsaber.wordpress.com/2006/08/08/sql-and-db-sizing-for-sms-2003/

SMS2003 Database Sizing

Random Robs Blog — Mon, 18 Dec 2006 14:10:19 GMT

Sizing an SMS2003 database is an often misunderstood subject, which can cause a lot issues if not done...

SQL and DB Sizing for SMS 2003

SQL and DB Sizing for SMS 2003 — Mon, 26 Nov 2007 08:14:10 GMT

PingBack from http://feeds.maxblog.eu/item_645064.html

Which size of Data base we must to use for SMS 2003 SP2 | keyongtech

Which size of Data base we must to use for SMS 2003 SP2 | keyongtech — Thu, 22 Jan 2009 10:30:17 GMT

PingBack from http://www.keyongtech.com/2060550-which-size-of-data-base

SMSPerfGuy s WebLog SQL and DB Sizing for SMS 2003 | home lighting

SMSPerfGuy s WebLog SQL and DB Sizing for SMS 2003 | home lighting — Fri, 19 Jun 2009 08:36:07 GMT

PingBack from http://homelightingconcept.info/story.php?id=2721

SMSPerfGuy s WebLog SQL and DB Sizing for SMS 2003 | garden statues

SMSPerfGuy s WebLog SQL and DB Sizing for SMS 2003 | garden statues — Fri, 19 Jun 2009 11:53:29 GMT

PingBack from http://gardenstatuesgalore.info/story.php?id=1535