The Help You Need When You Need It

 

Xtivia’s Sybase Adaptive Server Enterprise (ASE) Services

Xtivia provides a wide range of DBA services for Sybase Adaptive Server Enterprise (ASE) for Linux, UNIX, and Windows environments. We offer services through our Professional Services group and under the Virtual-DBA service. The following list of services is not exhaustive.

SYBASE Adaptive Server Enterprise (ASE) Building and Installation

Many of the world’s largest financial institutions depend on Sybase ASE because it is one of the most reliable and cost-effective data management platforms for business-critical applications with extreme transaction levels. The latest version, ASE 15, builds on that reputation with key enhancements that scale performance, minimize corporate risk and reduce IT operational costs. Why not take advantage of a data server that can solve your data growth issues?  Xtivia Sybase DBA engineers will come on site and work with you to plan, install, configure and customize ASE for your specific business needs.

SYBASE Adaptive Server Enterprise (ASE) Migrate and Upgrade

Do you need to upgrade your data server to a newer version?  Do you want to take advantage of new features that address your business needs and problems?  If you are considering launching a data server upgrade initiative or want to ensure the success of a current upgrade initiative, call us. Our Sybase DBA upgrade team services  can handle all aspects of your SYBASE ASE upgrade on AIX, HP-UX, Solaris, Linux or Microsoft Windows dealing with ASE versions of the following: 

  • Sybase SQL Server 11.0
  • Adaptive Server Enterprise 11.5
  • Adaptive Server Enterprise 11.9.2
  • Adaptive Server Enterprise 12.0
  • Adaptive Server Enterprise 12.5
  • Adaptive Server Enterprise 12.5.1
  • Adaptive Server Enterprise 12.5.2
  • Adaptive Server Enterprise 12.5.3
  • Adaptive Server Enterprise 12.5.4
  • Adaptive Server Enterprise 15.0
  • Adaptive Server Enterprise 15.0.2
  • Adaptive Server Enterprise 15.0.3

Request Info iconRequest More Information

SYBASE Adaptive Server Enterprise (ASE) Performance Tuning

Poor SQL statement performance and high CPU usage on your SYBASE ASE server almost always indicates the need for performance tuning. We can analyze your pain points and make recommendations on your SYBASE ASE configuration, memory settings and storage architecture. We will also analyze poor performing SQL statements that may benefit from the correct index, partitioning and de-fragmentation. We can perform this analysis on specific targets or as part of a Health Check for SYBASE ASE.

SYBASE Adaptive Server Enterprise (ASE) Memory Usage

Allocating memory on your SYBASE ASE server requires in-depth analysis and business decisions. We can recommend how to divide your available memory into the places SYBASE ASE needs it the most. Our analysis will include, but not be limited to  the default data cache, named cache, procedure cache, statement cache, bufferpools, cache partitions, cache for temp db or heavily used objects.

SYBASE Adaptive Server Enterprise (ASE) Server and Engine Configuration

Is your server configured to support optimal performance? Have you considered using multiple tempdb or parallel processing? How many engines are available and is the current number of online engines producing the best result? Our assessment will identify possible areas of improvement in your server configuration such as memory, engine, network and other configuration options to make your server run in optimal performance.

Request Info iconRequest More Information

SYBASE Adaptive Server Enterprise (ASE) Migrate from 32-bit to 64-bit

Are you ready to get out from under the 32-bit memory limits for SYBASE ASE? If you are planning a version upgrade or just want to take advantage of your 64-bit AIX, HP-UX, Solaris, Linux or Microsoft Windows operating system, we can help you upgrade your SYBASE ASE instance to take advantage 64-bit architecture available on Linux, UNIX and Windows.

SYBASE Adaptive Server Enterprise (ASE) EBFs

EBFs for SYBASE ASE include important changes to existing features and additional features that you should take advantage of. We can install the latest EBF for your version of SYBASE ASE and help you take advantage of any new features and fixes that may be available.

SYBASE Adaptive Server Enterprise (ASE) Health Check

Ever wonder if you are getting the most out of your SYBASE ASE running on AIX, HP-UX, Solaris, Linux or Microsoft Windows? Our SYBASE ASE Health Check service will provide you with exactly what you need. We’ll conduct a comprehensive analysis of your environment, database workload and database configuration and prepare an easy-to-read, management-level report with the current state of your system and any recommendations to improve its performance and availability.

Request Info iconRequest More Information

SYBASE Adaptive Server Enterprise (ASE) Troubleshooting Errors

Users may encounter errors when using Sybase Adaptive Server Enterprise. Our Sybase DBA engineers will help you to determine if it is server critical or informational. We’ll find the of the problem and fix the error.

SYBASE Adaptive Server Enterprise (ASE) Security and User Access

Sybase ASE has many layers of security. You can grant who has the privilege on the server. System Administrator (SA or sa_role), for example, has unlimited power on the server. There are other roles such as System Security Office (SSO) and Operator who have privileges to serve their own purpose. Users are assigned to the database as either public user or member of group with privilege on the objects. Users can also be aliased as Database Owner (DBO). By the principle of least privilege, a user should only have access to the resources required to his or her job. Let us help you sort through this issue and make recommendations. Security is a big concern. We’ll help you reduce full authorization and set up a reasonable access control for the secure usage of your system.

SYBASE Adaptive Server Enterprise (ASE) Auditing

Have you ever thought of utilizing Sybase ASE auditing to detect penetration of the system and misuse of the resources? Xtivia Sybase DBA engineers can install the audit system, configure auditing options, set up audit trails and threshold procedures and process the audit data.

SYBASE Replication

Have you ever wondered how the replication components such as rep agent, DSI thread, RSI and RSSD interacts with each other and how to configure them for best performance? Xtivia’s Certified Sybase DBA engineers have vast experience managing Sybase Replication server from 11 to 15 and handling various types of Sybase Replication Server such as normal replication definition / subscription, Warm standby/MSA and heterogeneous replication system replicating from ASE to Oracle and MS SQL Server. We can help you gather requirements, plan, implement and manage your replication solution.

Request Info iconRequest More Information