| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2005-10-24 : 09:38:27
|
| Hello Every1,I see there are a lot of SQL gurus in this forum and just curious I have heard of few comments such as, we put the smaller dbs on SQL server and the larger ones on oracle and DB2Whats the size of the largest db you have worked with ?Afrika |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-10-24 : 10:23:40
|
5 gig.Go with the flow & have fun! Else fight the flow  |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-10-24 : 10:27:45
|
| Hey Spirit1What about number of columns ?` |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-10-24 : 11:03:53
|
| Yeah, besides, its not how big it is it's how you use it...(it ain't the meat, it's the motion)btw, I hear that if you SET FIPS_FLAGGER too often you could go blind.We don't have what I consider to be huge databases we do have a lot of databases though. Our largest is about 30 gig.Be One with the OptimizerTG |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-10-24 : 11:05:47
|
| number of columns??? in the whole database? around 2000.Go with the flow & have fun! Else fight the flow |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-10-24 : 11:06:38
|
TG: it's not the size of the ocean, it's the motion of the ocean  Go with the flow & have fun! Else fight the flow |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-10-24 : 11:14:43
|
| >> Whats the size of the largest db you have worked with ?80GB+>> What about number of columns ?The largest tables go 30 mil rows+ and 40 columns+>> Isn't that a rather personal question...I mean doesn't it matter if it's a romantic situation or not?Probably. But I can give some numbers, and keep a neutral stance on the subject What is the reason for this question Afrika, is it to justify/compare SQL Server abilities contra Oracle & DB2 at you shop ?rockmoose |
|
|
|
Wang
Starting Member
48 Posts |
Posted - 2005-10-24 : 12:07:23
|
| We run at about 150gig. |
|
|
|
DBCowboy
Starting Member
26 Posts |
Posted - 2005-10-24 : 12:29:07
|
| I worked with one that was well over 100 gig at my last job, and that was after the data in it was pulled out of another database with 75 gigs of its own data. Gotta love lawyers wanting to keep "notes" historically *and* keep it live and accessible. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-10-24 : 12:39:32
|
We have many inside MS that are > 100GB - one that I've worked with is 1.6TB. CHECKDB of it in SQL Server 2005 on an 8-way with a kick-ass IO system ran in under 7 hours (we made CHECKDB faster and scale better than SQL2k even though it does more checks!)  Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-10-24 : 13:09:08
|
I just had a silly @$$ at one of our sub-contacted Warehouse’s Try to tell me they needed to use oracle because the Db was larger than 5GB. (Must have been looking at the old SLQ desktop specs or something). Then after he said something about my website. I found out he was using a old G3 Mac “the best computer ever made” God This guy is so stupid I wana Puke! JimUsers <> Logic |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-24 : 14:00:19
|
| Verizon uses SQL Server 2005 and they have around 4TB in a single database. There were a lot of people at PASS 2005 that had databases in the terabytes. Largest I've ever worked with was around 1GB though.Tara |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-10-24 : 14:22:00
|
quote:
Originally posted by tduggan
Verizon uses SQL Server 2005 and they have around 4TB in a single database. There were a lot of people at PASS 2005 that had databases in the terabytes. Largest I've ever worked with was around 1GB though.Tara
Yup - spent a couple of weeks with them last spring. They have a much larger volume of data on DB2 mainframes.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-10-24 : 14:40:18
|
quote:
What is the reason for this question Afrika, is it to justify/compare SQL Server abilities contra Oracle & DB2 at you shop ?rockmoose
Hi Rockmoose, 1. Share curiosity ('cos nothing lost, but everything gained, esp KNOWLEDGE !!!)2. FunEver had a new car and wanted to know how fast it goes ? Well those were those days. Well not really contrary to oracle, I personally am a MS fan. Afrikaquote:
Originally posted by X002548Isn't that a rather personal question...I mean doesn't it matter if it's a romantic situation or not?
Oh oh, so you are one of them ? hmmmmmmmmmmmmmquote:
Originally posted by Spirit1it's not the size of the ocean, it's the motion of the ocean
quote:
Originally posted by tdugganVerizon uses SQL Server 2005 and they have around 4TB in a single database.
Thats amazing ? A single db ? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-24 : 14:50:44
|
| Sort of, here's the official address:http://www.verizonwireless.com/b2c/index.jspI don't know exactly what part they store in there, I suspect it's their data warehouse. Perhaps Paul can give us some information. I believe they don't mind sharing it as I've heard their numbers at 2 different conferences now.Verizon is a huge cellular company here. Both my personal and work cell phone are through them.Tara |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-10-24 : 15:06:53
|
| hi Paul,nice to meet an MS lead techie. Must be a world of fun. could you shed more light ? If not TOP SECRET :-(I did a site survey on both verizonwireless and verizon and both run solaris OS |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-24 : 15:20:23
|
| The biggest here is a 78GB database. According to Microsoft SQL Server 2000 Performance Tuning, it is barely a medium size database. Besides. It is largely image data.Overall, though, I have to watch over some 278 databases totaling 386GB over 46 servers. Some day we will consolidate. If ever someone gives up a budget.I still don't think we are scratching the suface of SQL Server performance. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-24 : 15:27:53
|
| "I mean doesn't it matter if it's a romantic situation or not?"Different sort of "Gig" I think Brett!We try to keep all our databases under 5GB - less effort to get right then! So we purge stale data relentlessly. (Actually we BCP it out to "Native" files, and then delete, so that we can pull it into a "temp" database if needed - it almost never is)Tables : 309MinCol MaxCol AvgCol ----------- ----------- ----------- 1 81 16Max rows: 12,316,368 (2,250GB)Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-24 : 15:37:10
|
| Kristen,What's the reasoning behind keeping the database under 5GB?Tara |
|
|
|
Previous Page&nsp;
Next Page
|
Whats the size of your DB ?