• You don't ever want to use Profiler gui against a production server. Use a server-side trace and trace to a fast local drive instead.

    http://scarydba.wordpress.com/2008/12/18/profiler-research/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass