TIP: Using EBMUTIL for Data Compaction
SOFTWARE: Electrical Bid Manager SQL Plus/Pro
Feedback from those using our SQL versions of Electrical Bid Manager (EBM), in reference to increased speed and stability, has been tremendous. There is no doubt the efficiency EBM provides during job takeoff is enhanced when the program is installed in the SQL environment, especially for those who run the application across a network. However, over time one may notice that the disk space requirements for the database may increase greatly.
This is a common occurrence with SQL databases, where SQL Server will increase the database files to reserve space for future transactions. SQL Server will allow the database to be shrunk by using the DBCC SHRINKDATABASE command, through Query Analyzer, in order to regain unused disk space. Yet, this has been known to affect performance, forcing SQL Server to attempt new disk space acquisitions during each data transaction (see Microsoft Knowledgebase article #315512).
So, where is the happy medium in regards to the keeping disk space consumption to a minimum, while maintaining optimum performance? That would depend on the application. Should the need arise to regain disk space reserved by EBM data files, we suggest using the “Compact Database” function in our EBMUTIL program. This function takes into consideration the space requirements for the many data transactions EBM will perform during takeoff, while recovering unused disk space from SQL. Available disk space can be recovered, while performance during job takeoff is kept at an optimum level.
To learn more about using EBMUTIL, contact technical support at 800.605.2167, or email firstname.lastname@example.org.
To learn more about our Electrical Bid Manager SQL, click here.
written by Carlyle Poole – Vision’s Technical Support Professional