Survey: How much data do you work with?

Most of them are between 50-500GB

I also deal with category 4 (OMG Size)

the ones I use most are between 500GB - 2TB and these are OLAP DBs

Of course I also deal with the up to 50GB but they are becoming rare

I guess the answer would be 4 since I have several database in the 7 to 10 TB range.

I work with nearly 300 instance on over 200 servers. Most databases are under 100 GB. But some are real hugh. For example our Sharepoint has over 2 TB content databases-

several #1, couple of #2 and one #3

5)  Greater than 100TB per DB

Our databases fall into the 1 and 3 range.  They are basically pretty small (few hundred megs) or 1 TB in size.

At my current position it's about 50/50 between 2 and 3.  At my last position it was about the same as well.  Never worked with any 4's

Ignore my last comment.  I misread the #'s.  Mine are all currently 1's  I read MB where it was GB.

1 and I thought we had reached the big time when one of our tables went over 1 million records in it. In reality our databases are very small compared to others that have replied.

up to 50GB

Hi James

Currently I am working with 2-3 range size.

Small databases (1 & 2) numbering in the hundreds, and one bigger warehouse (2 TB)

Mostly in the 2+ TB range. But certainly not in the 100 TB range! Would love to hear more information from DonRWatters about what kinds of databases he's working on.

James, 750 TB?? Maybe it's you who needs to tell us more.

Mostly 1 with a couple of 2.  Most of the 1s are less than 10GB.

Mostly #1, couple of #3 and one of #4.

Mine are usually in the S-M sizes mostly 2) 50-500GB range, do have couple of DB's with individual TABLES ~700GB each (No BLOB data), those can be fun @ times .. but nothing too large (thankfully)

Intresting to know also what Editions these larger DB are using.

I'm using x64 Std 2005 SP3 mostly (no EE as yet)..I plan to go to 2008 R2 (x64)soon, compression would help shrink these down some (but that needs EE)