How do I get a copy of procedure profiling statistics?

v10.0.1

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!!)

performance sybase-central

asked 12 Mar '10, 17:21

Justin Willey 1
11●1●1●3
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

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Paulley
10.8k●5●76●106
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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

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

learn more about Markdown

Question tags:

performance ×275
sybase-central ×128

question asked: 12 Mar '10, 17:21

question was seen: 1,315 times

last updated: 13 Mar '10, 14:50

SAP SQL Anywhere

How do I get a copy of procedure profiling statistics?

Follow this question

Related questions