SQL Optimizer
Description
Don’t skip important maintenance or endure unnecessary downtime – losing productivity. SQL Optimizer works fast to save you hours & no down time.
Crestwood Associates knows how important it is to maintain your databases, and even more important are those indexes, so you keep up your speed. However, rebuilding indexes during maintenance often takes too long; therefore, people have to wait, you are scheduling them sparingly, or skip rebuilding them completely.
SQL Optimizer speeds up this process. It tests your databases against a set of thresholds, high and low. If the index fragmentation of the database is:
- Above the high level = the index is completely rebuilt
- Between low & high = the index is reorganized
- Below low = nothing happens
So, rather than rebuilding ALL indexes, all the time, SQL Optimizer reviews and only reorganizes or rebuilds what is necessary. It’s simple, it works, and it keeps your database running fast.
SQL Optimizer: Save Hours & No Down Time Example – You have 40-50 Dynamics GP Databases |
Please fill out the form below to contact us for more information.