Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Understanding Profiler ObjectNames Expand / Collapse
Author
Message
Posted Monday, February 26, 2007 8:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, February 26, 2007 3:50 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
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
Posted Tuesday, February 27, 2007 4:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse