DOCUMENT:Q213171 06-AUG-2002 [sms] TITLE :SMS: Unable to Schedule Software Metering Table Maintenance PRODUCT :Microsoft Systems Management Server PROD/VER:winnt:2.0 OPER/SYS: KEYWORDS:kbsms200 kbsms200bug ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server version 2.0 ------------------------------------------------------------------------------- SYMPTOMS ======== You may notice that performance levels of the online Software Metering Service decrease occasionally. CAUSE ===== The Software Metering Service (Remodbc.exe) performs maintenance on the database tables once a week by default. Software Metering Service database maintenance may experience problems if a table is open when maintenance is scheduled to occur. WORKAROUND ========== To work around this problem, use one or both of the following procedures: Pack the Software Metering Tables Manually ------------------------------------------ 1. Using the Systems Management Server 2.0 Administrators console, expand the Tools folder for your site. 2. Right-click SMS Service Manager, point to All Tasks, and then click "Start SMS Service Manager". 3. Click the plus sign (+) beside LICENSE_METERING. 4. In the right pane, right-click LICENSE_METERING, and then click Query. 5. Right-click LICENSE_METERING, and then click Stop. 6. Once again, right-click LICENSE_METERING, and then click Query until the service status reports "stopped." 7. Use the steps above to also stop LICSVR_SERVICE. 8. Stop the SMS_LICENSE_SERVER service on each software metering server. 9. Navigate to the Software Metering folder (swmtr), which is located on each software metering server. 10. Double-click Vfp_pack.Exe. 11. Wait for Vfp_pack.Exe to complete maintenance on the software metering tables. 12. You need to run Vfp_pack.exe on each software metering server in your site. 13. Using the SMS Service Manager, right-click LICENSE_METERING, and then click Start. Follow these same steps for the LICSVR_SERVICE. 14. Start the SMS_LICENSE_SERVER service on each software metering server after Vfp_pack has been run on each of them. Increase the Frequency of Software Metering Table Maintenance ------------------------------------------------------------- 1. Edit RemOdbc.Ini on the site server and in the Software Metering folder (swmtr) on all software metering servers using any text editor. 2. Insert the following key in the [DS] section PackInterval= where represents how often (in seconds) you want maintenance performed on the software metering tables. STATUS ====== Microsoft has confirmed that this is a problem in Systems Management Server 2.0. MORE INFORMATION ================ Increasing the frequency of software metering table maintenance may have adverse effects on system performance. Use this workaround with extreme caution. Additional query words: prodsms ====================================================================== Keywords : kbsms200 kbsms200bug Technology : kbSMSSearch kbSMS200 Version : winnt:2.0 Issue type : kbbug Solution Type : kbnofix ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2002.