Performance Issues on SQL Data Source

Performance Issues on SQL Data Source

avatar

Hello,

I have an MS SQL data source with 2500 entries.

The performance is quite poor - opening the properties window for an entry takes 8+ seconds to load.

Closing the properties window takes another 5+ seconds.

Version: 14.0.6.0 64-bit
- using AD integration, ecrypted datasource and 2FA


Any advice for improving performance?

All Comments (2)

avatar

Hello,

I will start by suggesting to perform a cleanup of the database
https://blog.devolutions.net/2015/09/clean-up-time

If this is not helping, I would need to see a screenshot of your Help -> Diagnostic -> Data Source tab report.

On a side note, RDM 2019 is now available on our website and this may help as well. Are you planning to upgrade to this version in a near future?

Best regards,

Jeff Dagenais

avatar

Thank you - I'll try the database cleanup.