How can we help you today? How can we help you today?

Best Way to Report Performance Issues

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".
ZianChoy
0

Comments

2 comments

Sort by
  • 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.
    Aaron L
    0
  • ZianChoy
    I'm talking about the "suggestions in the query window".

    Thanks for the advice.
    ZianChoy
    0

Add comment

Please sign in to leave a comment.