asked on
Maximum table size
Hello
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
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
Microsoft SQL Server 2008
Last Comment
Anthony Perkins
What is the maximum disk size of a table in sql server before the BBDD lose performance?
It depends.
It depends.
ASKER
Hello
I need the size aprox: 3GB, 6GB, 60GB .....
Thanks
I need the size aprox: 3GB, 6GB, 60GB .....
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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...