December 29, 2009 at 10:13 am
Hi All,
We are planning to setup clustering. Would like to know what is the best practice for it.
Also we are planning for the Database capacity what will be the checklist for it. What should be considered, any calculation, checklist or FAQs.
Thank you.
Cheers,
Got an idea..share it !!
DBA_Vishal
December 29, 2009 at 10:37 am
Hit your favourite search engine and search for clustering best practices on technet.microsoft.com. There are pages and pages (and I mean that quite literally) on it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 8:59 pm
GilaMonster (12/29/2009)
Hit your favourite search engine and search for clustering best practices on technet.microsoft.com. There are pages and pages (and I mean that quite literally) on it.
Thanks, got load of pages for cluster setup, but for DB capacity planning is there any checklist, calculation etc ?
Cheers,
Got an idea..share it !!
DBA_Vishal
December 30, 2009 at 1:00 pm
Setting one up myself currently, Edwin Sarmiento has a great 4 part article.
http://www.mssqltips.com/tip.asp?tip=1687
as far as calculations you could try a linear growth
which is just a projected amount of growth per month
or Geometric Growth
Future Size= current Size x (1+growth rate) ^number of periods
(Both of these are straight from chapter 1 of the 70-443 book it is a good read with a lot of good info if you don't have it I would recommend going out and getting it.)
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
December 31, 2009 at 7:11 pm
Thanks SSC Journeyman.
Cheers,
Got an idea..share it !!
DBA_Vishal
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply