MS SQL FILESTREAM Performance
Lincoln Burrows ~
Modified: August 19th, 2015 ~ ~ 1 Minute Reading
- This topic has 2 replies, 3 voices, and was last updated 9 years, 8 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
On what kind of a server?? What kind of hardware to serve those files? What kind of disks, network etc.??
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.
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.