Performance Tuning Guidelines for Windows Server 2008 R2








titrePerformance Tuning Guidelines for Windows Server 2008 R2
page37/37
date de publication11.06.2018
taille0.5 Mb.
typeDocumentos
1   ...   29   30   31   32   33   34   35   36   37

Disk Storage Tunings


Tune the disk storage:

The TPC-E benchmark rules require disk storage redundancy. You can use RAID 1+0 if you have enough storage capacity. If you do not have enough capacity, you can use RAID 5 .

If you use rotational disks, configure logical drives so that all spindles are used for database disks, if possible. Additional spindles improve overall disk subsystem performance.

The TPC-E workload consists of two disk I/O workloads: random reads/writes in a 9:1 ratio on database tables, and sequential writes on the log. You can improve performance with proper write caching on the log disk only in the case of battery backed up disk configurations that are able to avoid data loss in case of power failure:

Enable 100% write caching for the log disk.

TPC-E Database Size and Layout


Tune the database size and layout:

The TPC-E database consists of several file groups, and it can vary between different benchmark kits. Size is measured in number of customers, and for the database to be auditable, the ratio of database size (customers) to throughput (tpsE) should be approximately 500.

You can perform more fine tuning on the database layout :

Database tables that have higher access frequency should be placed on the outer edge of the disk if rotational disks are used.

The default TPC-E kit can be changed, and new file groups can be created. That way, file groups can consist of higher frequency access table(s) and they can be placed on the outer edge of the disk for better performance.

Client Systems Tunings


Tune the client systems:

Configure client systems the same way that the SUT is configured. See “Server Under Test (SUT) Tunings” earlier in this guide.

In addition to tuning the client systems, you should monitor client performance and eliminate any bottlenecks. Follow these client performance guidelines:

CPU utilization on clients should not be higher than 80%, to accommodate activity bursts.

If any of the processors has high CPU utilization, consider using CPU affinity for benchmark processes to even out CPU utilization. If CPU utilization is still high, consider upgrading clients to the latest processors, or add more clients.

Verify that time is synchronized between the master client and the SUT.

Monitoring and Data Collection


The following list of performance counters is considered a base set of counters when you monitor the resource usage of the database server for the TPC-E workload. Log the performance counters to a local, raw (blg) performance counter log. It is less expensive to collect all instances (‘*’ wide character) and then extract particular instances while post-processing by using Relog.exe or Perfmon:

\IPv4\*
\Memory\*
\Network Interface(*)\*
\PhysicalDisk(*)\*
\Processor Information(*)\*
\Synchronization(*)\*
\System\*
\TCPv4\*

Note: If applicable, add the \IPv6\* and \TCPv6\* objects. To monitor overall performance, you can use the performance counter chart displayed in Figure 9 and the throughput chart displayed in Figure 10 to visualize run characteristics. The first part of the run in Figure 9 represents the warm-up stage where I/O consists of mostly reads. As the run progresses, the lazy writer starts flushing caches to the disks and as write I/O increases, read I/O decreases. The beginning of steady state for the run is when the read I/O and write I/O curves seem to be parallel to each other.



Figure 9: TPC-E Perfmon Counters Chart

c:\users\dariac.ntdev\appdata\local\microsoft\windows\temporary internet files\content.outlook\fk0md562\tpce throughput (3).png

Figure 10. TPC-E Throughput Chart

You can use other tools such as Xperf to perform additional analysis.



Resources

Web Sites


Windows Server 2008 R2

http://www.microsoft.com/windowsserver2008/en/us/R2.aspx

Windows Server 2008

http://www.microsoft.com/windowsserver2008/

Windows Server Performance Team Blog

http://blogs.technet.com/winserverperformance/

Windows Server Catalog

http://www.windowsservercatalog.com/

SAP Global Benchmark: Sales and Distribution (SD)

http://www.sap.com/solutions/benchmark/sd.epx

Windows Sysinternals

http://technet.microsoft.com/sysinternals/default.aspx

Transaction Processing Performance Council

http://www.tpc.org/

IxChariot

http://www.ixiacom.com/support/ixchariot/

Power Management


Power Policy Configuration and Deployment in Windows

http://msdn.microsoft.com/windows/hardware/gg463243.aspx

Using PowerCfg to Evaluate System Energy Efficiency

http://msdn.microsoft.com/windows/hardware/gg463250.aspx

Interrupt-Affinity Policy Tool

http://msdn.microsoft.com/windows/hardware/gg463378.aspx

Networking Subsystem


Scalable Networking: Eliminating the Receive Processing Bottleneck—Introducing RSS

http://download.microsoft.com/download/5/D/6/5D6EAF2B-7DDF-476B-93DC-7CF0072878E6/NDIS_RSS.doc

Windows Filtering Platform

http://msdn.microsoft.com/windows/hardware/gg463267.aspx

Networking Deployment Guide: Deploying High-Speed Networking Features

http://download.microsoft.com/download/8/E/D/8EDE21BC-0E3B-4E14-AAEA-9E2B03917A09/HSN_Deployment_Guide.doc

Storage Subsystem


Disk Subsystem Performance Analysis for Windows

(Parts of this document are out of date, but many of the general observations and guidelines are still accurate.)

http://msdn.microsoft.com/windows/hardware/gg463405.aspx

Web Servers


10 Tips for Writing High-Performance Web Applications

http://go.microsoft.com/fwlink/?LinkId=98290

File Servers


Performance Tuning Guidelines for Microsoft Services for Network File System

http://technet.microsoft.com/library/bb463205.aspx

[MS-FSSO]: File Access Services System Overview

http://msdn.microsoft.com/library/ee392367(v=PROT.10).aspx

How to disable the TCP autotuning diagnostic tool

http://support.microsoft.com/kb/967475

Active Directory Servers


Active Directory Performance for 64-bit Versions of Windows Server 2003

http://www.microsoft.com/downloads/details.aspx?FamilyID=52e7c3bd-570a-475c-96e0-316dc821e3e7

How to configure Active Directory diagnostic event logging in Windows Server 2003 and in Windows 2000 Server

http://support.microsoft.com/kb/314980

Remote Desktop Session Host Capacity Planning


RD Session Host Capacity Planning in Windows Server 2008 R2

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ca837962-4128-4680-b1c0-ad0985939063

RD Virtualization Host Capacity Planning in Windows Server 2008 R2

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bd24503e-b8b7-4b5b-9a86-af03ac5332c8

Virtualization Servers


Hyper-V Dynamic Memory Configuration Guide

http://technet.microsoft.com/library/ff817651(WS.10).aspx

NUMA Node Balancing

http://blogs.technet.com/b/winserverperformance/archive/2009/12/10/numa-node-balancing.aspx

Hyper-V WMI Provider

http://msdn2.microsoft.com/library/cc136992(VS.85).aspx

Hyper-V WMI Classes

http://msdn.microsoft.com/library/cc136986(VS.85).aspx

Requirements and Limits for Virtual Machines and Hyper-V in Windows Server 2008 R2

http://technet.microsoft.com/library/ee405267(WS.10).aspx

Network Workload


Ttcp

http://en.wikipedia.org/wiki/Ttcp

How to Use NTttcp to Test Network Performance

http://msdn.microsoft.com/windows/hardware/gg463264.aspx

Sales and Distribution Two-Tier Workload and TPC-E Workload


Setting Server Configuration Options

http://go.microsoft.com/fwlink/?LinkId=98291

How to: Configure SQL Server to Use Soft-NUMA

http://go.microsoft.com/fwlink/?LinkId=98292

How to: Map TCP/IP Ports to NUMA Nodes

http://go.microsoft.com/fwlink/?LinkId=98293

ALTER SERVER CONFIGURATION SET PROCESS AFFINITY (Transact-SQL) (How to Set Process Affinity using DDL)

http://msdn.microsoft.com/library/ee210585.aspx

Best Practices for Running SQL Server on Computers That Have More Than 64 CPUs

http://msdn.microsoft.com/library/ee210547.aspx

SAP with Microsoft SQL Server 2008 and SQL Server 2005:

Best Practices for High Availability, Maximum Performance, and Scalability

http://www.sdn.sap.com/irj/sdn/sqlserver?rid=/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548c65

1   ...   29   30   31   32   33   34   35   36   37

similaire:

Performance Tuning Guidelines for Windows Server 2008 R2 iconRésumé : Ce livre blanc décrit la fonctionnalité filestream de sql...

Performance Tuning Guidelines for Windows Server 2008 R2 iconInstallation de BizTalk Server 2010 sur Windows 7 et Windows Vista...

Performance Tuning Guidelines for Windows Server 2008 R2 iconWindows 1 Windows 8 Windows Server 2012 R2 Windows Server 2012

Performance Tuning Guidelines for Windows Server 2008 R2 iconSolution En partenariat avec Xavor et Analysis Team, Virgin a déployé...
«Grâce à Windows Server System et. Net, nous avons élaboré une solution globale en réponse à un problème commercial très préoccupant....

Performance Tuning Guidelines for Windows Server 2008 R2 iconGuide du pack d’administration dhcp windows Server pour Operations Manager 2007

Performance Tuning Guidelines for Windows Server 2008 R2 iconRésumé À l'heure actuelle, plus de 60 des serveurs sont fournis avec Microsoft® Windows® Server

Performance Tuning Guidelines for Windows Server 2008 R2 icon2011 Certification sql server 2008: ts database Development 2010

Performance Tuning Guidelines for Windows Server 2008 R2 iconInstallation du driver Microsoft sql server pour php
«Framework php sous iis : Copix Framework» pour l’installation de sql server Express 2008

Performance Tuning Guidelines for Windows Server 2008 R2 iconBienvenue dans le Guide des opérations sur la sécurité de Windows...

Performance Tuning Guidelines for Windows Server 2008 R2 iconAvertissement
«Framework php sous iis : Copix Framework» pour l’installation de sql server Express 2008








Tous droits réservés. Copyright © 2016
contacts
ar.21-bal.com