How to run a SQL query using command prompt without SQL SSMS
Open CMD from Run and run the below command (CMD) to connect with Database engine.
1 2 3 |
sqlcmd -S WIN-81L2H4SUHDH\MSSQLSERVER,14331 **WIN-81L2H4SUHDH\MSSQLSERVER --> This should be FQDN** |
Then you can run type your SQL query. Once you are done with all your statement then put an enter. Then type Go and put enter. Shown in the below screen shot.
DMV ‘sys.dm_exec_requests’ provides details on all of the processes running in SQL Server.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT qs.Session_ID, Blocking_Session_ID, qs.Status, Wait_Type, Wait_Time, Wait_Resource, SUBSTRING(st.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) AS statement_text, GetDate() SnapshotDateTime, --Open_Transaction_Count, ss.PROGRAM_NAME, ss.HOST_NAME, ss.Login_Name FROM sys.dm_exec_requests AS qs INNER JOIN sys.dm_exec_sessions ss ON qs.session_id = ss.session_id CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st WHERE Wait_Time > 0 ORDER BY Wait_Time DESC |
“Please let us know if there…