April 21, 2006 at 3:58 am
I'm looking at a long running tran and i get for tempdb
Transaction information for database 'tempdb'.
Oldest active transaction:
SPID (server process ID) : 59
UID (user ID) : -1
Name : sort_init
LSN : (60:376:272)
Start time : Apr 21 2006 8:24:38:673AM
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
sort_init = ???? does this indicate a sort within tempdb - I have high cpu but no disk i/o . I'd just like to know what sort_init is .
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 24, 2006 at 8:00 am
This was removed by the editor as SPAM
April 24, 2006 at 12:56 pm
You can look at dbcc inputbuffer (spid) to see what command is running on that spid. That's where I would start.
Tom
April 24, 2006 at 3:35 pm
I know what code is running, I was interested in what was happening in tempdb with regard to workfiles and such - it's just I couldn't find any refs to sort_init.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 9, 2009 at 1:21 pm
Don't you hate it when you are trying to find the answer to something like "What does Sort_Init" mean and someone tells you that you can run DBCC CheckDb to see if there are consistency errors :):hehe:
I am also trying to understand what "Sort_Init" means. Additionally I would like to know what "Cache_Coherency" means in the SQL Profiler ObjectName column. I frequently see SQL Transaction Begin Cache_Coherency followed immediately by SQL Transaction Rollback Cache_Coherency.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply