How many records can i store in a Sql server table before it's getting ugly?
- by Michel
Hi,
i've been asked to do some performance tests for a new system.
It is only just running with a few client, but as they expect to grow, these are the numbers i work with for my test:
200 clients, 4 years of data, and the data changes per.... 5 minutes. So for every 5 minutes for every client there is 1 record.
That means 365*24*12 = 105.000 records per client per year, that means 80 milion records for my test.
It has one FK to another table, one PK (uniqueidentifier) and one index on the clientID.
Is this something SqlServer laughs about because it isn't scaring him, is this getting too much for one quad core 8 GB machine, is this on the edge, or.....
Has anybody had any experience with these kind of numbers?