InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:10:52 GMT20http://www.sqlservercentral.com/Forums/Topic347478-5-1.aspxI'm sure you're right that it's not feasible to understand everything that's going on in tempdb. It's more curiosity on my part, having seen references to these objects in Profiler and not being able to find any information on them.Tue, 27 Feb 2007 04:00:00 GMTIan-386680http://www.sqlservercentral.com/Forums/Topic347478-5-1.aspxI'm not convinced you can do what you're trying to do in that manner. Tempdb is generally the work space for sql server for sorts, groups bys, spools, distincts and of course temp tables, where possible sql server will attempt to do this in memory but will tend to use tempdb.Mon, 26 Feb 2007 15:50:00 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic347478-5-1.aspx<P>I'm trying to work out what our tempdb is being used for by running sql profiler. I'm picking up a number of entries in the ObjectName field that I don't understand, and that I can't find any reference to on the Web or any reference material.</P><P>The ObjectNames in question are :</P><P>sort_init</P><P>Flush IDES</P><P>Ghost</P><P>Any guidance on where I could get information on these would be greatly appreciated</P><P>Ian</P>Mon, 26 Feb 2007 08:24:00 GMTIan-386680