Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 83
  • Last Modified:

set dsync and directio options according to device type

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
suzn cas
Asked:
suzn cas
  • 2
  • 2
1 Solution
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
suzn casDBAAuthor Commented:
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
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
suzn casDBAAuthor Commented:
Dear Joe,
No problem, Thank you very much
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now