SQL Developer - The Universal Database Frontend

Microsoft SQL Server Extensions

SQL Developer on SQL Server

Show Plan

MicrosoftSqlServerShowPlanSmall_en

With the Show Plan extension you can analyze the execution plan of a query. Paste the statement to analyze from the clipboard into the SQL editor in the upper part of the dialog. You can also load a statement from a file using the Open function.

Use the Execute button from the tool bar to analyze the statement. The Execution plan will be displayed in a tree in the lower part of the dialog.


Processes

MicrosoftSqlServerProcessesSmall_en

This extension shows all processes running on the database for the currently selected adapter.

Use the Details button to show the last executed SQL command for the selected process. With the Kill process button you can terminate the selected processes. The Refresh button re-reads all information of all processes.

Use the Filter field to select a filter criterion and specify a filter pattern in the like field. The filter works case insensitive and supports the wildcard character %. Press the Enter key or the Refresh button to activate the filter.

You can sort the table according to the values of a column by clicking the column's header with the mouse. Another click on the same column header reverses the order.


Monitor

MicrosoftSqlServerMonitorSmall_en

SQL Developer User ManualJan BorchersThe Monitor extension provides a graphical user interface for the internal SQL Server monitor function. If the auto refresh option is checked, new measured values are recorded repeatedly after the selected period (5 seconds to 10 minutes) has elapsed.

Note: The extension uses the SQL Server function sp_monitor. Members of the server role sysadmin have the permission to execute this function by default.


Remote command shell

MicrosoftSqlServerCommandShellSmall_en

This extension emulates a command shell on the database server. The shell works synchronously. The command control does not return until an executed command has finished. Key input as wanted by some commands is being ignored.

Note: The extension uses the SQL Server function xp_cmdshell. Members of the server role sysadmin have the permission to execute this function by default.