AI to help detect databases/schemas most often used?
I got a suggestion from SQL Prompt for "Slow cached time detected".The link (seen in the screenshot) was this one:
https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory
So from what I understand, I need to manually go through all databases and schemas and select the ones I think are used to the most in order to only load suggestions for them, in order to improve performance?
While I generally like SQL Prompt, the first word that came to mind was that this pretty much sucked, but let's just say it's less that optimal I think. Given that we’re in the ”AI age”, I was hoping that there would be an AI (or some "smart feature" that would automatically suggest which databases and schemas etc that I use the most, so I that I could just accept?
This is by no means a deal breaker, but just a "nice to have" feature. Just wanted to let you know, and that I other than this like SQL Prompt :)