Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Leads Management System Design Data Explosion Expand / Collapse
Author
Message
Posted Tuesday, December 23, 2008 5:50 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 7, 2014 9:09 AM
Points: 75, Visits: 206
Hi All,

I'm looking for a best practice approach. I've been charged with re-designing a leads management system that literally can yield between 10 to 100 million records within a quarter. This depends upon the customer based.

The current architecture is to create a new database for a given customer. Each customer database generates approx. 9 million records per month X 12. There are currently 150 customers X 108 million records. It's been forecasted that within the next year there will be 200 more customer will be added by the end of next year 350 databases X 108 million records. At this rate the current architecture will not be able to handle this scenario (in my opinion).

I've never dealt with this data volume even in ERP systems. How do I begin to tackle and fully optimize this system. I'm an Application Architect not a DBA or Data Architect.

How can I incorporate best practice design to this issue? Any references or books to review would be greatly appreciated?

I can provide additional details but I just found out today about the data explosion.

Thanks,


Post #625106
Posted Tuesday, December 23, 2008 7:04 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
You might want to contact the Microsoft SQL Customer Advisory Team. Their website is here: http://sqlcat.com/

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #625127
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse