About the ClearTrace category

ClearTrace
1

This category is for discussion of the ClearTrace application.

2

@graz,

It would be awesome if there the ClearTrace app was able to normalize the SQL Statement inside of sp_executesql.

For example, below is an example of normalized text in the current version. I would love that first NSTR to be normalized to get the unique statement executed.

EXEC SP_EXECUTESQL {NSTR}, {NSTR}, @ROWID={##}

I think the following two different statements would return the same normalized text even though they are two different statements hitting different tables.
exec sp_executesql N'select * from table1 where ID = @rowid', '@rowId int', @rowId = 1
exec sp_executesql N'select * from tableab where ID = @rowid', '@rowId int', @rowId = 1

Ideally, would want a normalized text for these to be something like the following.

SELECT * FROM TABLE1 WHERE ID =@ROWID
SELECT * FROM TABLEAB WHERE ID = @ROWID

Let me know if this doesn't make sense.
Regards,
@John.Sterrett

3

Hmmm. It's supposed to handle that pattern. I'll try to take a look and see what it's doing.