Start a Conversation

Unsolved

This post is more than 5 years old

822

February 7th, 2012 04:00

SQL Server Best Practices Article

Good morning community

I was doing a search for SQL best practices and found this article about SQL tools to help with performance issues.

One of the key components that affect the performance of Microsoft® SQL Server™ is the I/O subsystem. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system it is good practice to determine the capacity of the I/O subsystem prior to deploying SQL Server.

This paper provides guidance for validating and determining the capacity of an I/O subsystem. A number of tools are available that can be used to perform this type of testing. The focus of this paper is on the SQLIO.exe tool. However, we will contrast and compare all of the available tools. Much of the information in this white paper is in the document that is included with the download of the SQLIO tool; however, this white paper includes updates to existing information and additional information, including basic I/O configuration best practices as related to SQL Server based on recent learning's.

http://technet.microsoft.com/en-us/library/cc966412.aspx

I was wondering in your experience with installing and configuring SQL what would you consider being you top concerns and what are some of the gatcha you ran into and how did you over  come them?

No Responses!
No Events found!

Top