Slow SQL performance and disconnects and high utilization in AIQUM
Applies to
- ONTAP 9
- Microsoft SQL
- Active IQ Unified Manager (AIQUM), formerly called OnCommand Unified Manager (OCUM)
Issue
- Very poor application performance
- Reports of application disconnects to SQL databases - 30-40 times
- Connectivity issue with database that again caused multiple(30-40) major ETL job failures in Production
- High utilization seen in AIQUM on the node page