How many records can i store in a Sql server table before it's getting ugly?
Posted
by Michel
on Stack Overflow
See other posts from Stack Overflow
or by Michel
Published on 2010-05-07T11:54:42Z
Indexed on
2010/05/07
11:58 UTC
Read the original article
Hit count: 243
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?
© Stack Overflow or respective owner
