During a performance optimization workshop, among others, a variety of useful utilities is installed - the "NAV/SQL Performance Toolbox"!
The PTB is a collection of useful SQL Server stored procedures and NAV objects to optimize all performance-relevant aspects of the system.
Each single feature could be adjusted to fit the specific requirements!
Content and Functions:
Optimization of SQL Server Instance- and Database- Configuration
Deletion of dispensable records from SIFT tables
Analysis and Optimization of SIFT and VSIFT structures
Investigation and deletion of needless indexes
Removal of needless fields from non-clustered indexes
Re-organisation and defragmentation of indexes using optimal fillfactors
Design of indexes with optimizedselectivity
Clean-up and creation of index-statistics
Analysis of locks and blocks on resource- and process-level
SQL query optimization and Query Hinting
and much more!
Here all features could be easily configured and executed, "ad hoc" or automatic - as required.
The procedures could be executed directly on SQL Server, as well as triggered by the NAV application (if required).
The result is an improvement of read- and write performance of the NAV/SQL Server system between 30% and 100% (maybe more!)!
Means there are no license fees or sth. -
it comes together with the Workshop or Training!
"It's not the tool which fixes a problem ... it's the person using it!"
The PTB is exclusively distributed by STRYK System Improvement and authorized partners.
These competent MS Dynamics Partners grant the correct installation and configuration of the PTB and take care about the training of the local administrators.
Authorized partners are (excerpt):
If you would like to become a "Toolbox Partner" please send me a notice!
Parts of the PTB, the procedure "ssi_delzerosift" (available for free on Mibuso.com or this site) is used for more than 2.500 times,
the "Block Detection" processes (available for free on Mibuso.com or this site) more than 2.500 times!
The "Toolbox" itself has been installed more than 400 times since first release in December 2006!