Understanding Profiler ObjectNames

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Understanding Profiler ObjectNames

Understanding Profiler ObjectNames

Rate Topic

Display Mode

Topic Options

Author

Message

Ian-386680

Posted Monday, February 26, 2007 8:24 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, October 19, 2007 7:10 AM
Points: 17, Visits: 6

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

Post #347478

colin.Leversuch-Roberts

Posted Monday, February 26, 2007 3:50 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 PM
Points: 2,668, Visits: 688

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.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Post #347652

Ian-386680

Posted Tuesday, February 27, 2007 4:00 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, October 19, 2007 7:10 AM
Points: 17, Visits: 6

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.

Post #347752

« Prev Topic | Next Topic »

Permissions