ER/Studio Database Sizing Guide - Best Practices

Posted by on in Data Modeling & Architecture

ER/Studio Database Sizing Guide - Best Practices

Howdy!

In this blog post, let us shed some light on how to better leverage Capacity planning and Database Sizing for ER/Studio's Repository Database.

I will be covering each individual Database Platform per blog post.

In today's series, I will be covering Microsoft SQL Server:

For Microsoft SQL Server Database: 

Perform the following steps:

After approx a month or so of repository activity, 

1) Run sp_updatestats to update table statistics

2) During non-production hours perform a re-org on the indexes

Tomorrow I will cover Oracle topics.

Stay tuned!



Comments

Check out more tips and tricks in this development video: