vendredi 8 juillet 2016

Parameter sniffing troubleshooting

need a bit of help in accomplishing something in tsql. I am collecting sql profiler trace data to get a particular stored procedure execution and basically I am trying to strip out the parameter values from the textdata column Example for the below set of data, i need to stripe out parameter value out

exec test
exec test @aa=10
exec test @aa=10,@bb=10
exec test @aa=10,@bb=10,@cc=100
exec test @aa=10,@bb=1000,@cc=1

so the output table might look like

aa   bb     cc
10   Null  NUll
10    10   NULL
10    10   100
10   1000   1

I am just trying to find out what are the common parameters that are being passed to the sp, so if there is other easy ways of doing it please let me know.

Aucun commentaire:

Enregistrer un commentaire