Questions tagged [file-system]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
53 views

Should I disable filesytem journaling for MS SQL Server (Linux/Windows)

For a PostgreSQL server installation on Linux, it is beneficial to disable filesystem journaling. Tip: Because WAL restores database file contents after a crash, journaled filesystems are not ...
8
votes
1answer
244 views

How is the new system stored procedure sys.xp_delete_files different from sys.xp_delete_file?

SQL Server 2019 introduced a new (and undocumented) system stored procedure: sys.xp_delete_files What, exactly, does this new extended stored procedure do? How does it differ from xp_delete_file ...
0
votes
2answers
29 views

On a typical COW filesystem, is the database WAL redundant (in theory)?

EDIT: I was incorrectly assuming that all COW filesystems have a WAL. IT seems that BTRFS doesn't, so this question essentially applies only to ZFS. Typical COW filesystems, like ZFS, have their own ...
0
votes
0answers
28 views

ReFS on SQL Servers 2016 and 2017 [duplicate]

Could you please share your experience regarding ReFS for SQL Server's storage: Is it better to use ReFS for SQL server 2016 upward? Have you come across any issues with ReFS? Does it recommend for ...