Is DIRECT IO supported for Sybase ASE v15 on your platform ? - Sybase ADDICT

Is DIRECT IO supported for Sybase ASE v15 on your platform ?

April 2nd, 2010 @ 3:39 PM by Jean-Francois LEBON | Be the 1st to comment
This sql query tells you if Direct IO is supported on your platform:
```
select low from spt_values
where  type='io'
```
A value of 1 means “Yes, direct io is supported on this platform”.
A value of 0 means “No, direct io is NOT supported on this platform”.

Read this nice post from David Wein about Direct I/O device option.
Tags: ase, howto, sql, sybase, Sybase Adaptive Server Enterprise, tips, transact-sql
Previous post

Next post

No Comments »

No comments yet.

RSS feed for comments. TrackBack URL

Something to say ? Leave a comment...

You must be logged in to post a comment.

article ase asiq End of Life Notice General News howto iq news performance podcast powerbuilder replication replication server Review screencast sql sybase Sybase Adaptive Server Enterprise Sybase Adaptive Server IQ Sybase Articles Sybase HowTo Sybase News Sybase Replication Server Sybase Tips & Tricks Sybase Transact-SQL Code tips transact-sql video Videos/Podcasts/Webcasts