Solved

set dsync and directio options according to device type

Posted on 2016-10-19
4
41 Views
Last Modified: 2016-10-20
Dears, what does mean the 'unknown device type' in description column in the result of sp_helpdevice ?

And for these devices, is it preferred to set dsync option to true and directio to false.

Are those two options (dsync and directio) affect on transaction log devices which are file system devices??
0
Comment
Question by:suzn cas
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 41851407
Can you show me a sample line of sp_helpdevice output?

Generally it is better to have directio true and dsync false if you have an OS and file system type that supports directio.

If you are using any kind of file system devices, we want at least one of those options to be true (exception - devices used for tempdb where we want both to be false). directio is better performance than dsync.

If you use raw partitions the options are ignored, effectively all raw partition i/o is directio anyway.
1
 

Author Comment

by:suzn cas
ID: 41851498
Dear Joe,

kindly note the attached file, on the same location I stored log device (in its description: file system device), and data device (in its description: unknown device type).

Thank you.
sp_helpdevice-result.png
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 41851738
Huh! That's very interesting. Normally that happens only for things like tape drives.

I had a look in the documentation for sp_helpdevice as well as the documentation for master..sysdevices where that descrption field is populated from. For disk it should not show that.

I'm not sure it actually matters, maybe for some reason sp_helpdevice has gotten confused. I'm sorry, I don't think I have an answer for you on this one. :(

Probably the only way to find this out is to open a support case with SAP.
1
 

Author Closing Comment

by:suzn cas
ID: 41851763
Dear Joe,
No problem, Thank you very much
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question