you could also try to fetch SQLPlan data out of your sql engine, or post the estimated execution plan.
Using SqlServer Management Studio, you could highlight the actual code withing the sproc and then, using the menu, go for Query \ display estimated execution plan.
It will produce a graphical execution plan. Right click on it and you'll be able to save it to a file and attach it to your reply.
or you could use my powershell script to extract the sqlplan from the current cache and capture some execution statistics with it.
You can find the PoSh script at http://poshcode.org/3730
Just add an extra filter to the query
and p.name = ''yoursprocname''
( double single quotes !! )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me