When profiling a procedure I don't seem to be able to copy the line by line stats. You can get the procedure text but not the numbers. I wonder if they can be extracted from a system table?

(seem to have lost my OpenID!!)

asked 12 Mar '10, 17:21

Justin%20Willey%201's gravatar image

Justin Willey 1
accept rate: 0%

Let me know if you want your old user id merged into your new one, carrying over points etcetera.

(12 Mar '10, 20:03) Breck Carter

Hi Breck - IF ITS EASY - could you merge the new account into my old one - I think I've now got a local password and don't have to authenticate using the ghastly Open_ID nonsense. Thanks Justin

(16 Mar '10, 18:06) Justin Willey

I'd like to offer a bounty on this - but I don't see the button. Its over 2 days old, but maybe 6 days is too old??

(18 Mar '10, 20:23) Justin Willey
Comment Text Removed

I've seen why I can't offer a bounty - I don't have enough reputation on this user account. Breck - could you go ahead and merge the accounts please? Many thanks

(30 Mar '10, 19:07) Justin Willey

In the help, under the index "procedure profiling" you'll find a reference to the sa_procedure_profile() system procedure, which does what you want - I think :-)

permanent link

answered 13 Mar '10, 14:50

Glenn%20Paulley's gravatar image

Glenn Paulley
accept rate: 43%

Thanks Glen, that gives the performance by line number, but I think I then have to manually match up line numbers to the code. Unless I'm missing something there isn't anything that either gives me them together, or lets me retrieve from a system table what SQLA reckons is on each line of the procedure. Any pointers would be a help - it becomes an issue when trying to discuss a profiling result with somebody.

(16 Mar '10, 17:17) Justin Willey
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 12 Mar '10, 17:21

question was seen: 632 times

last updated: 13 Mar '10, 14:50