Compressing Filestream

Question

Post reply

Compressing Filestream

Steve Jones - SSC Editor

SSC Guru

Points: 738177
More actions
November 5, 2013 at 9:10 pm

#73384

Comments posted to this topic are about the item Compressing Filestream

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Thanks for the QotD.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 2

Nice one thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

nice question .. Thanks for sharing

and nice DP Steve

sqlnaive SSCoach Points: 17437 More actions · Answer 4

Nice easy question. Specially after losing few points in recent days thanks to some mind blender questions.

Thanks steve.

Carlo Romagnano SSC-Insane Points: 22759 More actions · Answer 5

It is recommended that you set the clusters to 4kb.

Thanks!

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 6

PChiragS

SSCarpal Tunnel

Points: 4965

November 6, 2013 at 7:50 am

#1664470

nice and easy question..

Thanks Steve.

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Good question.

Does the confict between the normal recommended cluster size for volumes holding filestream containers (64KB) and the size recommended for use when the filestream container is on a compressed volume (4KB) induicate that having filestream data on a compressed volume will cause performance issues? 4KB is a lower cluster size than I've generally used for RAID configurations anyway, frighteningly low.

Tom

Steve Jones - SSC Editor SSC Guru Points: 738177 More actions Follow · Answer 8

L' Eomot Inversé (11/6/2013)
Good question.
Does the confict between the normal recommended cluster size for volumes holding filestream containers (64KB) and the size recommended for use when the filestream container is on a compressed volume (4KB) induicate that having filestream data on a compressed volume will cause performance issues? 4KB is a lower cluster size than I've generally used for RAID configurations anyway, frighteningly low.

I haven't heard anything about this. the only performance issues I've seen and read about are when 8/3 names are not disabled.