HP IO Accelerator for BladeSystem c-Class Uživatelská příručka

Procházejte online nebo si stáhněte Uživatelská příručka pro Databázový software HP IO Accelerator for BladeSystem c-Class. HP IO Accelerator for BladeSystem c-Class Reference Guide Uživatelská příručka

  • Stažení
  • Přidat do mých příruček
  • Tisk

Shrnutí obsahu

Strany 1 - Microsoft SQL Server

Microsoft SQL Server Configuration Guide for HP IO Accelerators Part Number 647096-001 December 2010 (First Edition)

Strany 2 - Intended audience

Testing IO Accelerator-powered SQL performance 10 o Physical Disk—Average Disk queue Length o Logical Disk—Avg. Disk sec/Read [Read Latency] o L

Strany 3 - Contents

Architectural scenarios 11 Architectural scenarios Scenario 1: The entire database fits on the IO Accelerators 1. Place the data files on one IO Ac

Strany 4 - Microsoft Windows SQL Server

Architectural scenarios 12 • Determine the maximum size of the tempdb file you need and then create each tempdb data file to be the same size. • T

Strany 5 - RAID options

Architectural scenarios 13 data for each year. In this scenario, you can keep the most recent data on IO Accelerators and keep older data on more tr

Strany 6 - Multi-site clustering

Acronyms and abbreviations 14 Acronyms and abbreviations CPU central processing unit DBCC database console commands IOPS input/output operations p

Strany 7

© Copyright 2010 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. The only warranties

Strany 8 - Backup considerations

Contents 3 Contents Installing and preparing the IO Accelerator for Microsoft Windows SQL Server ... 4 Initial setup

Strany 9 - Workload examples

Installing and preparing the IO Accelerator for Microsoft Windows SQL Server 4 Installing and preparing the IO Accelerator for Microsoft Windows SQL

Strany 10 - • Conduct full restores

RAID options 5 RAID options RAID 0 RAID 0 offers the full capacity of the IO Accelerator without any disk-level redundancy. NOTE: Windows® Soft

Strany 11 - Architectural scenarios

High availability considerations 6 High availability considerations Database mirroring NOTE: Database mirroring requires Windows® SQL Server 20

Strany 12 - Log files

High availability considerations 7 Third-party software is required to keep the data in sync between the different cluster nodes. HP recommends the

Strany 13 - Architectural scenarios 13

Backup considerations 8 Backup considerations General recommendations Backing up large SQL Server databases often takes a long time and ends up affe

Strany 14 - Acronyms and abbreviations

Testing IO Accelerator-powered SQL performance 9 Testing IO Accelerator-powered SQL performance Methodology Generally, benchmarks such as SQLIO and

Komentáře k této Příručce

Žádné komentáře