Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Goals and Symptoms
System Manager Software (SMS) version 4.x Setup Utility for a SMSDL v4.0.3 system with MSDE SP3 and all 10 devices in communications took over 20 minutes to open.
Causes and Fixes
Cause: SQLAgent handle count was over 95,000. After restarting SQL services the handle count dropped to less than 200 and the Setup Utility opened up immediately.
Fix: Apply SQL 2000 MSDE SP4.
(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/0c3dad340fc66b4bc1257436001096e5/fl_block_5/0.1AD6?OpenElement&FieldElemFormat=gif)