Profiler question

• FreeHansje

  SSChampion

  Points: 11751

  More actions

  July 16, 2009 at 7:05 am

  #139825

  Hi there,

  Running profiler to analyze performance issues I encounter a very longrunning query:

  SELECT COUNT(*) FROM tablename

  WHERE C1 = @P1

  AND C2 = @P2

  AND c3 = @P3

  AND c4 LIKE @P4

  Is there any way to display the variables used here in profiler?

  Greetz,
  Hans Brouwer

• Grant Fritchey

  SSC Guru

  Points: 399289

  More actions

  July 16, 2009 at 7:43 am

  #1025643

  They're not visible in the textdata column?

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning