Sybase ADDICT

Sybase is back with 3 new technical webcasts about Replication Server 15.5. Sybase webcasts series are very valuable to acquire additional knowledge from Sybase experts. The Replication Server’s webcasts are scheduled from May through June 2010 as follow:

Part 1: Replication Server 15.5 Overview

Tuesday, May 4, 2010
1:00 p.m. – 2:00 p.m. ET
(10:00 a.m. – 11:00 a.m. PT)

Part 2: Real-Time Loading for Sybase IQ

Thursday, May 20, 2010
1:00 pm – 2:00 pm ET
(10:00 am – 11:00 am PT)

Part 3: Replication Server and Performance

Tuesday, June 8, 2010
1:00 pm – 2:00 pm ET
(10:00 am – 11:00 am PT)

You can join Sybase experts webcasts for FREE: Register Here

Watch this short demo to learn how to use ASE’s newest self-management feature, the Job Scheduler, to automate common database administration tasks.
See it in action here

Did you ever think about an integration between Sybase ASE and “Tivoli Storage Manager” (TSM) provided by IBM ?

As far as I knew, IBM did not offer such kind of tool to interface Sybase ASE and TSM and, as far as I knew, no such kind of interface exist from any other vendor.  Sure, you can still buy “SQL Backtrack” that provides direct backup to TSM through their OBSI… But from my point of view SQL Backtrack becomes obsolete regarding the new backup capabilities of Sybase ASE. So it is an expensive solution to buy SQL Backtrack just to link directly ASE with TSM to perform backups… What a pity, it could sometimes make the DBA’s life easier to backup databases directly to TSM…

But the good news is such kind of product finally exists and is named “Data Protector” !!

Data Protector will allow you to backup your Sybase ASE databases using TSM. Data Protector is a command line driven backup and restoration tool.

Unfortunately I can’t test it in the environment I’m currently working in (TSM administrators do not allow me to test it). But I think it deserves a look. Repostor is the company providing this product. You can visit their company website here: http://www.repostor.com/joomla.

Features available in this product are:

• Full backup of all databases
• Full backup of selected database(s)
• Full restore of all databases
• Full restore of selected database(s)
• Restore of database to a new machine
• Restore of database to a new database / instance
• Query to TSM. What backup versions do I have?
• Pick older version of backup for restoration

They even provide a video to install an use the product, you can see it below:

Sybase regularly provides podcasts or webcasts about their products.

Here is a bunch of podcasts about ASE (Adaptive Server Enterprise) targeting various “perfomance & tuning” topics. Enjoy

+ General Best Practices

Tune in with Sybase ASE experts and special guest Peter Thawley, senior director and architect for Sybase engineering, to explore the best practices in performance and tuning for database applications based on Adaptive Server Enterprise.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ Monitoring Practices and Tools

In this Podcast, Stefan Karlsson and guest Jeff Tallman discuss the details of monitoring within the ASE environment.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ Tips & Tricks

ASE experts Stefan Karlsson, Jeff Tallman, Rob Verschoor and Steve Bologna share their tips and tricks for improving database performance.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “CPU interaction”

David Wein and Stefan Karlsson discuss ASE’s kernel and how ASE interacts with the OS in the first of this 3-part discussion on system tuning.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “Task management”

Sybase drill down into ASE task management in the second of this 3-part series on system tuning.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “Monitoring & Configuration”

In the last of this 3-part discussion on system tuning Sybase tackles monitoring and configuration.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “Spinlocks”

Stefan Karlsson discusses spinlocks, what they are and how to monitor and tune.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

This happened in May 2008, Sybase and Sun Microsystems have build the world’s largest data warehouse based on Sybase IQ and a Sun SPARC Enterprise M9000 server.

The data warehouse is certified to support one Petabyte of mixed relational and unstructured data.

In total, the data warehouse contains six trillion rows of transactional data and more than 185 million content-searchable documents, such as e-mails, reports, spreadsheets and other multimedia objects. According to Sybase it is twice the size of the largest commercial data warehouse known to date.