Best Way to Report Performance Issues

ZianChoy

What is the best way to report recurring cases of SQL Prompt being slow to populate the drop-down menu across all sorts of different databases?

Also, how long should it reasonably take to populate the list for a SQL Server 2014 database with <10 tables?

I know that user interaction guidelines generally say "0.1 seconds for feeling instant, 1 second for needing some feedback, and 10+ seconds = noticeably slow".

Aaron L

Hi ZianChoy,

Just to make sure we're talking about the same thing, when you say the "drop-down menu" do you mean the suggestions in the query window or the right click menu on the object explorer?

For a database with less than 10 tables the processing that SQL Prompt does for the suggestions list should be instant. Where a slow down might occur is if the database is hosted on a server with a high latency, resulting in the initial queries that retrieve the suggestions taking a while to run.

Logging a support ticket might be best if the issue needs some more investigation: https://redgatesupport.zendesk.com/hc/e ... quests/new
Please include as much detail as possible.

Thanks,
Aaron.

ZianChoy

I'm talking about the "suggestions in the query window".

Thanks for the advice.