Hi,
This is regarding the resource governor.
Resource Governor is mechanism to limit the resources a given process may request or acquire.
Below are the list of limit type available as part of resource governor.
row_count :- Limits the numbe...
Hi Team,
I’ve done some analysis and documented few enhancements \ features mainly from performance improvement for Sybase 16.0 (SP03).
Could you please let me know is there any other enhancements \ features which got implemented in Sybase 16.0 ...
Team,
Could you please share if you have any documentations related to Sybase 16.0 performance tunning ? Or any virtual class reference details for performance tunning session.
Thanks,
Uday
Do you have database related scripts which will help us to identify all database related activities ? For Example :- I am running the stored procedure from ASE ISQL and I want to capture all database related sql statements which are getting called \ ...
1. GROUP BY and DISTINCT both generate the same query execution plan when no aggregates are used.2. GROUP BY becomes important when aggregates are used. DISTINCT is just for filtering out duplicate records from query result sets.Based on my understan...
Hi Avinash,
Could you please confirm whether you are referring to below document ?
https://help.sap.com/doc/5f8c23557c0a4831bb191f0378647d41/16.0.3.3/en-US/SAP_ASE_Whats_New_en.pdf
As per this document, there is no existing command whi...
