ER/Studio Database Sizing Guide – Best Practices
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.