Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Whats the size of your DB ?

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 DB2

Whats 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
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 10:27:45
Hey Spirit1
What about number of columns ?`
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-10-24 : 10:39:16
What is the size of my DB?

Isn't that a rather personal question...I mean doesn't it matter if it's a romantic situation or not?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

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 Optimizer
TG
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

Wang
Starting Member

48 Posts

Posted - 2005-10-24 : 12:07:23
We run at about 150gig.
Go to Top of Page

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.
Go to Top of Page

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 Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

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!

Jim
Users <> Logic
Go to Top of Page

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
Go to Top of Page

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 Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

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. Fun
Ever 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.

Afrika

quote:
Originally posted by X002548
Isn'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 ? hmmmmmmmmmmmmm

quote:
Originally posted by Spirit1
it's not the size of the ocean, it's the motion of the ocean



quote:
Originally posted by tduggan
Verizon uses SQL Server 2005 and they have around 4TB in a single database.


Thats amazing ?
A single db ?

Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-10-24 : 14:45:51
Do you mean http://www22.verizon.com/ ?
Go to Top of Page

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.jsp

I 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
Go to Top of Page

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

Go to Top of Page

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.
Go to Top of Page

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 : 309

MinCol MaxCol AvgCol
----------- ----------- -----------
1 81 16

Max rows: 12,316,368 (2,250GB)

Kristen
Go to Top of Page

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
Go to Top of Page
  Previous Page&nsp;  Next Page

- Advertisement -