Thank you! That did the trick for me as well. We're restoring our Q environment from Dev and SQL was reinstalled to a different directory.

Thanks Gail, will do.

Hi Gail,

Thanks for the suggestion. Here you go:

Oldest active transaction:

SPID (server process ID): 507

UID (user ID) : -1

...

John,

Thank you for the sp_who suggestion and all the other troubleshooting help, very much appreciated. Sp_who showed the 'default' sql login used by SAP (and which is used by...

John,

Here are the results of DBCC INPUTBUFFER.

Thanks,

Karen

**Blocking spid 507**

dbcc inputbuffer(507)

EventTypeParametersEventInfo

Language Event0select db_name()

**Suspended spid 149 **

dbcc inputbuffer(149)

EventTypeParametersEventInfo

Language Event0(@P1 nvarchar(1),@P2 nvarchar(12),@P3 nvarchar(8),@P4 nvarchar(6),@P5 nvarchar(8),@P6 nvarchar(6),@P7 nvarchar(12),@P8 nvarchar(12),@P9 nvarchar(40),@P10 nvarchar(45),@P11 nvarchar(3),@P12...

John,

Thanks for hanging in there with me. I didn't even notice the 2014. My mistake, I am sure.

Here's how the date looks from SQL, if I just copy...

Hope this won't look too garbled. sp_who2 shows a bunch of processes from 10/18. Checking the sql error log, I see that was after a server restart on...

I tried a script from PinalDave - Look at this! Here are the top ten queries:

MaxElapsedTimeAvgElapsedTimeLogCreatedOn

358497204826520494/8/2014

2855344316823810/18/2013

2853692221863110/18/2013

23460331852110/18/2013

23437700562687010/18/2013

204691007614910/18/2013

17853331153638082/26/2014

14070434783025910/18/2013

8880477932390210/18/2013

646335968180863/15/2014

SELECT DISTINCT TOP 10

t.TEXT QueryName,

s.execution_count AS ExecutionCount,

s.max_elapsed_time AS MaxElapsedTime,

ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0),...

This is our SAP ECC production database. No jobs are currently active but we have a very complex installation with links to multiple other systems.

I'm wondering whether...

John -

ACTIVE_TRANSACTION

Thanks,

Karen