Friday, November 06, 2009

SQL Server 2008 FILESTREAM Best Practices

MSSQLTips - Best Practices – When Using FILESTREAM Feature of SQL Server 2008

“Problem
In SQL Server 2008 one can store BLOBs (e.g. Images, video, Word, Excel, PDF, MP3, etc) in the NTFS file system rather than in a database file. This can be done by using the new FILESTREAM feature which was introduced in SQL Server 2008. In this tip we will take a look at some of the best practices which a database administrator can follow to get the best performance when using the FILESTREAM feature of SQL Server 2008.

Solution
If you are new to SQL Server 2008 and haven’t used the FILESTREAM feature yet, then I would suggest you start with the following tips.

FILESTREAM Best Practices

Some of the best practices which can be leveraged by database administrators when using the FILESTREAM feature of SQL Server 2008 are listed below:

image

I’m starting to see a little movement in my day life toward SQL Server 2008 and a little interest in the FILESTREAM feature so when I saw this, I wanted to make sure I captured it for future reference and sharing…

This is a great post which summarizes a number of FILESTREAM best practices I’ve seen and heard about in the last couple years. Both configuration (i.e. turn off Last Updated and 8.3) and usage (what file sizes are best stored where) tips are included.

 

Related Past Post XRef:
SQL Server VARBINARY vs FILESTREAM – The code and performance trade offs saving the right sized files to the right datatype.
SQL Server 2008 FileStream and VB.Net – The Sample
SQL Server FileStream Whitepaper – A DBA/IT focused FILESTREAM paper
Run to Run As Radio for a great SQL Server 2008 FILESTREAM show
SQL Server 2008 FILESTREAM Attribute from Start to C#
SQL Server 2008, the FILESTREAM Attribute and Partitioning - Apparently not as easy as it looks (yet at least)...
A future world without the SQL Server Image/Text/NText data types. Now's the time to start planning for that future...
SQL Server 2008 FILESTREAM - Writing a file to a FILESTREAM column
More SQL Server 2008 FileStream Fun
Playing with the SQL Server 2008 FileStream Attribute

No comments: