Feeds:
Posts
Comments

Posts Tagged ‘Rules of thumb’

1. Close Distance Rule:

Keep Web Frontends, Application Servers and Database Servers physically located as close as  possible.

 

Rule of thumb: No more than 1 ms of latency between WFEs/AS and DB servers. In practice, this means: WFEs/ASs should reside in the same data center as DB servers.

 

 

2. Co-Location/Separation of Databases

Certain databases must be co-located or ideally separated from other databases.

 

Rule of thumb: Separate the following databases:

 

 

 

image

Source: Microsoft Technet

 

Rule of thumb: Co-locate the following databases:

 

 

image

Source: Microsoft Technet

 

3. Constantly Monitor Database Servers

Size: Rules of thumb:

    Pre-grow databases and logs.

    Monitor disk space at all times.

    < 50 Databases per SQL Server instance (when mirroring)

                          < 200 GB per content database

 

 

Metrics: Rules of thumb:

    Network Queue: 0 or 1 for best performance

    Average Disk Queue length (latency) : < 5 ms

                       Memory used: < 70%

                       Free disk space: > 25%

                       Buffer cache hit ratio: >= 90%

 

4. Transaction Logs Backup

Rule of thumb: Back up and truncate the transaction logs every 5 minutes. Shrinking the transaction logs is not recommended since it will have a performance impact while it re-grows.

 

 

For preventing the transaction logs to grow unexpectedly, view the following KB: http://support.microsoft.com/kb/873235

 

Thatโ€™s it for this time. Have fun configuring your DB servers for your SP2010 environment. As usual, no responsibility is taken for any damage that could occurr. And as ususal, I highly recommend trying all changes on a test environment and the adaptation to your specific IT infrastructure.

 

Enjoy and best regards,

Martin

Advertisements

Read Full Post »