The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.



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]( "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: 629 times

last updated: 13 Mar '10, 14:50