database size

Question

Post reply

database size

chess.chess

SSC Veteran

Points: 281
More actions
August 2, 2011 at 11:57 am

#242373

Hi , what is the average size of a large database for an application like
online banking ? i.e. how many tables and MBs of data ? Just looking for an average number as I have no idea what is possible ...

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

50 TB.

I've seen bigger data warehouses.

Why do you need to know?

ggoble Hall of Fame Points: 3337 More actions · Answer 2

All depends on how much data is stored and for how long. I'd imagine a bank like Bank Of America databases are probably big >TB (just a guess) compared to a small credit union that might only be <50 GB

chess.chess SSC Veteran Points: 281 More actions · Answer 3

Thanks . Just curious .

... how many tables and views would that be ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

This is a classic 'It depends'. There's no normal values for database size, table count or row count.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

chess.chess (8/2/2011)
Thanks . Just curious .
... how many tables and views would that be ?

Between 10 and 100000 with possible outliers on either side.

Seriously, there's no normal value for things like that.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ggoble Hall of Fame Points: 3337 More actions · Answer 6

ggoble

Hall of Fame

Points: 3337

August 2, 2011 at 12:02 pm

#1362440

42

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

chess.chess (8/2/2011)
Thanks . Just curious .
... how many tables and views would that be ?

I've seen 10K tables a few times. I've heard of 30K for SAP.

Biggest table I have now is around 20M rows, 2.5GB.

Phone companies will hit that daily for the list of calls.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Ninja's_RGR'us (8/2/2011)

Biggest table I have now is around 20M rows, 2.5GB.

Biggest I've heard of was 100 000 000 000 rows (no idea of size or what it stored)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 9

chess.chess (8/2/2011)
Hi , what is the average size of a large database for an application like
online banking ? i.e. how many tables and MBs of data ? Just looking for an average number as I have no idea what is possible ...

HSBC centralized system or First Lake Okeechobee Natinal Bank?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

chess.chess SSC Veteran Points: 281 More actions · Answer 10

I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

Really can go as high as 10000 ?

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 11

yes.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

chess.chess SSC Veteran Points: 281 More actions · Answer 12

chess.chess

SSC Veteran

Points: 281

August 2, 2011 at 12:10 pm

#1362452

OK , thanks . Didn't expect that .

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

GilaMonster (8/2/2011)

Ninja's_RGR'us (8/2/2011)
Biggest table I have now is around 20M rows, 2.5GB.
Biggest I've heard of was 100 000 000 000 rows (no idea of size or what it stored)

US debt

database size

Cookies on SQLServerCentral