What is the biggest DB size SQLserver can handle ?

[Former Member]

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!

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Could you direct me to some doc for the typical setup for the HW handling that volume?

Thanks!

[Former Member · Accepted solution]

Check this [doc|http://blogs.msdn.com/saponsqlserver/archive/2009/06/24/new-sap-on-sql-server-2008-whitepaper-released.aspx].

Sven