February 26, 2007 at 8:24 am
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.
The ObjectNames in question are :
sort_init
Flush IDES
Ghost
Any guidance on where I could get information on these would be greatly appreciated
Ian
February 26, 2007 at 3:50 pm
I'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.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 27, 2007 at 4:00 am
I'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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply