Procedure Cache and Query Plan
1ASE maintains MRU/LRU (most recently used/least recently used) algorithm. Stored procedures generally preferred over separate SQL statements because when users execute stored procedure, Adaptive server search procedure cache for existing query plan. If it is available then execution begins.
If Query plan is not available or all copies are in use, if multiple users are executing same stored procedure at a time then multiple copies of query plan will be available in procedure cache until size of cache is supporting, then query tree for the procedure is read from the sysprocedures table . Then query tree is then optimized, based on the parameters passed to the procedures and converted into query plan and then execution begins.
DBA Sidekick(Sybase) Andriod App on Google Play
0Description
Key Features:
1. Search Sybase Error Code and Adaptive Server Anywhere SQLCODEs to find error description
2. Partial search available
3. Negative error code need not be supplied for Adaptive Server Anywhere SQLCODEs
Sybase ASE Brainstorming Question Series
0We are preparing the Sybase ASE Brainstorming Question Series.
In this series we will put the questions topic wise as well as hands on (day-to-day troubleshooting) questions.
For all questions, We will also include the answers as well 
Please forward your advices/suggestions on Link .
We are waiting to hear from your side.
Thanks.
Team,sybaseblog.com
Database device and segment
0Adaptive Server keeps track of the various pieces of each database in master.dbo.sysusages. Each entry in sysusages describes one fragment of a database. Fragments are a contiguous group of logical pages, all on the same
device, that permit storage for the same group of segments. Fragments are also known as “disk pieces.”
Source: Sybooks.sybase.com
we are also changed..
0As SAP disclosed its database plans on Apr 10 2012 press conf and If you go through the Sybase point of view for Sybase Technologies with SAP Real Time Data Platform, Its certainly a great move in technology front for ASE,IQ,Rep Server & ASA.
SAP HANA is superb innovation from SAP and it’s integration with Sybase Data Management Products will put these product miles ahead with others.
Definitely It is very good news for Sybase folks!
Now we are also changed our tag-line for showing our support with this vision of SAP Sybase..& keep your blog in sync with same.
to
Recent Comments