Bonjour a tous,

Mon entreprise planche sur un projet de reporting.

Pour cela mon responsable souhaiterais connaitre les limites de sql server quand au nombre de transactione et d'enregistrement qu'il peut gerer.

La question principale est la suivante SQLServer peut il supporter un accroissement de 12 500 000 d'enregistrement par mois.

Merci de votre aide.

Je vous donne le contenu de son e-mail (in english sorry):

We are maintaining 25 databases (one per country) on 25 MS SQL Servers. Each end of month, a cost allocation is made on each database.

Average monthly data created by the allocation: 500,000 records / DB (it can be much more in extreme cases)

Average time of Cost Allocation: at least 4-8 hours / DB (in case of 500,000 records)

We are on a project of centralizing all data on the Same Database.

In this case, the allocation will have to be run on a big number of databases (18 countries / ~25 databases)

If taking the average of 500,000 records each month, we are looking at 25*500,000 = 12 500 000 records per month –

I think that this is pushing SQL’s limits. Could you let me know if MS SQL technology chosen could cope with the above estimated number of transactions.