SQL Server Performance

Event "Missing Join Predicate"

Discussion in 'Getting Started' started by lcerni, Feb 9, 2010.

  1. lcerni New Member

    In SQL Server Profiler I have selected the event "Missing Join Predicate" to see if we have any issues with queries missing a join. However, it does not show the query itself. How do you go about capturing the query? Do I need to select another event? Do I need to use another tool?
  2. FrankKalis Moderator

    When you only select this event, it's pretty much guess-work and you have to correlate it by time to the queries that were executed right before this event.
    If you also select the SQL:StmtCompleted event it should be easier to find out the offending query.

Share This Page