Logging all SQL executed in time period

Question

In MS SQL Server 2008, I would like to investigate and tune the queries that are being executed by an application in a limited time interval. Can I, e.g. from SQL Server Management Studio, generate a log of all SQL being executed and how long time each query took (and which parameters they were executed with)?

score 3 · Accepted Answer · answered Apr 05 '11 at 11:13

3

You can use Profiler for this purpose - from SSMS, go to Tools -> SQL Server Profiler.

answered Apr 05 '11 at 11:13

Blorgbeard

101,031
48
228
272

score 2 · Answer 2 · answered Apr 05 '11 at 11:14

2

You need to use the MS SQL Profiler to do this

http://msdn.microsoft.com/en-us/library/ms181091.aspx

answered Apr 05 '11 at 11:14

codingbadger

42,678
13
95
110

Logging all SQL executed in time period

2 Answers2