• cunningham (7/30/2014)


    I made a slight mistake, the query is no sp_executesql, it is sys.sp_execute. Is this the same thing?

    That's for executing prepared statements. Different than sp_executesql because the prepared statements are prepared in the app code then passed to SQL Server where they're treated similarly to stored procedures.

    I don't know Solarwinds Ignite well enough to tell you how it works, but I think it should be able to differentiate between different prepared statements. I suspect you have some type of aggregate set. You might post this question on their support forums.

    "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