May 22, 2008 at 10:59 pm
Hello!
Does know anyone what are the limitation of the SQL Server 2005?
For example:
If the database achieve 100-300 TB what happened with DB performance and also backup strategy
I know some techniques with materialized view, partitions etc but what about restore, managing filegroups etc!
Simple do you know any limitation for SQL Server 2005! Or any compare with Oracle!?
May 23, 2008 at 12:53 am
The technical limitations are listed in Books Online.
Max size of a single file - 16 TB. Max size of a log - 2TB, max files per DB 32767, max database size 524258 TB
Do you actually hace a DB approaching that size, or is this theoretical?
As for the practical limitations, that would depend completely on what you're doing with the DB. It would require careful planning, certainly.
I know the Customer Advisory Team (www.sqlcat.com) have worked with some really large databases.
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
May 23, 2008 at 1:24 am
hmmm... about this info 524258 TB max size for the DB ..are you sure that the DB with 100000 TB will work with good performance?
May 23, 2008 at 1:31 am
Find me a server with 100,000 TB of storage, and then we can talk.
Asking if something will have good performance is like asking how long a piece of string is. It cannot be answered out of context.
I've seen 2GB databases with terrble performance and 1.5 TB databases that perform wonderfully. It depends on too many variables to give a generalised answer.
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
May 23, 2008 at 2:11 am
GilaMonster (5/23/2008)
Find me a server with 100,000 TB of storage, and then we can talk...
LoL I never seen server with 100 TB! I cannot talk to you for this topic ..hahaha you are right
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply