SQL Spark

select max(local_tcp_port) from sys.dm_exec_connections where net_transport ='TCP' USE master GO xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc'  GO

SELECT er.session_id, er.status, er.command, db_name(er.database_id) [Database], st.text  FROM sys.dm_exec_requests er  CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) st  WHERE er.session_id > 50 and session_id <> @@SPID    SELECT        r.cpu_time CPUTIME_Miliseconds,        r.cpu_time * 0.001 CPUTIME_Seconds,        r.total_elapsed_time * 0.001 TotalElapsedTime_Seconds,        r.session_id        ,st.TEXT AS batch_text        ,SUBSTRING(st.TEXT, statement_start_offset / 2 + 1, (                      (                            CASE                                    WHEN r.statement_end_offset = - 1       ...