• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

Maximum table size


My enterprise has SQL SERVER2008 with many databases and each with many tables.

What is the maximum disk size of a table in sql server before the BBDD lose performance?

This table only made Inserts and Updates. The records are updated only by primary key

Best Regards
2 Solutions
There  is no limitation, it all  depends upon

1. Retention period
2. Number of records
3. Amount  of user targetted based  on it you may  go for partition.

Aslong  as your DB configured with good  hardware and parallel  option, the back-up will run fast...
Anthony PerkinsCommented:
What is the maximum disk size of a table in sql server before the BBDD lose performance?
It depends.
JaimesastreAuthor Commented:

I need the size aprox: 3GB, 6GB, 60GB .....

It depends as in :

When you insert and have a clustered key that is not continuous then reorganizations must take place.
Must db expand regularly during an insert or is there always suffient allocated space.
How many indexes must be maintained

Does it expand rowsize (page full?). Does it update columns that are in many indexes?
How does your update find the record/records to update (index or table scan? ). One update for many records at a time or many updates for one record at a time.

Never reads? How index seek or scan? Filtered indexes, table partitioning

Other considerations for that db
Transaction model (full, simple, bulk logged). Locking by other processes that slow down or your process locks other processes. Maintenance (free space, index fragmentation, frequency TLOG backup).

Memory , disk configuration, CPU's , tempdb and how your large table access fits in the load with other processes/databases/storage/network.
Ex. loading and reports at night ... but not in backup window

The list is open

A 30MB table can be more a daily problem as 3GB table ..... it depends
Anthony PerkinsCommented:
Exactly! Size does not matter.  What counts is your hardware, how well designed are your tables and how well optimized are your queries.  They could be 3TB and be lightening fast or be 3MB and be a dog.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now