• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 58 subscribers
  • Views 323 views
  • Users 0 members are here
Options
Related

Capturing Query Parameters

Unknown
Unknown

We are running a trial of Foglight to monitor SQL Server. In the SQL PI is it possible to have query parameters captured?

So rather than seeing something like 

SELECT * from table where column = @value

We are looking to see what the actual value of the @value parameter is. 

This is a feature is a our current monitoring solution and in others we are testing, wondering if this exist in Foglight also?

Thanks
Chris

Parents
  • 0

    Hi Chris,

    Seeing the actual value isn't possible in SQL PI for SQL Server monitoring. Foglight's SQL Server agent collects the data for query hash which removes the patameters. The advantage is that all invocations of the statement are aggregated together so it is clear to see they are related. (i.e. see the forest rather than the trees).

    Users can correlate to session dimensions and compare between them to check if there is significant differences, however this will not include the parameters either.

    As well, in some cases, if the plans of different invocations are different they are captured and can be compared.

    John

Reply
  • 0

    Hi Chris,

    Seeing the actual value isn't possible in SQL PI for SQL Server monitoring. Foglight's SQL Server agent collects the data for query hash which removes the patameters. The advantage is that all invocations of the statement are aggregated together so it is clear to see they are related. (i.e. see the forest rather than the trees).

    Users can correlate to session dimensions and compare between them to check if there is significant differences, however this will not include the parameters either.

    As well, in some cases, if the plans of different invocations are different they are captured and can be compared.

    John

Children
No Data