SQL Server with Mr. Denny

Apr 21 2011   11:00AM GMT

Is there a best practice to advise a storage admin how to set a SAN up best for SQL Server OLTP & OLAP? or is this entirely company dependent?

Denny Cherry Denny Cherry Profile: Denny Cherry

There are some general best practices such as separate data and log LUNs, separate TempDB from everything else.  For data warehouses make sure that the data is spread over as many disks as possible.  Anything more specific however is very company specific and would require a good understanding of what the databases look like as well as what the storage array looks like.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: