Sybase ASE – Changing Existing Database Device from ‘dsync’ to ‘directio’

The directio parameter allows you to configure Adaptive Server to transfer data directly to disk, bypassing the operating system buffer cache. directio performs IO in the same manner as raw devices and provides the same performance benefit as raw devices, but has the ease of use and manageability of file system devices. You cannot set the directio option for the master device. directio is a static parameter that requires a restart of Adaptive Server to take effect .

This article describes how to change the device attribute from ‘dsync’ to ‘directio’.

Device attributes can be changed by calling the sp_deviceattr procedure twice, first to disable dsync and second to enable directio:-

sp_deviceattr , 'dsync', false
go
sp_deviceattr , 'directio', true
go


Advertisements

One thought on “Sybase ASE – Changing Existing Database Device from ‘dsync’ to ‘directio’

  1. Pingback: Sybase ASE | Oracle Database Internal Mechanism

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.