SQL Server – Best Practice Analyzer – Warning – FileStream Feature – NtfsDisable8dot3NameCreation

Background

Running Best Practice Analyzer and one of the warnings cited is “NtfsDisable8dot3NameCreation”.

 

Warning

Image

affectfilestreamperformance

Textual

Category: Policy

Source: localhost

Issue: Certain file system configuration parameters need to be adjusted to improve performance of the FILESTREAM feature in SQL Server
NtfsDisable8dot3NameCreation:0

Impact: Certain operations that involve FILESTREAM might perform slower if these configuration changes are not made

Remediation

8dot3name

Review fsUtil 8dot3name

Syntax


FSUTIL.EXE 8dot3name query

Set fsUtil 8dot3name

To set, please pass in 1;

Syntax


FSUTIL.EXE 8dot3name set 1

Output

fsutilset

Reset fsUtil 8dot3name

If you need to reverse the change, please pass in 0;

Syntax


FSUTIL.EXE 8dot3name set 0

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s