The Quest Diagnostic Server service might crash with an Out of Memory error if the Upload data to Project Lucy option is selected and you are monitoring an environment that includes a large number of instances, databases or files. This crash will usually occur after 2:15 AM and the symptoms are that the Spotlight client gets the error "Could not convert variant of type (Null) into type (OleStr)".
This hotfix may receive additional testing. If you are not severely affected by the issue this hotfix addresses, it is recommended that you wait for the next release of Spotlight on SQL Server Enterprise as it will include this hotfix.
For complete product information, please refer to the Spotlight on SQL Server Enterprise 9.0.1 product documentation, including the Quick Start Guide, User Guide and the online Help.
The new capacity planning collections for Project Lucy have a data retention mode of 'Never put any columns in memory' so that the data collected is not kept in memory. However the code that handles the output of the Lucy collections doesn't accept this setting and so the data is saved into memory. This wouldn't be a problem except the data swapping mechanism doesn't swap numeric columns to disk and hence they stay in memory. For large customer environments this can mean a lot of data.
Upgrade to 9.5.2
Product Name | Product Version | Defect ID | Problem Description |
<Spotlight on SQL Server Enterprise> | <9.0.1> | <PT41692749> | The Quest Diagnostic Server service might crash with an Out of Memory error if the Upload data to Project Lucy option is selected and you are monitoring an environment that includes a large number of instances, databases or files. This crash will usually occur after 2:15 AM and the symptoms are that the Spotlight client gets the error "Could not convert variant of type (Null) into type (OleStr)". |
