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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy