We help IT Professionals succeed at work.

Strip size for Window SQL Server

1,373 Views
Last Modified: 2014-08-21
Need to configure different RAID group on the Window 2008 R2 SQL Server. What is the recommended strip size for

1. OS (RAID 1)
2. SQL TempDB
3. SQL Log
4. SQL Data

Default setting for RAID is 64K. Will that be too big for OS ? Tks
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott PletcherSenior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
retired saggar maker
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Do u mean I should just keep 64K strip size for each RAID group, correct ?
andyalderretired saggar maker
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Only meant for SQL data, but what controller is it. "strip size" suggests HP and they generally use a large strip size by default as it's best for most things.

Author

Commented:
Tks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.