Developers should use this statistics to get more information about what they just did and pay attention to high physical or logical read values.
SQL Server provides commands that are used to return query statistics like SET STATISTICS IO, TIME.
The IO command return information about physical, logical for tables referenced in the query and also worktables, which means tables in tempdb for the duration of the query and are removed automatically when it has finished the operation.
Using statistics time will show the parse, compile time for the query and the actual execution time after the query results. It’s useful to measure the amount of time a query takes to execute from end to end.
With the extension installed, right-click on the instance -> Manage to see the server jobs
But, not everything is working. I tried to edit a job step and didn’t work. For example, the Ola hallengren maintenace scripts after created wasn’t possible to change using the GUI differently than using SSMS.
Even trying to using the GUI to create a new step didn’t work and I changed using TSQL.
The script is available in my Git here to download. After changed the script I succeeded ran it.
With extensions we have more features available to work with SQL Operations Studio and is improving the utilization. Also you can create your own widget. In my tip on MSSQLTips.com I’m showing how to create it.
I recommend install SQL Server Agent, Profiler, Reports and certainly whoisactive
Great news, a visual way to manage SQL Server from Linux.
SQL Operations Studio came to fill a gap we were waiting to develop and manage SQL Server databases on Linux. In the link https://github.com/Microsoft/sqlopsstudio we can see more information like the features below.
Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment
SQL Server Connection Management with Connection Dialog, Server Groups, and Registered Servers
Object Explorer supporting schema browsing and contextual command execution
T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting
Management Dashboard supporting customizable widgets with drill-through actionable insights
Visual Data Editor that enables direct row insertion, update and deletion into tables
Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can be executed or scripted
Task History window to view current task execution status, completion results with error messages and task T-SQL scripting
Scripting support to generate CREATE, SELECT and DROP statements for database objects
Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries
Modern light-weight shell with theming, user settings, full screen support, integrated terminal and numerous other features