Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All,
I'm starting with a bit of a greenfield CDOT system, and have been reading up on some performance tweaks to put in ahead of time prior to this going production... things like zero-block dedupe, scheduling reallocates, etc
The one thing I need help with is I see a few documents telling me to change max-write-alloc-blocks to 256.
Is this a no-brainer change? or are there certain scenarios this could be a hindrance?
This is going to be a dominantly MS-SQL cluster over iSCSI.
Thanks!!
Matt
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I haven't seen a SQL recommendation to modify the default. There are some SAP docs recommending setting to 256 and Exchange to 512 for jetstress. Do you have a support case open? I wouldn't modify without a support recommendation since modifying is not listed in best practice documentation for SQL.
