SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Whats the size of your DB ?
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 3

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/24/2005 :  09:38:27  Show Profile  Reply with Quote
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

Slovenia
11749 Posts

Posted - 10/24/2005 :  10:23:40  Show Profile  Visit spirit1's Homepage  Reply with Quote
5 gig.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/24/2005 :  10:27:45  Show Profile  Reply with Quote
Hey Spirit1
What about number of columns ?`
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/24/2005 :  10:39:16  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
5914 Posts

Posted - 10/24/2005 :  11:03:53  Show Profile  Reply with Quote
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

Slovenia
11749 Posts

Posted - 10/24/2005 :  11:05:47  Show Profile  Visit spirit1's Homepage  Reply with Quote
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

Slovenia
11749 Posts

Posted - 10/24/2005 :  11:06:38  Show Profile  Visit spirit1's Homepage  Reply with Quote
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

Sweden
3279 Posts

Posted - 10/24/2005 :  11:14:43  Show Profile  Reply with Quote
>> 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 - 10/24/2005 :  12:07:23  Show Profile  Reply with Quote
We run at about 150gig.
Go to Top of Page

DBCowboy
Starting Member

USA
26 Posts

Posted - 10/24/2005 :  12:29:07  Show Profile  Send DBCowboy an ICQ Message  Reply with Quote
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

USA
899 Posts

Posted - 10/24/2005 :  12:39:32  Show Profile  Visit paulrandal's Homepage  Reply with Quote
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

USA
1534 Posts

Posted - 10/24/2005 :  13:09:08  Show Profile  Visit JimL's Homepage  Reply with Quote
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

USA
35934 Posts

Posted - 10/24/2005 :  14:00:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
899 Posts

Posted - 10/24/2005 :  14:22:00  Show Profile  Visit paulrandal's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/24/2005 :  14:40:18  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

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

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 10/24/2005 :  14:50:44  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/24/2005 :  15:06:53  Show Profile  Reply with Quote
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 - 10/24/2005 :  15:20:23  Show Profile  Reply with Quote
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

United Kingdom
22403 Posts

Posted - 10/24/2005 :  15:27:53  Show Profile  Reply with Quote
"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

USA
35934 Posts

Posted - 10/24/2005 :  15:37:10  Show Profile  Visit tkizer's Homepage  Reply with Quote
Kristen,

What's the reasoning behind keeping the database under 5GB?

Tara
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000