| execute to parse % - 50% [message #579388] |
Tue, 12 March 2013 01:26  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear All,
Here, i am little bit confuse about the percentage of the term "execute to parse %". If it's percentage would be "-ve" means, SQL statement parsing lot but executing less. May be user running reports. Here, value is 50%, what should I suggest to client? Do i tell them that performance of database is fine?
Waiting for your reply...
Regards,
Ishika
|
|
|
|
|
|
|
|
| Re: execute to parse % - 50% [message #579423 is a reply to message #579388] |
Tue, 12 March 2013 03:01  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I would handle this differently. You ask this:Quote:what should I suggest to client? Do i tell them that performance of database is fine? which is not the correct approach. No client has ever telephoned the help desk to complain that "the execute to parse ratio is bad". They complain about things like "this report is too slow" or "this screen doesn't refresh fast enough". Focus on identifying the problem, in business terms, first. Only then can you look at possible reasons.
|
|
|
|
| Re: execute to parse % - 50% [message #579468 is a reply to message #579423] |
Tue, 12 March 2013 06:59 |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear John,
The database size is small. As of now, there are no performance issue. I have give feedback on this, to client. That's why i want to about it.
Regards,
Ishika
|
|
|
|
|
|
| Re: execute to parse % - 50% [message #579477 is a reply to message #579470] |
Tue, 12 March 2013 07:53 |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear Michel,
Thanks a lot to u all guys. I had gone through the links but unable to get proper answer of it. At last, i post it here to get proper answer from u all gurus but my question is wrong or way of asking is wrong so, kindly remove this post from this site.
Regards,
Ishika
|
|
|
|
|
|
| Re: execute to parse % - 50% [message #579561 is a reply to message #579488] |
Wed, 13 March 2013 05:31 |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear Michel,
I read your mentioned link and come to conclusion that even if execute to parse% is 2, database performance is good. Percentage below 0 is the problem. Am I correct here?
Regards,
Ishika
|
|
|
|
|
|
| Re: execute to parse % - 50% [message #579570 is a reply to message #579561] |
Wed, 13 March 2013 05:43 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Ishika, I'll try again: you have missed the point!
Database performance is not GOOD or BAD according to some ratio. It is GOOD if your users find it acceptable, it is BAD if they do not find it acceptable. You said earlier that, to quote you, "As of now, there are no performance issue". Therefore, performance is GOOD. That is the only report you can give your client.
Do you understand what I'm saying? If not, you could Google "compulsive tuning disorder" which is a supposedly amusing term to describe pointless tuning activity.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
