Size: 66.3Gb
Growing rate: 50mb/day
OS: Windows Server 2003 x64
SA Version: 9.0.2

asked 18 Nov '09, 17:05

Zote's gravatar image

Zote
1.7k364050
accept rate: 43%

edited 15 Mar '13, 18:49

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275


Only 11 GB, but it's not a production database, it's a test database for recommender system applications.

permanent link
This answer is marked "community wiki".

answered 18 Nov '09, 20:47

Tom%20Slee's gravatar image

Tom Slee
1.2k21429
accept rate: 29%

Our largest one is 255GB and is growing at about 3-5GB a month. We have several others that range from 70 to 200 GB on our ASP servers.

ASA 9.0.2.3508 on Business class hardware .

The primary bulk is from blobs containing images, but we do have some tables with millions of rows and some with over 100 million rows (but these are fairly 'narrow' rows).

Performance is fine. We do spend a fair amount of time making sure that queries perform well before adding them to the system. We also have built a tool that automatically extends the database to minimize fragmentation and also automatically defragments tables and indexes as needed.

Don't have metrics on the number of queries/updates per day at the database, but do for EAServer function calls (the busiest server does over a million a day) per day. All database access goes through EAServer.

Alex

permanent link
This answer is marked "community wiki".

answered 29 Apr '10, 23:35

Alex%20Whitney's gravatar image

Alex Whitney
113
accept rate: 0%

edited 06 May '10, 19:54

I've got a 25gb database replicating most everything to a 35gb database via dbremote. Works great! Hasn't got much spam in it.

permanent link
This answer is marked "community wiki".

answered 13 Apr '10, 01:32

Ron%20Hiner's gravatar image

Ron Hiner
880202427
accept rate: 9%

1

my comment made more sense before the list was resorted.... it used to be below Breck's waitress dialog. I guess you should never trust to sequence of things in life without an explicit ORDER BY

(07 May '10, 19:18) Ron Hiner

Currently 53GB, with about 800MB/day in growth.

Our situation is a little unique because an external program cycles binary PDF data out of the database after 15 days, and re-entered when requested through a secondary database/remote procedures. Without this system, the database would be at least 600GB. Non-binary data accounts for about 65MB/day in growth.

Database: SQL Anywhere 9.0.2.3249

OS: Windows Server 2003 R2 32-bit

CPU: 4x Intel Xeon Dual Core 3.00GHz

RAM: 64GB (60GB Allocated to SQL Anywhere cache)

HDD: DB on RAID5 SCSI-320 (15k RPM - 4 Disks), TempFile/TranLog on RAID5 SCSI-320 (15k RPM - 4 Disks)

permanent link
This answer is marked "community wiki".

answered 18 Nov '09, 22:58

Ralph%20Wissing's gravatar image

Ralph Wissing
3153711
accept rate: 0%

600G

Alas, I cannot talk publicly about client databases, but at this moment my newer R&D server is set up with a fairly large database for Foxhound testing. Right now, it's empty, and it doesn't have the 600G secondary dbspace set up. The box was locally-assembled by my good friends at Tsunami Technology. All the bits and pieces are consumer-grade because of my natural bias towards helping people save money (including me). Increasing the RAM is on my to-do list.

Database: SQL Anywhere 11.0.1.2276

OS: Windows Vista Ultimate SP1 64-bit

CPU: 4x Intel Core 2 Quad Q9450 2.66GHz

RAM: 4GB (3GB allocated to SQL Anywhere cache)

HDD: system dbspace on 931G D: drive, translog on 465G E: drive, translogmirror on 465G C: drive, temporary on 931G F: drive... in the stores these are called "1T" and "500G" drives.

Foxhound says this...

Image Hosted by ImageShack.us

Here are the Windows command lines that go from empty drives to a pair of dbisql client sessions. You can read about the options here: dbinit, dbspawn, dbsrv11 and dbisql.

"%SQLANY11%\bin64\dbinit.exe" ^
   -dbs 600G ^
   -et ^
   -m C:\data\big\big.log ^
   -p 8192 ^
   -s ^
   -t E:\data\big\big.log ^
   D:\data\big\big.db

"%SQLANY11%\bin64\dbspawn.exe" ^
   -f "%SQLANY11%\bin32\dbsrv11.exe" ^
   -c 3G ^
   -ch 3G ^
   -dt F:\data\big ^
   -o D:\data\big\dbsrv11_log_big.txt ^
   -oe D:\data\big\dbsrv11_log_fatal_big.txt ^
   -os 10M ^
   -x tcpip ^
   -ze ^
   -zl ^
   -zp ^
   -zt ^
   D:\data\big\big.db

"%SQLANY11%\bin32\dbisql.com" ^
   -c "ENG=big;DBN=big;UID=dba;PWD=sql;CON=big-1"

"%SQLANY11%\bin32\dbisql.com" ^
   -c "ENG=big;DBN=big;UID=dba;PWD=sql;CON=big-2"
permanent link
This answer is marked "community wiki".

answered 19 Nov '09, 08:56

Breck%20Carter's gravatar image

Breck Carter
27.0k444614889
accept rate: 21%

Biggest customer DB

Size: 22Gb

Growing about 2 MB/d

HW: Dual Xeon 2.4 4 GB RAM

OS: W2K3 Server 32 Bit

SA Version: 9.0.2

permanent link
This answer is marked "community wiki".

answered 19 Nov '09, 11:10

Reimer%20Pods's gravatar image

Reimer Pods
4.2k354583
accept rate: 11%

About 120GB, a lot of it is blob data (docs and photos). Product enhancement suggestions to optimize dealing with important but rarely accessed (individually) blobs is something I've been meaning to post on for a while.

With a databases this size we have found validation time is the biggest issue . Generally performance is fine with appropiate (but not silly) hardware.

permanent link
This answer is marked "community wiki".

answered 23 Nov '09, 12:51

Justin%20Willey's gravatar image

Justin Willey
7.0k115148219
accept rate: 21%

So ask your questions! re: important but rarely accessed blobs, and validation time. And tell us about your hardware: is it consumer or business grade? etc. If you can tell us.

(23 Nov '09, 20:13) Breck Carter

This isn't a contest, but... Justin is currently number one on the leader board of real databases.

(23 Nov '09, 20:14) Breck Carter

I get the impression from the newsgroups that thre are much much larger ones out there - into the multiple hundreds of GB

(24 Nov '09, 13:21) Justin Willey

Size: 13G

Database: SQL Anywhere 9.0.2.3804

OS: Windows Server 2008 64-bit running on VMWare vSphere running on HP BL480c 2xX5470

Allocated: 4 vCPUs, 8G of RAM

Storage: EMC Clariion 4-120 with 30x300G fibrechannel disks

permanent link
This answer is marked "community wiki".

answered 07 Dec '09, 10:58

georgi's gravatar image

georgi
11
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×13
×10
×3

question asked: 18 Nov '09, 17:05

question was seen: 2,747 times

last updated: 02 Dec '15, 01:16