Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

8.3 filenames and FILESTREAM Expand / Collapse
Author
Message
Posted Wednesday, September 24, 2008 9:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 26, 2013 4:50 PM
Points: 3, Visits: 26
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
Posted Thursday, September 25, 2008 10:56 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 8:36 AM
Points: 772, Visits: 1,183
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 »

Add to briefcase

Permissions Expand / Collapse