Viewing 15 posts - 1 through 15 (of 186 total)
aye its a cracking feature of SQL haha
yeah of course thanks to Jeff and Cebisa too 🙂
October 23, 2020 at 1:03 pm
Thanks for all of your assistance,
I have just arranged for the SQL Server to be rebooted,
Due to some systems we have i cannot restart the services without other servers...
October 23, 2020 at 9:07 am
no worries Brian it has been good to get somebody else looking at with me,
yeah the kill with status only returns "SPID 205: transaction rollback in progress. Estimated rollback completion:...
October 22, 2020 at 9:58 pm
thanks again Brian for your continued assistance,
there is currently nothing processing on the linked server that i can see as being called from this server,
what i think is strange is...
October 22, 2020 at 9:28 pm
I am seeing that as the CMD column in sys.sysprocesses for the SPID,
Also in sp_Who2
October 22, 2020 at 8:50 pm
Thanks for your response,
No the job itself was just running a stored proc which called some other procs, some of which being on linked servers,
It didnt seem to even...
October 22, 2020 at 8:30 pm
I ran the query but it didn't return anything,
When i ommited the status = 'Rollback' line i can see that the session_id/SPID shows the bellow
October 22, 2020 at 8:05 pm
when running DBCC OPENTRAN(TEMPDB) i get the below, the spid it relates to is the one i killed
Transaction information for database 'tempdb'.
Oldest active transaction:
SPID (server process ID): 205
UID (user ID)...
October 22, 2020 at 6:58 pm
restarting the server agent service has not had the desired effect,
the sql job has now stopped but the SPID remains in a KILLED/ROLLBACK state and the tempdb log file continues...
October 22, 2020 at 6:16 pm
also, just to confirm, it is the TempDB log file that is growing not the data file,
not sure if that makes any difference?
October 22, 2020 at 9:41 am
i may be going at this from the wrong angle but the only issues that are being presented are a job stuck "Executing: 0(Unknown)" and a constantly growing TempDB, no...
October 22, 2020 at 9:12 am
Thanks for your reply,
Unfortunately i don't have a secondary to fail over to,
Yeah i am leaning towards a restart of the Server Agent Services but whilst it isn't, yet,...
October 22, 2020 at 8:35 am
..also, the CPU and MemUsage in sysProcesses hasn't changed for quite some time with the LastWaitType being PREEMPTIVE_OS_AUTHORIZATIONOPS
October 22, 2020 at 7:38 am
September 21, 2020 at 1:13 pm
confidently answer question
get it wrong
notice the "-"
drink more coffee....
April 28, 2020 at 9:52 am