February 26, 2009 at 10:36 am
Can we use column filter to monitor more than one stored procedure, i need to monitor 9 stored procedures...
Its urgent, any suggestion is highly appreciated..
--Sudhie
February 26, 2009 at 10:59 am
Are you talking about monitoring the performances using SQL Trace? If so yes, You can give the filter as TextData with Like and you can keep adding as many as you want there.
-Roy
February 26, 2009 at 11:12 am
Thanks Roy, that certainly helped. I just saw another option in PSSDIAG, it is allowing me to enter 5 trace filters on an event. I am planning to enter Object ID's of all 5 stored procedures. I am planning another PSSDIAG instance run for another 4 stored procedures. Does this plan sound good?
February 26, 2009 at 11:20 am
i was able to inject more filters into PSSDIAG and i entered all Object ID's, Duration and database ID as well...
will test it and let you know if it works fine
February 26, 2009 at 11:40 am
Cool, Keep us posted if it worked.
-Roy
February 26, 2009 at 4:03 pm
PSSDIAG is taking many filters, but when i checked its XML, it is taking only 5 filters. I filtered for a while using text data and then started tracing without filters(Of course i added database and Duration). But PSSDIAG is so good that it allows maximum of 4 stored procs to be monitored taking very less CPU.
Thnks again Roy.
--Sudhie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply