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 12»»

Compressing Filestream Expand / Collapse
Author
Message
Posted Tuesday, November 5, 2013 9:10 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:11 AM
Points: 32,158, Visits: 16,547
Comments posted to this topic are about the item Compressing Filestream






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1511708
Posted Tuesday, November 5, 2013 9:11 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, June 26, 2015 12:58 AM
Points: 1,814, Visits: 806
Thanks for the QotD.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1511709
Posted Tuesday, November 5, 2013 11:51 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:21 PM
Points: 14,474, Visits: 12,469
Nice one thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1511727
Posted Wednesday, November 6, 2013 12:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:25 PM
Points: 1,015, Visits: 1,764
nice question .. Thanks for sharing

and nice DP Steve
Post #1511735
Posted Wednesday, November 6, 2013 12:31 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 3,595, Visits: 2,703
Nice easy question. Specially after losing few points in recent days thanks to some mind blender questions.

Thanks steve.
Post #1511737
Posted Wednesday, November 6, 2013 12:42 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 4,510, Visits: 5,968
Nice, simple question, thanks, Steve.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1511738
Posted Wednesday, November 6, 2013 3:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:41 AM
Points: 2,864, Visits: 2,737
It is recommended that you set the clusters to 4kb.

Thanks!
Post #1511767
Posted Wednesday, November 6, 2013 7:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 13, 2015 12:40 PM
Points: 2,077, Visits: 595
nice and easy question..
Thanks Steve.
Post #1511889
Posted Wednesday, November 6, 2013 8:28 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 8,595, Visits: 10,366
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
Post #1511907
Posted Wednesday, November 6, 2013 9:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:11 AM
Points: 32,158, Visits: 16,547
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1511918
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse