Long-running queries are always trouble for many of us. During my Comprehensive Database Performance Health Check, the very last step is to help with long-running queries. Often we run the long-running queries and start doing other tasks. When the queries end, we know how long the query ran from the duration of the query but we never know their completion time.
I have recently discovered that SQL Server Management Studio 18.2 now provides Completion Time in the messages field and that helps us to identify when was actually query completed. Here is the screenshot of the message field where it displays the time of your local machine where it completed.
Here is the link from where you can download of SQL Server Management Studio. Please note that you can also connect the earlier version of SQL Server with the SSMS 18. You can also install SSMS 18.x along with earlier version of SSMS as well. I generally install both the versions of SSMS and use them side by side.
Here are a few additional blog posts related to SQL Server Management Studio.
SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard
The latest release of SQL Server Management Studio (SSMS), requires a mention about it. The latest version contains a Performance Dashboard by default.
Install SQL Server Management Studio – SQL in Sixty Seconds #080
In the earlier version of SQL Server, while installing SQL Server Engine, SQL Server Management Studio (SSMS) was automatically installed along with the SQL Server Engine. Actually, the installation of SSMS was one of the features and was installed from the original media. This was very convenient most of the time when the user was installing SQL Server Engine for the first time and had media available along with him.
Database Diagram – Available Again in SQL Server Management Studio 18.1 Onwards
The good news is here when Microsoft has released new SQL Server Management Studio (SSMS) V 18.1, which now have Database Diagrams and a few other enhancements.
Reference: Pinal Dave (https://blog.sqlauthority.com)
5 Comments. Leave new
Do you know if I can prevent this message?
That is a great question and I have looked around everywhere and I did not see any option to turn this one off.
There is a new option to turn those off in the SSMS Settings:
Tools > Options > Query Execution > SQL Server > Advanced.
Uncheck the Show Completion Time checkbox.
https://dba.stackexchange.com/questions/245148/how-to-disable-completion-time-in-sql-server-messages-window
Is there a way to disable showing of completion time through a TSQL command?
Is it possible to disable the showing of the Completion time using a TSQL statement in the executing script?