Return
-
Title
Sybase TopSQL view displaying very slow -
Description
When we click the "TopSQL" tab, on the Sybase database dashboard, it may take one or more minutes to show the SQL Text. -
Cause
Renderer is not set to empty
-
Resolution
Please follow the below steps which should resolve the "TopSQL" tab performance issue.
1. Navigate to Configuration | Definitions | select SybaseMDA
2. Select the MDATopSQLStatisticsTable view, Click Edit button.
3. Navigate to Configuration | Columns | column (sql). Go to Stack Mode Configuration |Value |Edit /sql
4. In the Edit - Value dialog box, empty the Renderer by searching for 'none' and Save.
5. Save the MDATopSQLStatisticsTable Definition view
6. Verify Sybase Top SQL View if run faster now.
See screenshots
