Skip to Content
avatar image
Former Member

What is the biggest DB size SQLserver can handle ?

Experts:

We are going to start SAP projects for terabyte DBs.

What is the maximum DB size SQLserver(2005, 2008) can handle without serious performance issue?

Thanks a lot!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 05, 2010 at 09:24 AM

    Hi,

    we run multiple SAP systems beyond 1 TB (biggest around 12 TB) without any performance issues. Performance is not directly related to the size of the DB but on how you distribute the data (I/O capacity). Important factors are number of data files, type of storage (SAN, NAS,...), number of spindels, number of users, proper indexing and so on. Also, your DB server hardware should be able to process the data delivered by the storage system (CPU + RAM).

    The size of the DB ist not the important performance factor but the underlying hardware.

    Regards,

    Sven

    Add comment
    10|10000 characters needed characters exceeded