| Author |
Topic |
|
doubleotwo
Yak Posting Veteran
69 Posts |
 Posted - 2010-06-29 : 03:09:04
|
| Im not too familiar with administration of Databases but an insert of 200 rows a day, is this a lot? or does this is easy to maintain by a sql server 2008? |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-06-29 : 03:23:09
|
| I feel that SQL can easily handle a million of inserts daily. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-06-29 : 05:20:29
|
| 200 rows a day is nothing, very small number of changes. I've worked with a DB where one table (out of 500) got 2 million inserts a day--Gail ShawSQL Server MVP |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-06-29 : 05:45:43
|
Gail, you must mean 2 billion? 2 million is nothing...
N 56°04'39.26"E 12°55'05.63" |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-06-29 : 06:40:54
|
| No, one table had 2 million a day (all done in 1 hour in the morning), there were 500 other tables, several with close to the same level. SQL handled the entire thing without serious problem.I know 2 million's nothing, but it was only a 1 TB database.--Gail ShawSQL Server MVP |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2010-07-01 : 17:18:30
|
| Biggest table row count I've seen so far is just over 9 billion rows in a 8 TB database. After analysing the 3rd party DB, we determined that we could delete some data (1.9 billion rows), which took us 3 days, but was done during 24x7 usage - so that was about 800 million rows a day, of slightly over 25 million rows an hour, each hour.After that, we got the 3rd party to design and implement partitioning. Now rolling them deletes lot's faster :)*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-01 : 17:53:45
|
quote:
Originally posted by Wanderer
Biggest table row count I've seen so far is just over 9 billion rows in a 8 TB database.
Biggest I've heard of (in session at PASS Summit last year) was 100 billion rows. Person wouldn't tell me what he stored or how big the DB was.--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-07-01 : 18:31:28
|
| My biggest table has 2 billion rows in it, but rapidly growing. The database is over 3TB in size, but it's currently growing 45GB per day. We will be migrating to SQL Server 2008 in the next two weeks and then enabling compression. The project had originally requested 165TB of SAN space. Our SAN vendor, HP, was salivating. I knew it never would get approved, but it was interesting to hear a ballpark quote.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-07-02 : 02:51:58
|
my biggest has 16 billion or so. beware on large rowcount tables using bcp to export - bcp fails if you try to export/import more than max_int! at least it's that way with 2005. supposed to be fixed on 2008 but I haven't tested it.
elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-07-02 : 04:52:50
|
Don't think it's fixed.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
performance 300+ rows a day