백서 : 최적 성능을 위한 SQL Server 구성 및 모니터링 방법

  • Article

MOSS 2007 관리자가 최적의 성능 지원을 위해 SQL Server를 구성하고 모니터링할 때 참고할 수 있는 권장 사항과 best practice가 포함된 백서가 릴리즈되었습니다; [다운로드]

본 백서의 목차는 다음과 같습니다.

INTRODUCTION    1

KNOW YOUR NEEDS AND PLAN AHEAD    1

PLANNING RECOMMENDATIONS    1

Information architecture recommendations    2
  Adapt your information architecture design to the software boundaries of SharePoint Products and Technologies.    2
  Limit content database size to enhance manageability    2
  Allocate storage for versions and the recycle bin    2
  Use quota templates to manage storage    2
  Manage your large lists for performance    3

Physical topology guidance    3
  Start with a dedicated server running SQL Server 2005    3
  Consider scaling out in addition to adding resources    4
  Follow the SQL Server guidelines when choosing hardware    4

Network topology recommendations    7

Physical storage recommendations    8
  Use appropriate disks and RAID arrays    8
  Separate and prioritize your data among disks    8
  Follow vendor configuration recommendations    9

MONITORING, MAINTAINING, AND TROUBLESHOOTING    9

Physical Servers    9
  Disk counters to monitor    9
  Disk recommended practices    11
  SQL Server recommended practices    11

Troubleshooting    11