Another note, it is best to have serperate DISKS for different parts of the SQL server, makes things a lot faster.
SQL server itself on a separate disk form the OS Another separate disk for full-text catalogs, indexes etc > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 17:07 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] OT:large (300M+) SQL server installation > > We have several Global Databases which have in and around > (sometimes above) this row count on several tables.... > > SQL Server is certainly up for the job, its simply a case of > the following > > 1) Got enough disk space for the job? > 2) Got enough RAM? > 3) Got a decent backup plan and space to store backups (ideally 4 day > incrementals) > 4) Got a decent maintenance plan to monitor DB stats and > indexed frequently > 5) Got a good relational design to stop locking etc on larger queries > > There are more but these are the main pointers when dealing > with a DB of this size... > > Ideally you would run a DB of this size over a cluster of > servers than on just the one server but if its all you got > then pack that bad boy full of ram and disk space and go for it... > > N > > > > > > -----Original Message----- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 16:46 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] OT:large (300M+) SQL server installation > > > Apologies for the OT post but this is where all the real > gurus hang out > right ;-) > > Does anyone have any experience with large scale SQL server > installations - 300Million rows+ if so could you contact me off list? > > Thanks > > Kola Oyedeji > Certified Advanced Coldfusion Developer, > ICLP London > DDI: +44 (0) 208 256 9034 (Ex.2204) > > www.iclployalty.com > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided > by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of > Reed Business, > Registered in England, Number 678540. It contains > information which is > confidential and may also be privileged. It is for the > exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note > that any form of distribution, copying or use of this > communication or the > information in it is strictly prohibited and may be unlawful. > If you have > received this communication in error please return it to the > sender or call > our switchboard on +44 (0) 20 89107910. The opinions > expressed within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
