IDERA ER/Studio Repository Database Sizing Guide SQL Server Edition – Best Practices

by Mar 15, 2016

ER/Studio Database Sizing Guide - Best Practices

IDERA 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 IDERA 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!