Thanks KOla
>> -----Original Message----- >> From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- >> [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]
