ShaikBlog

  Current Sybase Environment Q: Which version of Sybase ASE are we using? Are there multiple instances/environments? A: We’re currently on Sybase ASE 15.7, with separate dev, test, and production instances. Dev and test run on version 15.0 but production is on 15.7. Q: Are there any custom configurations (e.g., page size, tempdb, buffer cache tuning)? A: Yes, the page size is set to 8 KB instead of the default 2 KB for better I/O efficiency. We also tuned the buffer cache to 4 GB due to high concurrent access. Tempdb is isolated on a separate disk for performance. Q: What is the size of each Sybase database, and how fast is it growing? A: The main OLTP database is around 500 GB, growing at approximately 10 GB per month due to heavy transaction volume. The reporting database is 1.2 TB but grows more slowly. Q: Are we using any Sybase-specific features (like partitioning, text/image datatypes, LOBs, proxy tables)? A: Yes, we use partitioned tables on the sales data for pe...

 A list of targeted technical questions you can ask about the Sybase databases, objects, tooling, and challenges . These questions will help you: Understand the current Sybase environment deeply Spot complexities that could affect migration Identify areas where your Sybase expertise will be most valuable 🔍 Current Sybase Environment Which version of Sybase ASE are we using? Are there multiple instances/environments? Are there any custom configurations (e.g., page size, tempdb, buffer cache tuning)? What is the size of each Sybase database, and how fast is it growing? Are we using any Sybase-specific features (like partitioning, text/image datatypes, LOBs, proxy tables)? How is user authentication handled in Sybase (e.g., LDAP integration, roles, login triggers)? 🧱 Database Schema & Code What’s the complexity of the schema—do we have deeply nested views, or circular dependencies? How many stored procedures, triggers, and user-defined func...

  Sybase ASC vs. Sybase Database – What’s the Difference? 1. Sybase Database (General Term) "Sybase database" is a generic term that refers to any database system developed by Sybase, Inc. Over the years, Sybase has created several database products, including: Sybase ASE (Adaptive Server Enterprise) – the most well-known, high-performance relational database. Sybase ASA (Adaptive Server Anywhere) – designed for mobile and embedded systems (later became SQL Anywhere ). Sybase IQ – a column-based database for analytics and reporting. Sybase Replication Server , etc. So, when someone says "Sybase database" , they could be referring to any of these products. 2. Sybase ASC (Adaptive Server Cluster Edition) Sybase ASC is a specific edition of Sybase ASE (Adaptive Server Enterprise) designed to support database clustering . It allows multiple ASE instances to work together as a single clustered database system . Designed for high avail...