sp_who3 filters everything out unlike sp_who2.

I also use sp_whoisactive depending upon what I'm trying to accomplish.

How many active connections do you have? EXEC sp_who3 to get that and it will tell you how much CPU is being consumed for each SPID.

I had this happen to...

You should be able to filer on the column last_execution_time in the sys.dm_exec_query_stats Table.

I look at taskmgr.

Click on processes click on the CPU Column to sort by CPU time.

Then...

Thanks.

I'm almost certain that the recovery status is available in the Application Event Viewer as well.

When a Database is in recovery I seem to recall that you check the progress in the Event Viewer Application Log?

I had 5 SPIDS that run SSIS Packages.

Each process was stuck on the Step that executes an OPENQUERY that does a SELECT COUNT(*) to get the record counts in AS400...

It works.:blush:

Will the following Statements capture Updates?

At the begining of the Merge I have:

DECLARE @TrackCounts TABLE ([ACTION] VARCHAR(20), INSERTEDID INT, DELETEDID INT);

At the end of the Mege I have this statement:

...

I got to the OLE DB Source and got an error on the paramater mapping.

[stg_Rec_Act [1]] Error: The SQL command requires a parameter named ""00001"", which is not found in...

I found an article and it is basically the same way I did it in DTS although I'm not using a Stored Procedure in this case.

http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx

What task should I use...

Thanks Gail.

If someone has the sole connection I would not be able to kill their session?

Worst case scenario would resrting the SQL Server Service start?

Cool thank you Gail.

No I did not read that one, thanks.

You can bypass this part by imiting the Controller Name.

I clicked on help and this is what I got.

Distributed Replay Client Configuration

Send Feedback...

Yeah, that worked.

I googled it a lot but unfortunately I did not find that article or anything similar to it.

Thanks.

Lowell's suggestion is a good one and that is what I currently do because I do not have a 3rd party tool to do so due to the expense.