Home » Blog » Topic » MS SQL FILESTREAM Performance

MS SQL FILESTREAM Performance

Lincoln Burrows ~ Modified: August 19th, 2015 ~ ~ 1 Minute Reading

Home › Forums › MS SQL FILESTREAM Performance

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • August 19, 2015 at 11:13 am #487 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Hii

    I am using SQL Server 2008 and having some questions about FILESTREAM capability

    1. What would the difference in performance be of returning a file streamed from SQL Server 2008 using the FILESTREAM capability vs. directly accessing the file from a shared directory?
    2. If 100 users requested 100 Mb files within a 10 second window, would SQL Server 2008 performance slow to a crawl?
    August 20, 2015 at 12:28 pm #500 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    On what kind of a server?? What kind of hardware to serve those files? What kind of disks, network etc.??

    August 21, 2015 at 5:40 am #501 Score: 0
    Stephen West
    Moderator
    4 pts

    FILESTREAM data must be stored in FILESTREAM filegroups. A FILESTREAM filegroup is a special filegroup that contains file system directories instead of the files themselves. These file system directories are called data containers. Data containers are the interface between Database Engine storage and file system storage.
    When you use FILESTREAM storage, consider the following:

    • When a table contains a FILESTREAM column, each row must have a nonnull unique row ID.
    • FILESTREAM data containers cannot be nested.
    • When you are using failover clustering, the FILESTREAM filegroups must be on shared disk resources.
    • FILESTREAM filegroups can be on compressed volumes.
  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.