How to isolate the current running commands in SQL Server?

Question

I am currently working on SQL Server 2014 and want to know that how can I examine the currently executing statement for each of the requests issued against my SQL Server instance?

Dai · Accepted Answer · 2015-09-17 04:40:48Z

1

SQL Server Profiler is a tool in SQL Server that lets you see what commands are processed by the server and other details. It shows all commands from all clients but you can filter them by a number of fields, including the "Application Name" field, but you need to specify it in your SQL Server client connection string.

e.g. Application Name=MyAppName;

answered Sep 17, 2015 at 4:40

Dai

157k31 gold badges314 silver badges435 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Feltman · Accepted Answer · 2015-09-17 04:42:47Z

0

As Dai said, you'll need to use SQL Server Profiler for this. Step by step instructions are available at this link: https://msdn.microsoft.com/en-us/library/ms175047(v=sql.120).aspx

answered Sep 17, 2015 at 4:42

Mike Feltman

5,1761 gold badge19 silver badges39 bronze badges

Collectives™ on Stack Overflow

How to isolate the current running commands in SQL Server?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related