8.3 filenames and FILESTREAM

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Deepa Parikh » 8.3 filenames and FILESTREAM

8.3 filenames and FILESTREAM

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Reukema

Posted Wednesday, September 24, 2008 9:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 08, 2013 5:01 PM
Points: 3, Visits: 21

I'm excited about the new FILESTREAM object, but it has a hidden flaw that must be discussed! If you start loading 100,000+ files into a table, the performance for inserting rows will continue to slow down to the point where it is crawling (several seconds for a single insert!)

This problem occurs because NTFS is continuing to create 8.3 file names for each file that is created in the FILESTREAM directory.

This is not a SQL command, or configuration issue - but an NTFS known problem that was not addressed when SQL creates the directory.

You can stop NTFS from creating 8.3 filesname, and therefore restore performance!

Here is the command to be issued in the diretory: fsutil behavior set disable8dot3

More information here: http://technet.microsoft.com/en-us/library/bb457112.aspx - scroll down to Optimizing NTFS Performance. - credit to channel9!

Post #575303

Jerry Hung

Posted Thursday, September 25, 2008 10:56 AM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:16 AM
Points: 768, Visits: 1,161

Thanks for the great tip
Something to keep in mind for future FILESTREAM implementation

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005

Post #576224

« Prev Topic | Next Topic »

Permissions