Transcript
1
L
Hitachi Unified Storage VM Dynamically Provisioned 43,200 Mailbox Exchange 2013 Mailbox Resiliency Storage Solution Tested with: ESRP – Storage Version 4.0 Test Date: July - August 2013
Month Year
Notices and Disclaimer Copyright © 2013 Hitachi Data Systems Corporation. All rights reserved. The performance data contained herein was obtained in a controlled isolated environment. Actual results that may be obtained in other operating environments may vary significantly. While Hitachi Data Systems Corporation has reviewed each item for accuracy in a specific situation, there is no guarantee that the same results can be obtained elsewhere. All designs, specifications, statements, information and recommendations (collectively, "designs") in this manual are presented "AS IS," with all faults. Hitachi Data Systems Corporation and its suppliers disclaim all warranties, including without limitation, the warranty of merchantability, fitness for a particular purpose and non-infringement or arising from a course of dealing, usage or trade practice. In no event shall Hitachi Data Systems Corporation or its suppliers be liable for any indirect, special, consequential or incidental damages, including without limitation, lost profit or loss or damage to data arising out of the use or inability to use the designs, even if Hitachi Data Systems Corporation or its suppliers have been advised of the possibility of such damages. This document has been reviewed for accuracy as of the date of initial publication. Hitachi Data Systems Corporation may make improvements and/or changes in product and/or programs at any time without notice.
1
Table of Contents Overview ............................................................................................................................................ 3 Disclaimer .......................................................................................................................................... 3 Features ............................................................................................................................................. 4 Solution Description......................................................................................................................... 6 Targeted Customer Profile .............................................................................................................. 15 Test Deployment ............................................................................................................................... 16 Replication Configuration ................................................................................................................ 19 Best Practices ................................................................................................................................... 21 Core Storage ............................................................................................................................. 21 Storage-based Replication ....................................................................................................... 22 Backup Strategy........................................................................................................................ 22 Test Results Summary ..................................................................................................................... 23 Reliability................................................................................................................................... 23 Storage Performance Results ................................................................................................... 23 Database Backup and Recovery Performance ........................................................................ 28 Conclusion ........................................................................................................................................ 29 Appendix A — Test Reports ............................................................................................................ 30 Performance Test Result: CB10 ............................................................................................... 30 Performance Test Database Checksums Result: CB10...........................................................41 Stress Test Result: CB10 ......................................................................................................... 47 Stress Test Database Checksums Result: CB10 ..................................................................... 59 Backup Test Result: CB10 ........................................................................................................ 65 Soft Recovery Test Result: CB10 ............................................................................................. 70 Soft Recovery Test Performance Result: CB10 ....................................................................... 79
2
Hitachi Unified Storage VM Dynamically Provisioned 43,200 Mailbox Exchange 2013 Mailbox Resiliency Storage Solution Tested with: ESRP – Storage Version 4.0 Test Date: July - August 2013
Overview This document provides information on a Microsoft Exchange Server 2013 mailbox resiliency storage solution that uses Hitachi Unified Storage VM storage systems with Hitachi Dynamic Provisioning. This solution is based on ® the Microsoft Exchange Solution Reviewed Program (ESRP) – Storage program. For more information about the contents of this document or Hitachi Data Systems best practice recommendations for Microsoft Exchange Server 2013 storage design, see Hitachi Data Systems Microsoft Exchange Solutions Web page. The ESRP – Storage program was developed by Microsoft Corporation to provide a common storage testing framework for vendors to provide information on its storage solutions for Microsoft Exchange Server software. For more information about the Microsoft ESRP – Storage program, see TechNet’s overview of the program.
Disclaimer This document has been produced independently of Microsoft Corporation. Microsoft Corporation expressly disclaims responsibility for, and makes no warranty, express or implied, with respect to the accuracy of the contents of this document. The information contained in this document represents the current view of Hitachi Data Systems on the issues discussed as of the date of publication. Due to changing market conditions, it should not be interpreted to be a commitment on the part of Hitachi Data Systems, and Hitachi Data Systems cannot guarantee the accuracy of any information presented after the date of publication.
3
Features The purpose of this testing was to measure the ESRP 4.0 results on a Microsoft Exchange 2013 environment with 43,200 users and twelve servers. This testing used Hitachi Unified Storage VM with Hitachi Dynamic Provisioning in a two-pool RAID-10 (2D+2D) - one for databases and one for logs - resiliency configuration. These results help answer questions about the kind of performance capabilities to expect with a large-scale Exchange deployment on Hitachi Unified Storage VM. Testing used twelve Hitachi Compute Blade 2000 server blades in two chassis, each with the following:
64 GB of RAM
Two quad-core Intel Xeon X5690 3.46 GHz CPUs
Two dual-port 8 Gb/sec Fibre Channel PCIe HBA (Emulex LPe1205-HI, using two ports per HBA) located in the chassis I/O expansion tray
Microsoft Windows Server 2008 R2 Enterprise
This solution includes Exchange 2013 Mailbox Resiliency by using the database availability group (DAG) feature. This tested configuration uses twelve DAGs, each containing twenty four database copies and two servers (one simulated). The test configuration was capable of supporting 43,200 users with a 0.3 IOPS per user profile and a user mailbox size of 5 GB. Hitachi Unified Storage VM with the following was used for these tests:
480 × 3 TB 7.2K RPM SAS disks
128 GB of cache
24 × 8 Gb/sec paths used
Hitachi Unified Storage VM is an entry-level enterprise storage platform. It combines storage virtualization services with unified block, file, and object data management. This versatile, scalable platform offers a storage virtualization system to provide central storage services to existing storage assets. Unified management delivers end-to-end central storage management of all virtualized internal and external storage on Unified Storage VM. A unique, hardware-accelerated, object-based file system supports intelligent file tiering and migration, as well as virtual NAS functionality, without compromising performance or scalability. The benefits of Unified Storage VM are the following:
Enables the move to a new storage platform with less effort and cost when compared to the industry average
Increases performance and lowers operating cost with automated data placement
Supports scalable management for growing and complex storage environment while using fewer resources
Achieves better power efficiency and with more storage capacity for more sustainable data centers
Lowers operational risk and data loss exposure with data resilience solutions
Consolidates management with end-to-end virtualization to prevent virtual server sprawl
4
Hitachi Unified Storage VM is highly suitable for a variety of applications and host platforms that support the most demanding workloads. With internal and external storage virtualization capabilities, advanced replication technologies, tiered storage features and a tightly integrated management suite, Hitachi Unified Storage VM is fully capable of serving as the core underlying storage platform of high performance Exchange Server 2013 architectures, while maintaining the ability to support additional workloads of an organization such as SQL Server and SharePoint Server.
5
Solution Description Deploying Microsoft Exchange Server 2013 requires careful consideration of all aspects of the solution architecture. Host servers need to be configured so that they are robust enough to handle the required Exchange load. The storage solution must be designed to provide the necessary performance while also being reliable and easy to administer. Of course, an effective backup and recovery plan should be incorporated into the solution as well. The aim of this solution report is to provide a tested configuration that uses Hitachi Unified Storage VM to meet the needs of a large Exchange Server deployment. This solution uses Hitachi Dynamic Provisioning, which is enabled on Hitachi Unified Storage VM via a license key. In the most basic sense, Hitachi Dynamic Provisioning is similar to the use of a host-based logical volume manager (LVM), but with several additional features available within Hitachi Unified Storage VM and without the need to install software on the host or incur host processing overhead. Hitachi Dynamic Provisioning is a superior solution by providing for one or more pools of wide striping across many RAID groups within Hitachi Unified Storage VM. One or more Hitachi Dynamic Provisioning virtual volumes (DPVols) of a user-specified logical size (with no initial physical space allocated) are created and associated with a single pool. Primarily, Hitachi Dynamic Provisioning is deployed to avoid the routine issue of hot spots that occur on logical units (LUs) from individual RAID groups when the host workload exceeds the IOPS or throughput capacity of that RAID group. By using many RAID groups as members of a striped Hitachi Dynamic Provisioning pool underneath the virtual or logical volumes seen by the hosts, a host workload is distributed across many RAID groups, which provides a smoothing effect that dramatically reduces hot spots and results in fewer mailbox moves for the Exchange administrator. Hitachi Dynamic Provisioning also carries the side benefit of thin provisioning, where physical space is only assigned from the pool to the DPVol as needed. Space is allocated as needed as 42 MB pool pages to that DPVol’s logical block address range. A pool can also be dynamically expanded by adding more RAID groups without disruption or requiring downtime. Upon expansion, a pool can be rebalanced easily so that the data and workload are wide striped evenly across the current and newly added RAID groups that make up the pool. High availability is also a part of this solution with the use of database availability groups (DAG), which is the base component of the high availability and site resilience framework built into Microsoft Exchange Server 2013. A DAG is a group of up to 16 mailbox servers that host a set of databases and logs and use continuous replication to provide automatic database-level recovery from failures that affect individual servers or databases. Any server in a DAG can host a copy of a mailbox database from any other server in the DAG. When a server is added to a DAG, it monitors and works with the other servers in the DAG to provide automatic recovery delivering a robust, highly available Exchange solution without the administrative complexities of traditional failover clustering. For more information about the DAG feature in Exchange Server 2013, see http://technet.microsoft.com/en-us/library/dd979799.aspx This solution includes two copies of each Exchange database using twelve DAGs, with each DAG configured with two server blades (one simulated) that host active mailboxes in twenty four databases. To target the 43,200 user resiliency solution, a Hitachi Unified Storage VM storage system was configured with 480 disks (maximum 1152). Twelve servers (one per DAG) were used, with each server configured with 3,600 mailboxes. There were 24 active databases and the simulated database copies for the tests.
6
Each DAG contained two copies of the databases hosted by that DAG:
A local, active copy on a server connected to the primary Hitachi Unified Storage VM
A passive copy (simulated) on another server connected to a second Hitachi Unified Storage VM (simulated).
This recommended configuration can support both high-availability and disaster-recovery scenarios when the active and passive database copies are allocated among both DAG members and dispersed across both storage systems. Each simulated DAG server node in this solution maintains a mirrored configuration and possesses adequate capacity and performance capabilities to support the second set of replicated databases. Figure 1 illustrates the two systems that make up the simulated DAG configuration. For more information, see the Hitachi Data Systems Storage Systems web page.
7
Figure 1
8
This solution enables organizations to consolidate Exchange Server 2013 DAG deployments on two Hitachi Unified Storage VM storage systems. Using identical hardware and software configurations guarantees that an active database and its replicated copy do not share storage paths, disk spindles or storage controllers, making it a very reliable, high-performing, highly available Exchange Server 2013 solution that is cost effective and easy to manage. This helps ensure that performance and service levels related to storage are maintained regardless of which server is hosting the active database. If further protection is needed in a production environment, additional Exchange Server 2013 mailbox servers can be easily added to support these failover scenarios. The disks in Hitachi Unified Storage VM were organized into parity groups for use by databases or logs. There were 480 × 3 TB 7.2K RPM SAS disks used in these tests configured as 120 RAID-10 (2D+2D) parity groups for the Exchange databases and logs. Each parity group had 4 LDEVs of 1.33 TB configured. The 432 LDEVs from parity groups 4-25 to 8-4 were added to HDP Pool-0 (Database Pool) and the 48 LDEVs from Parity Group 8-5 to 8-16 were added to HDP Pool-1 (Log Pool). There were 288 V-Vol Groups (DPVol containers) created from HDP Pool-0 (Database Pool) and each group had one 1980 GB DPVol created in it. Similarly, from HDP Pool-1 (Log Pool) 288 V-Vol Groups were created and each group had one 198 GB DPVol in it. The Database DPVols and Log DPVols were then assigned to the hosts as LUNs.
9
Table 1 outlines the port layout for the primary storage and servers. An identical configuration would be deployed on the replicated storage and servers for this solution. Table 1. Hitachi Unified Storage VM Ports to Server Mapping Configuration Server
Primary path
Secondary path
CB10
5A
6A
5B
6B
6A
5A
6B
5B
7A
8A
7B
8B
8A
7A
8B
7B
1A
2A
1B
2B
2A
1A
2B
1B
3A
4A
3B
4B
4A
3A
4B
3B
1C
2C
1D
2D
2C
1C
2D
1D
3C
4C
3D
4D
4C
3C
4D
3D
CB11
CB12
CB13
CB14
CB15
CB16
CB17
CB18
CB19
CB20
CB21
10
Table 2 outlines the port layout with the database DPVol assignments for the primary storage and servers. An identical configuration would be deployed on the replicated storage and servers for this solution. Table 2. Hitachi Unified Storage VM Ports to Database DPVol Layout Port
Database
DB DPVols
5A
Databases 1-12
10:00 –10:0B
5B
Databases 13-24
10:0C –10:17
6A
Databases 25-36
10:18-10:23
6B
Databases 37-48
10:24-10:2F
7A
Databases 49-60
10:30-10:3B
7B
Databases 61-72
10:3C-10:47
8A
Databases 73-84
10:48-10:53
8B
Databases 85-96
10:54-10:5F
1A
Databases 97-108
10:60-10:6B
1B
Databases109-120
10:6C-10:77
2A
Databases121-132
10:78-10:83
2B
Databases133-144
10:84-10:8F
3A
Databases145-156
10:90-10:9B
3B
Databases157-168
10:9C-10:A7
4A
Databases169-180
10:A8-10:B3
4B
Databases181-192
10:B4-10:BF
1C
Databases193-204
10:C0-10:CB
1D
Databases 205-216
10:CC-10:D7
2C
Databases 217-228
10:D8-10:E3
2D
Databases 229-240
10:E4-10:EF
3C
Databases 241-252
10:F0-10:FB
3D
Databases 253-264
10:FC-11:07
4C
Databases 265-276
11:08-11:13
4D
Databases 277-288
11:14-11:1F
11
Table 3 outlines the port layout with the log DPVol assignments for the primary storage and servers. An identical configuration would be deployed on the replicated storage and servers for this solution. Table 3. Hitachi Virtual StoragePlatform Ports to Log DPVol Layout Port
Log
Log DPVols
5A
Log 1-12
11:20-11:2B
5B
Log 13-24
11:2C-11:37
6A
Log 25-36
11:38-11:43
6B
Log 37-48
11:F8-11:FF
7A
Log 49-60
11:20-11:27
7B
Log 61-72
11:28-11:2F
8A
Log 73-84
11:30-11:37
8B
Log 85-96
11:38-11:3F
1A
Log 97-108
11:40-11:47
1B
Log109-120
11:48-11:4F
2A
Log121-132
11:50-11:57
2B
Log133-144
11:58-11:5F
3A
Log145-156
11:60-11:67
3B
Log157-168
11:68-11:6F
4A
Log169-180
11:70-11:77
4B
Log181-192
11:78-11:7F
1C
Log193-204
11:80-11:87
1D
Log 205-216
11:88-11:8F
2C
Log 217-228
11:90-11:97
2D
Log 229-240
11:98-11:9F
3C
Log 241-252
11:A0-11:A7
3D
Log 253-264
11:A8-11:AF
4C
Log 265-276
11:B0-11:B7
4D
Log 277-288
11:B8-11:BF
12
Table 4 provides the detailed specifications for the storage configuration which uses RAID-10 (2D+2D) groups and 3TB 7.2K disks. Dynamic Provisioning Pool 0 is dedicated for the databases and Dynamic Provisioning Pool 1 is dedicated for the logs. Table 4. Hitachi Unified Storage VM Configuration Details Host
Pool
Port
DPVol
Size (GB)
RAID Level
Description
0
5A/6A
10:00 –10:0B
1980
RAID-10
Databases 1-12
0
5B/6B
10:0C –10:17
1980
RAID-10
Databases 13-24
0
6A/5A
10:18-10:23
1980
RAID-10
Databases 25-36
0
6B/5B
10:24-10:2F
1980
RAID-10
Databases 37-48
0
7A/8A
10:30-10:3B
1980
RAID-10
Databases 49-60
0
7B/8B
10:3C-10:47
1980
RAID-10
Databases 61-72
0
8A/7A
10:48-10:53
1980
RAID-10
Databases 73-84
0
8B/7B
10:54-10:5F
1980
RAID-10
Databases 85-96
0
1A/2A
10:60-10:6B
1980
RAID-10
Databases 97-108
0
1B/2B
10:6C-10:77
1980
RAID-10
Databases 109-120
0
2A/1A
10:78-10:83
1980
RAID-10
Databases 121-132
0
2B/1B
10:84-10:8F
1980
RAID-10
Databases 133-144
0
3A/4A
10:90-10:9B
1980
RAID-10
Databases 145-156
0
3B/4B
10:9C-10:A7
1980
RAID-10
Databases 157-168
0
4A/3A
10:A8-10:B3
1980
RAID-10
Databases 169-180
0
4B/3B
10:B4-10:BF
1980
RAID-10
Databases 181-192
0
1C/2C
10:C0-10:CB
1980
RAID-10
Databases 193-204
0
1D/2D
10:CC-10:D7
1980
RAID-10
Databases 205-216
0
2C/1C
10:D8-10:E3
1980
RAID-10
Databases 217-228
0
2D/1D
10:E4-10:EF
1980
RAID-10
Databases 229-240
0
3C/4C
10:F0-10:FB
1980
RAID-10
Databases 241-252
0
3D/4D
10:FC-11:07
1980
RAID-10
Databases 253-264
0
4C/3C
11:08-11:13
1980
RAID-10
Databases 265-276
0
4D/3D
11:14-11:1F
1980
RAID-10
Databases 277-288
1
5A/6A
11:20-11:2B
198
RAID-10
Log 1-12
1
5B/6B
11:2C-11:37
198
RAID-10
Log 13-24
1
6A/5A
11:38-11:43
198
RAID-10
Log 25-36
1
6B/5B
11:F8-11:FF
198
RAID-10
Log 37-48
1
7A/8A
11:20-11:27
198
RAID-10
Log 49-60
1
7B/8B
11:28-11:2F
198
RAID-10
Log 61-72
1
8A/7A
11:30-11:37
198
RAID-10
Log 73-84
1
8B/7B
11:38-11:3F
198
RAID-10
Log 85-96
1
1A/2A
11:40-11:47
198
RAID-10
Log 97-108
1
1B/2B
11:48-11:4F
198
RAID-10
Log 109-120
CB10
CB11
CB12
CB13
CB14
CB15
CB16
CB17
CB18
CB19
CB20
CB21
CB10
CB11
CB12
CB13
CB14
13
1
2A/1A
11:50-11:57
198
RAID-10
Log 121-132
1
2B/1B
11:58-11:5F
198
RAID-10
Log 133-144
1
3A/4A
11:60-11:67
198
RAID-10
Log 145-156
1
3B/4B
11:68-11:6F
198
RAID-10
Log 157-168
1
4A/3A
11:70-11:77
198
RAID-10
Log 169-180
1
4B/3B
11:78-11:7F
198
RAID-10
Log 181-192
1
1C/2C
11:80-11:87
198
RAID-10
Log 193-204
1
1D/2D
11:88-11:8F
198
RAID-10
Log 205-216
1
2C/1C
11:90-11:97
198
RAID-10
Log 217-228
1
2D/1D
11:98-11:9F
198
RAID-10
Log 229-240
1
3C/4C
11:A0-11:A7
198
RAID-10
Log 241-252
1
3D/4D
11:A8-11:AF
198
RAID-10
Log 253-264
1
4C/3C
11:B0-11:B7
198
RAID-10
Log 265-276
1
4D/3D
11:B8-11:BF
198
RAID-10
Log 277-288
CB15
CB16
CB17
CB18
CB19
CB20
CB21
The ESRP – Storage program focuses on storage solution testing to address performance and reliability issues with storage design. However, storage is not the only factor to take into consideration when designing a scale-up Exchange solution. These factors also affect server scalability:
Server processor utilization
Server physical and virtual memory limitations
Resource requirements for other applications
Directory and network service latencies
Network infrastructure limitations
Replication and recovery requirements
Client usage profiles
These factors are all beyond the scope of the ESRP – Storage program. Therefore, the number of mailboxes hosted per server as part of the tested configuration might not necessarily be viable for some customer deployments. For more information about identifying and addressing performance bottlenecks in an Exchange system, see Microsoft's Troubleshooting Microsoft Exchange Server Performance
14
Targeted Customer Profile This solution is designed for medium to large organizations that plan to consolidate their Exchange Server 2013 storage on high-performance, high-reliability storage systems. This configuration is designed to support 43,200 Exchange users with the following specifications:
Twenty-four Exchange servers (twelve tested, twelve simulated for the database copies)
Twelve database availability groups (DAG) each with two servers (one simulated) and two copies per database
Two Hitachi Unified Storage VM (one tested)
0.25 IOPS per user (0.3 tested for 20 percent growth)
5 GB mailbox size
Mailbox resiliency provides high-availability and used as primary data protection mechanism
Hitachi Unified Storage RAID protection against physical failure or loss
24x7 background database maintenance enabled
15
Test Deployment The following tables summarize the testing environment. Table 5. Simulated Exchange Configuration Number of Exchange mailboxes simulated
43,200
Number of database availability groups (DAGs)
12
Number of servers per DAG
2 (1 simulated)
Number of active mailboxes per server
3,600
Number of databases per host
24
Number of copies per database
2
Number of mailboxes per database
150
Simulated profile: I/Os per second per mailbox (IOPS, include 20% headroom)
0.3
Database LU size
1980 GB
Log LU siz
198 GB
Total database size for performance testing
240,000 GB
% storage capacity used by Exchange database**
41.2%
**Storage performance characteristics change based on the percentage utilization of the individual disks. Tests that use a small percentage of the storage (~25%) might exhibit reduced throughput if the storage capacity utilization is significantly increased beyond what was tested for this paper.
16
Table 6. Storage Hardware Storage connectivity (Fibre Channel, SAS, SATA, iSCSI)
Fibre Channel
Storage model and OS/firmware revision
1 Hitachi Unified Storage VM Firmware: 73-01-32-00 /00 WHQL listing: Hitachi Unified Storage VM
Storage cache
128 GB
Number of storage controllers
1
Number of storage ports
32
Maximum bandwidth of storage connectivity to host
256 Gb/sec (32× 8Gb/sec ports)
Switch type/model/firmware revision
Brocade 5300, Fabric OS v7.0.1b
HBA model and firmware
Emulex LPe1205-HI FW : 1.11X14
Number of HBAs per host
2 dual-ported HBA per host, 2 × 8 Gb/sec port used per HBA
Host server type
Hitachi Compute Blade E55A2 2 × 3.46GHz Intel Xeon Processors, 64 GB memory
Total number of disks tested in solution
480
Maximum number of spindles that can be hosted in the storage
1152
Table 7. Storage Software HBA driver
Storport Miniport 7.2.20.006
HBA QueueTarget setting
0
HBA QueueDepth setting
32
Multipathing
Hitachi Dynamic Link Manager v7.4.0-00
Host OS
Microsoft Windows Server 2008 R2 Enterprise
ESE.dll file version
14.01.0218.012
Replication solution name/version
N/A
17
Table 8. Storage Disk Configuration (Mailbox Store Disks) Disk type, speed and firmware revision
SAS Disk 3TB 7.2K 6F-AD, FD-FD
Raw capacity per disk (GB)
3 TB
Number of physical disks in test
432 (dynamic provisioning pool)
Total raw storage capacity (GB)
1,296,000
Disk slice size (GB)
N/A
Number of slices per LU or number of disks per LU
N/A
RAID level
RAID-10 (2D+2D) at storage level
Total formatted capacity
583,200 GB
Storage capacity utilization
45.0%
Database capacity utilization
44.0%
Table 9. Storage Disk Configuration (Transaction Log Disks) Disk type, speed and firmware revision
SAS Disk 3TB 7.2K 6F-AD, FD-FD
Raw capacity per disk (GB)
3 TB
Number of spindles in test
48 (dynamic provisioning pool)
Total raw storage capacity (GB)
144,000
Disk slice size (GB)
N/A
Number of slices per LU or number of disks per LU
N/A
RAID level
RAID-10 (2D+2D) at storage level
Total formatted capacity
64,800 GB
18
Replication Configuration Table 10. Replication Configuration Replication mechanism
Exchange Server 2013 Database Availability Group (DAG)
Number of links
2
Simulated link distance
N/A
Link type
IP
Link bandwidth
GigE (1Gb/sec)
Table 11. Replicated Storage Hardware Storage connectivity (Fibre Channel, SAS, SATA, iSCSI)
Fibre Channel
Storage model and OS/firmware revision
1 Hitachi Unified Storage VM Firmware: 73-01-3200/00 WHQL listing: Hitachi Unified Storage VM
Storage cache
128 GB
Number of storage controllers
1
Number of storage ports
32
Maximum bandwidth of storage connectivity to host
256 Gb/sec (32 × 8 Gb/sec ports)
Switch type/model/firmware revision
Brocade 5300, Fabric OS v7.0.1b
HBA model and firmware
Emulex LPe1205-HI FW : 1.11X14
Number of HBAs per host
2 dual-ported HBA per host, 2 × 8 Gb/sec port used per HBA
Host server type
Hitachi Compute Blade E55A2 2 × 3.46GHz Intel Xeon Processors, 64 GB memory
Total number of disks tested in solution
480
Maximum number of spindles that can be hosted in the storage
1152
19
Table 12. Replicated Storage Software HBA driver
Storport Miniport 7.2.20.006
HBA QueueTarget setting
0
HBA QueueDepth setting
32
Multipathing
Hitachi Dynamic Link Manager v7.4.0-00
Host OS
Microsoft Windows Server 2008 R2 Enterprise
ESE.dll file version
14.01.0225.017
Replication solution name/version
N/A
Table 13. Replicated Storage Disk Configuration (MailboxStore Disks) Disk type, speed and firmware revision
SAS Disk 3TB 7.2K 6F-AD, FD-FD
Raw capacity per disk (GB)
3 TB
Number of physical disks in test
432 (dynamic provisioning pool)
total raw storage capacity (GB)
1,296,000
Disk slice size (GB)
N/A
Number of slices per LU or number of disks per LU
N/A
Raid level
RAID-10 (2D+2D) at storage level
Total formatted capacity
583,200 GB
Storage capacity utilization
45.0%
Database capacity utilization
44.0%
Table 14. Replicated Storage Disk Configuration (Transactional Log Disks) Disk type, speed and firmware revision
SAS Disk 3TB 7.2K 6F-AD, FD-FD
Raw capacity per disk (GB)
3 TB
Number of spindles in test
48 (dynamic provisioning pool)
Total raw storage capacity (GB)
144,000
Disk slice size (GB)
N/A
Number of slices per LU or number of disks per LU
N/A
Raid level
RAID-10 (2D+2D) at storage level
Total formatted capacity
64,800 GB
20
Best Practices Microsoft Exchange Server 2013 is a disk-intensive application. It presents two distinct workload patterns to the storage, with 32KB random read/write operations to the databases, and sequential write operations of varying size (between 512 bytes up to the log buffer size) to the transaction logs. For this reason, designing an optimal storage configuration can prove challenging in practice. Based on the testing run using the ESRP framework, Hitachi Data Systems recommends these best practices to improve the performance of Hitachi Unified Storage VM running Exchange 2013. For more information about Exchange 2013 best practices for storage design, see the Microsoft TechNet article “Mailbox Server Storage Design.”
Core Storage 1. When formatting a newly partitioned LU, Hitachi Data Systems recommends setting the ALU to 64K for the database files and 4K for the log files. 2. Disk alignment is no longer required when using Microsoft Windows Server 2008. 3. Keep the Exchange workload isolated from other applications. Mixing another I/O intensive application whose workload differs from Exchange can cause the performance for both applications to degrade. 4. Use Hitachi Dynamic Link Manager Multipathing software to provide fault tolerance and high availability for host connectivity. 5. Use Hitachi Dynamic Provisioning to simplify storage management of the Exchange database and log volumes. 6. Due to the difference in I/O patterns, isolate the Exchange database from the log groups. Create a dedicated Hitachi Dynamic Provisioning pool for the databases and a separate pool for the logs. 7. The log LUs should be at least 10 percent of the size of the database LUs. 8. Hitachi Data Systems does not recommend using LU concatenation. 9. Hitachi Data Systems recommends implementing Mailbox Resiliency using the Exchange Server 2013 Database Availability Group feature. 10. Ensure that each DAG maintains at least two database copies to provide high availability. 11. Isolate active databases and their replicated copies in separate dynamic provisioning pools or ensure that they are located on a separate Hitachi Unified Storage VMs. 12. Use fewer, larger LUs for Exchange 2013 databases (up to 2TB) with Background Database Maintenance (24x7) enabled. 13. Size storage solutions for Exchange based primarily on performance criteria. The number of disks, RAID level and percent utilization of each disk directly affect the level of achievable performance. Factor in capacity requirements only after performance is addressed. 14. Disk size is unrelated to performance with regards to IOPS or throughput rates. Disk size is related to the usable capacity of all of the LUs from a RAID group, which is a choice users make.
21
15. The number of spindles, coupled with the RAID level, determines the physical IOPS capacity of the RAID group and all of its LUs. If the disk has too few spindles, the response times grow to large values very quickly.
Storage-based Replication N/A
Backup Strategy N/A
22
Test Results Summary This section provides a high-level summary of the test data from ESRP and the link to the detailed HTML reports that are generated by ESRP testing framework.
Reliability A number of tests in the framework check reliability spanning a 24-hour window. The goal is to verify the storage can handle high I/O load for a long period of time. Following these stress tests, both log and database files are analyzed for integrity to ensure that no database or log corruption occurs.
No errors were reported in the event log file for the storage reliability testing.
No errors were reported for the database and log checksum process.
If done, no errors were reported during the backup to disk test process.
No errors were reported for the database checksum on the remote storage database.
Storage Performance Results Primary storage performance testing exercises the storage with maximum sustainable Exchange type of I/O for two hours. The test shows how long it takes for the storage to respond to an I/O under load. The following data is the sum of all of the logical disk I/Os and average of all the logical disks I/O latency in the two-hour test duration.
Individual Server Metrics These individual server metrics show the sum of the I/O across the storage groups and the average latency across all storage groups on a per-server basis. Table 15. Individual Server Metrics for Exchange Server (CB10) Database I/O Database Disk Transfers Per Second
1574
Database Disk Reads Per Second
1061
Database Disk Writes Per Second
512
Average Database Disk Read Latency (ms)
13.7
Average Database Disk Write Latency (ms)
1.9
Transaction Log I/O Log Disk Writes Per Second
428
Average Log Disk Write Latency (ms)
0.4
23
Table 16. Individual Server Metrics for Exchange Server (CB11) Database I/O Database Disk Transfers Per Second
1374
Database Disk Reads Per Second
927
Database Disk Writes Per Second
447
Average Database Disk Read Latency (ms)
10.5
Average Database Disk Write Latency (ms)
1.3
Transaction Log I/O Log Disk Writes Per Second
377
Average Log Disk Write Latency (ms)
0.4
Table 17. Individual Server Metrics for Exchange Server (CB12) Database I/O Database Disk Transfers Per Second
1359
Database Disk Reads Per Second
916
Database Disk Writes Per Second
497
Average Database Disk Read Latency (ms)
10.5
Average Database Disk Write Latency (ms)
1.3
Transaction Log I/O Log Disk Writes Per Second
371
Average Log Disk Write Latency (ms)
0.4
Table 18. Individual Server Metrics for Exchange Server (CB13) Database I/O Database Disk Transfers Per Second
1367
Database Disk Reads Per Second
923
Database Disk Writes Per Second
444
Average Database Disk Read Latency (ms)
10.6
Average Database Disk Write Latency (ms)
1.3
Transaction Log I/O Log Disk Writes Per Second
373
Average Log Disk Write Latency (ms)
0.4
24
Table 19. Individual Server Metrics for Exchange Server (CB14) Database I/O Database Disk Transfers Per Second
1346
Database Disk Reads Per Second
908
Database Disk Writes Per Second
438
Average Database Disk Read Latency (ms)
11
Average Database Disk Write Latency (ms)
1.5
Transaction Log I/O Log Disk Writes Per Second
368
Average Log Disk Write Latency (ms)
0.6
Table 20. Individual Server Metrics for Exchange Server (CB15) Database I/O Database Disk Transfers Per Second
1340
Database Disk Reads Per Second
905
Database Disk Writes Per Second
436
Average Database Disk Read Latency (ms)
11
Average Database Disk Write Latency (ms)
1.5
Transaction Log I/O Log Disk Writes Per Second
365
Average Log Disk Write Latency (ms)
0.6
Table 21. Individual Server Metrics for Exchange Server (CB16) Database I/O Database Disk Transfers Per Second
1354
Database Disk Reads Per Second
914
Database Disk Writes Per Second
440
Average Database Disk Read Latency (ms)
11.1
Average Database Disk Write Latency (ms)
1.6
Transaction Log I/O Log Disk Writes Per Second
369
Average Log Disk Write Latency (ms)
0.7
25
Table 22. Individual Server Metrics for Exchange Server (CB17) Database I/O Database Disk Transfers Per Second
1333
Database Disk Reads Per Second
900
Database Disk Writes Per Second
433
Average Database Disk Read Latency (ms)
11.1
Average Database Disk Write Latency (ms)
1.5
Transaction Log I/O Log Disk Writes Per Second
363
Average Log Disk Write Latency (ms)
0.7
Table 23. Individual Server Metrics for Exchange Server (CB18) Database I/O Database Disk Transfers Per Second
1327
Database Disk Reads Per Second
895
Database Disk Writes Per Second
432
Average Database Disk Read Latency (ms)
10.9
Average Database Disk Write Latency (ms)
1.6
Transaction Log I/O Log Disk Writes Per Second
362
Average Log Disk Write Latency (ms)
0.6
Table 24. Individual Server Metrics for Exchange Server (CB19) Database I/O Database Disk Transfers Per Second
1313
Database Disk Reads Per Second
886
Database Disk Writes Per Second
426
Average Database Disk Read Latency (ms)
10.9
Average Database Disk Write Latency (ms)
1.6
Transaction Log I/O Log Disk Writes Per Second
359
Average Log Disk Write Latency (ms)
0.6
26
Table 25. Individual Server Metrics for Exchange Server (CB20) Database I/O Database Disk Transfers Per Second
1328
Database Disk Reads Per Second
896
Database Disk Writes Per Second
432
Average Database Disk Read Latency (ms)
11
Average Database Disk Write Latency (ms)
1.6
Transaction Log I/O Log Disk Writes Per Second
362
Average Log Disk Write Latency (ms)
0.7
Table 26. Individual Server Metrics for Exchange Server (CB21) Database I/O Database Disk Transfers Per Second
1325
Database Disk Reads Per Second
894
Database Disk Writes Per Second
431
Average Database Disk Read Latency (ms)
11.1
Average Database Disk Write Latency (ms)
1.8
Transaction Log I/O Log Disk Writes Per Second
361
Average Log Disk Write Latency (ms)
0.8
27
Aggregate Performance Across All Servers Metric The aggregate performance across all server metrics shows the sum of I/O across all servers in the solution and the average latency across all servers in the solution. Table 27. Aggregate Performance for Exchange Server 2013 Database I/O Database Disk Transfers Per Second
16251.04
Database Disk Reads Per Second
10931.36
Database Disk Writes Per Second
5319.67
Average Database Disk Read Latency (ms)
11.14
Average Database Disk Write Latency (ms)
1.54
Transaction Log I/O Log Disk Writes Per Second
4359.13
Average Log Disk Write Latency (ms)
0.58
Database Backup and Recovery Performance This section has two tests: The first measures the sequential read rate of the database files and the second measures recovery/replay performance (playing transaction logs in to the database).
Database Read-only Performance This test measures the maximum rate at which databases can be backed up via VSS. The following tables show the average rate for a single database file. Table 28. Database Read-only Performance MB Read Per Second Per Database
21.20
MB Read Per Second Total Per Server
477.48
Transaction Log Recovery/Replay Performance This test measures the maximum rate at which the log files can be played against the databases. The following table shows the average rate for 500 log files played in a single storage group. Each log file is 1MB in size. Table 29. Transaction Log Recovery/Replay Performance Average Time to Play One Log File (sec)
5.00183
28
Conclusion This document details a tested and robust Exchange Server 2013 Resiliency solution capable of supporting 43,200 users with a 0.3 IOPS per user profile and user mailbox size of 5 GB using twelve DAG’s, each configured with 2 server nodes (one simulated). A Hitachi Unified Storage VM storage system, with 128 GB of cache and twelve 8 Gb/sec Fibre Channel host paths, using Hitachi Dynamic Provisioning (with two pools) and 480 × 3 TB 7.2K RPM SAS disks in a RAID-10 (2D+2D) configuration was used for these tests. Testing confirmed that Hitachi Unified Storage VM is more than capable of delivering the IOPS and capacity requirements needed to support the active and replicated databases for 43,200 Exchange mailboxes configured with the specified user profile, while maintaining additional headroom to support peak throughput. The solution outlined in this document does not include data protection components, such as VSS snapshot or clone backups, and relies on the built-in Mailbox Resiliency features of Exchange Server 2013 coupled with Hitachi Unified Storage VM RAID technology to provide high-availability and protection from logical and physical failures. Adding additional protection requirements may affect performance and capacity requirements of the underlying storage configuration, and as such need to be factored into the storage design accordingly. For more information to about planning Exchange Server 2013 storage architectures for Hitachi Unified Storage VM, see http://www.hds.com/ This document is developed by Hitachi Data Systems and reviewed by the Microsoft Exchange product team. The test results and data presented in this document are based on the tests introduced in the ESRP test framework. Do not quote the data directly for pre-deployment verification. It is still necessary to validate the storage design for a specific customer environment. The ESRP program is not designed to be a benchmarking program; tests do not generate the maximum throughput for a given solution. Rather, it is focused on producing recommendations from vendors for Exchange application. Thus, do not use the data presented in this document for direct comparisons among the solutions
29
Appendix A — Test Reports This appendix contains Jetstress test results for one of the servers used in testing this storage solution. These test results are representative of the results obtained for all of the servers tested.
Performance Test Result: CB10 Test Summary Overall Test Result
Pass
Machine Name
CB10
Test Description Test Start Time
7/4/2013 20:54
Test End Time
7/7/2013 22:16
Collection Start Time
7/4/2013 20:59
Collection End Time
7/4/2013 22:59
Jetstress Version
15.00.0658.004
ESE Version
14.01.0218.012
Operating System
Windows Server 2008 R2 Enterprise Service Pack 1 (6.1.7601.65536)
Performance Log
C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\Performance_2013_7_4_20_54_55.blg
Database Sizing and Throughput Achieved Transactional I/O per Second
1573.694
Target Transactional I/O per Second
1080
Initial Database Size (bytes)
19365602263040
Final Database Size (bytes)
19751553728512
Database Files (Count)
24
30
Jetstress System Parameters Thread Count
42
Minimum Database Cache
768.0 MB
Maximum Database Cache
6144.0 MB
Insert Operations
40%
Delete Operations
20%
Replace Operations
5%
Read Operations
35%
Lazy Commits
70%
Run Background Database Maintenance
TRUE
Number of Copies per Database
2
Database Configuration Instance2548.1
Log path: C:\logluns\log1 Database: C:\dbluns\db1\Jetstress001001.edb
Instance2548.2
Log path: C:\logluns\log2 Database: C:\dbluns\db2\Jetstress002001.edb
Instance2548.3
Log path: C:\logluns\log3 Database: C:\dbluns\db3\Jetstress003001.edb
Instance2548.4
Log path: C:\logluns\log4 Database: C:\dbluns\db4\Jetstress004001.edb
Instance2548.5
Log path: C:\logluns\log5 Database: C:\dbluns\db5\Jetstress005001.edb
Instance2548.6
Log path: C:\logluns\log6 Database: C:\dbluns\db6\Jetstress006001.edb
Instance2548.7
Log path: C:\logluns\log7 Database: C:\dbluns\db7\Jetstress007001.edb
Instance2548.8
Log path: C:\logluns\log8 Database: C:\dbluns\db8\Jetstress008001.edb
Instance2548.9
Log path: C:\logluns\log9 Database: C:\dbluns\db9\Jetstress009001.edb
31
Instance2548.10
Log path: C:\logluns\log10 Database: C:\dbluns\db10\Jetstress010001.edb
Instance2548.11
Log path: C:\logluns\log11 Database: C:\dbluns\db11\Jetstress011001.edb
Instance2548.12
Log path: C:\logluns\log12 Database: C:\dbluns\db12\Jetstress012001.edb
Instance2548.13
Log path: C:\logluns\log13 Database: C:\dbluns\db13\Jetstress013001.edb
Instance2548.14
Log path: C:\logluns\log14 Database: C:\dbluns\db14\Jetstress014001.edb
Instance2548.15
Log path: C:\logluns\log15 Database: C:\dbluns\db15\Jetstress015001.edb
Instance2548.16
Log path: C:\logluns\log16 Database: C:\dbluns\db16\Jetstress016001.edb
Instance2548.17
Log path: C:\logluns\log17 Database: C:\dbluns\db17\Jetstress017001.edb
Instance2548.18
Log path: C:\logluns\log18 Database: C:\dbluns\db18\Jetstress018001.edb
Instance2548.19
Log path: C:\logluns\log19 Database: C:\dbluns\db19\Jetstress019001.edb
Instance2548.20
Log path: C:\logluns\log20 Database: C:\dbluns\db20\Jetstress020001.edb
Instance2548.21
Log path: C:\logluns\log21 Database: C:\dbluns\db21\Jetstress021001.edb
Instance2548.22
Log path: C:\logluns\log22 Database: C:\dbluns\db22\Jetstress022001.edb
Instance2548.23
Log path: C:\logluns\log23 Database: C:\dbluns\db23\Jetstress023001.edb
Instance2548.24
Log path: C:\logluns\log24 Database: C:\dbluns\db24\Jetstress024001.edb
32
Transactional I/O Performance
MSExchange Database ==> Instances
I/O Database Reads Average Latency (msec)
I/O Database Writes Average Latency (msec)
I/O Database Reads/sec
I/O Database Writes/sec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/sec
I/O Log Writes/sec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
13.892
1.039
44.273
21.249
33571.486
36430.645
0.000
0.452
0.000
17.774
0.000
4845.096
Instance2548.2
13.785
1.071
44.052
21.258
33523.455
36391.463
0.000
0.450
0.000
17.803
0.000
4958.942
Instance2548.3
13.747
1.107
44.104
21.310
33598.616
36465.076
0.000
0.456
0.000
18.042
0.000
4894.235
Instance2548.4
13.886
1.156
44.476
21.403
33573.277
36396.138
0.000
0.450
0.000
17.645
0.000
4880.907
Instance2548.5
13.821
1.224
44.073
21.459
33706.039
36422.721
0.000
0.441
0.000
18.080
0.000
4943.444
Instance2548.6
13.687
1.293
44.016
20.916
33547.078
36455.512
0.000
0.451
0.000
17.432
0.000
4980.817
Instance2548.7
13.760
1.383
44.178
21.330
33535.259
36431.712
0.000
0.454
0.000
17.737
0.000
4871.916
Instance2548.8
13.838
1.455
44.471
21.555
33556.992
36352.418
0.000
0.447
0.000
18.000
0.000
4804.639
Instance2548.9
13.647
1.548
44.131
21.243
33606.591
36465.646
0.000
0.451
0.000
17.874
0.000
4876.969
Instance2548.10
13.653
1.649
44.298
21.411
33607.726
36415.223
0.000
0.451
0.000
17.789
0.000
4864.676
Instance2548.11
13.759
1.755
44.286
21.310
33542.147
36444.935
0.000
0.451
0.000
17.737
0.000
4888.816
Instance2548.12
13.765
1.835
44.478
21.381
33565.935
36357.978
0.000
0.450
0.000
17.746
0.000
4807.909
Instance2548.13
13.674
1.941
44.105
21.322
33594.433
36507.041
0.000
0.419
0.000
17.909
0.000
4919.995
Instance2548.14
13.735
2.023
44.392
21.385
33586.034
36373.157
0.000
0.413
0.000
17.777
0.000
4831.041
Instance2548.15
13.759
2.121
44.582
21.526
33480.529
36423.218
0.000
0.416
0.000
17.819
0.000
4815.918
Instance2548.16
13.743
2.196
44.144
21.475
33643.059
36479.852
0.000
0.411
0.000
18.175
0.000
4908.497
Instance2548.17
13.639
2.282
44.088
21.286
33611.997
36465.777
0.000
0.413
0.000
17.928
0.000
4911.073
Instance2548.18
13.658
2.374
44.405
21.517
33630.442
36360.356
0.000
0.415
0.000
17.869
0.000
4848.427
Instance2548.19
13.710
2.470
43.890
21.216
33512.306
36522.187
0.000
0.414
0.000
17.979
0.000
4937.886
Instance2548.20
13.756
2.558
44.383
21.630
33544.729
36328.375
0.000
0.419
0.000
18.018
0.000
4834.210
Instance2548.21
13.545
2.643
44.164
21.352
33621.732
36401.418
0.000
0.412
0.000
17.802
0.000
4900.310
Instance2548.22
13.597
2.721
44.346
21.283
33557.241
36370.456
0.000
0.416
0.000
17.623
0.000
4875.515
Instance2548.23
13.587
2.792
44.079
21.291
33641.558
36471.688
0.000
0.414
0.000
17.801
0.000
4969.129
Instance2548.24
13.695
2.852
43.991
21.182
33537.250
36460.364
0.000
0.408
0.000
17.814
0.000
4911.682
33
Background Database Maintenance I/O Performance MSExchange Database ==> Instances
Database Maintenance IO Reads/sec
Database Maintenance IO Reads Average Bytes
Instance2548.1
31.937
261671.501
Instance2548.2
31.934
261631.153
Instance2548.3
31.952
261725.029
Instance2548.4
31.925
261684.507
Instance2548.5
31.934
261640.057
Instance2548.6
31.950
261686.966
Instance2548.7
31.954
261616.172
Instance2548.8
31.923
261752.645
Instance2548.9
31.958
261651.543
Instance2548.10
31.970
261648.497
Instance2548.11
31.927
261717.109
Instance2548.12
31.929
261670.558
Instance2548.13
31.927
261700.335
Instance2548.14
31.927
261692.885
Instance2548.15
31.920
261706.085
Instance2548.16
31.912
261690.468
Instance2548.17
31.962
261702.265
Instance2548.18
31.943
261715.493
Instance2548.19
31.940
261654.356
Instance2548.20
31.929
261751.029
Instance2548.21
31.964
261650.110
Instance2548.22
31.969
261668.934
Instance2548.23
31.971
261639.465
Instance2548.24
31.956
261643.724
34
Log Replication I/O Performance MSExchange Database ==> Instances
I/O Log Reads/sec
I/O Log Reads Average Bytes
Instance2548.1
0.345
134564.048
Instance2548.2
0.354
138405.300
Instance2548.3
0.353
137489.353
Instance2548.4
0.344
134076.497
Instance2548.5
0.356
139424.911
Instance2548.6
0.348
136012.055
Instance2548.7
0.346
135524.504
Instance2548.8
0.346
135524.504
Instance2548.9
0.349
136455.096
Instance2548.10
0.346
135051.598
Instance2548.11
0.346
135120.056
Instance2548.12
0.341
133574.300
Instance2548.13
0.353
137489.353
Instance2548.14
0.345
134564.048
Instance2548.15
0.344
134549.402
Instance2548.16
0.356
138952.006
Instance2548.17
0.353
137489.353
Instance2548.18
0.346
135051.598
Instance2548.19
0.356
138803.096
Instance2548.20
0.349
136095.158
Instance2548.21
0.349
136026.700
Instance2548.22
0.344
134076.497
Instance2548.23
0.354
137976.904
Instance2548.24
0.350
136514.251
35
Total I/O Performance
MSExchange Database ==> Instances
I/O Databas e Reads Average Latency (msec)
I/O Databas e Writes Average Latency (msec)
I/O Database Reads/se c
I/O Databa se Writes/ sec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/ sec
I/O Log Writes/sec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
13.892
1.039
76.211
21.249
129160.268
36430.645
1.985
0.452
0.345
17.774
134564.048
4845.096
Instance2548.2
13.785
1.071
75.985
21.258
129388.290
36391.463
2.570
0.450
0.354
17.803
138405.300
4958.942
Instance2548.3
13.747
1.107
76.055
21.310
129436.585
36465.076
2.680
0.456
0.353
18.042
137489.353
4894.235
Instance2548.4
13.886
1.156
76.401
21.403
128891.712
36396.138
2.381
0.450
0.344
17.645
134076.497
4880.907
Instance2548.5
13.821
1.224
76.007
21.459
129471.405
36422.721
2.315
0.441
0.356
18.080
139424.911
4943.444
Instance2548.6
13.687
1.293
75.966
20.916
129499.356
36455.512
2.584
0.451
0.348
17.432
136012.055
4980.817
Instance2548.7
13.760
1.383
76.132
21.330
129265.997
36431.712
2.752
0.454
0.346
17.737
135524.504
4871.916
Instance2548.8
13.838
1.455
76.395
21.555
128914.349
36352.418
2.414
0.447
0.346
18.000
135524.504
4804.639
Instance2548.9
13.647
1.548
76.089
21.243
129386.412
36465.646
1.983
0.451
0.349
17.874
136455.096
4876.969
Instance2548.10
13.653
1.649
76.268
21.411
129198.439
36415.223
2.440
0.451
0.346
17.789
135051.598
4864.676
Instance2548.11
13.759
1.755
76.212
21.310
129129.218
36444.935
2.463
0.451
0.346
17.737
135120.056
4888.816
Instance2548.12
13.765
1.835
76.407
21.381
128887.129
36357.978
2.364
0.450
0.341
17.746
133574.300
4807.909
Instance2548.13
13.674
1.941
76.032
21.322
129380.047
36507.041
1.960
0.419
0.353
17.909
137489.353
4919.995
Instance2548.14
13.735
2.023
76.319
21.385
129011.219
36373.157
2.597
0.413
0.345
17.777
134564.048
4831.041
Instance2548.15
13.759
2.121
76.501
21.526
128706.058
36423.218
2.617
0.416
0.344
17.819
134549.402
4815.918
Instance2548.16
13.743
2.196
76.056
21.475
129328.384
36479.852
2.374
0.411
0.356
18.175
138952.006
4908.497
Instance2548.17
13.639
2.282
76.050
21.286
129472.554
36465.777
2.135
0.413
0.353
17.928
137489.353
4911.073
Instance2548.18
13.658
2.374
76.348
21.517
129059.190
36360.356
2.376
0.415
0.346
17.869
135051.598
4848.427
Instance2548.19
13.710
2.470
75.831
21.216
129607.129
36522.187
2.548
0.414
0.356
17.979
138803.096
4937.886
Instance2548.20
13.756
2.558
76.312
21.630
129027.537
36328.375
2.344
0.419
0.349
18.018
136095.158
4834.210
Instance2548.21
13.545
2.643
76.128
21.352
129365.555
36401.418
2.237
0.412
0.349
17.802
136026.700
4900.310
Instance2548.22
13.597
2.721
76.315
21.283
129114.431
36370.456
2.686
0.416
0.344
17.623
134076.497
4875.515
Instance2548.23
13.587
2.792
76.050
21.291
129490.186
36471.688
2.638
0.414
0.354
17.801
137976.904
4969.129
Instance2548.24
13.695
2.852
75.947
21.182
129517.079
36460.364
2.352
0.408
0.350
17.814
136514.251
4911.682
36
Host System Performance Counter
Average
Minimum
Maximum
% Processor Time
1.347
0.361
2.456
Available MBytes
54455.632
54421.000
55080.000
Free System Page Table Entries
33555793.000
33555793.000
33555793.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
95705842.075
95666176.000
95821824.000
Pool Paged Bytes
216199450.778
216150016.000
216252416.000
Database Page Fault Stalls/sec
0.000
0.000
0.000
Test Log 7/4/2013 8:54:04 PM -- Preparing for testing ... 7/4/2013 8:54:29 PM -- Attaching databases ... 7/4/2013 8:54:29 PM -- Preparations for testing are complete. 7/4/2013 8:54:29 PM -- Starting transaction dispatch .. 7/4/2013 8:54:29 PM -- Database cache settings: (minimum: 768.0 MB, maximum: 6.0 GB) 7/4/2013 8:54:29 PM -- Database flush thresholds: (start: 61.4 MB, stop: 122.9 MB) 7/4/2013 8:54:55 PM -- Database read latency thresholds: (average: 20 msec/read, maximum: 100 msec/read). 7/4/2013 8:54:55 PM -- Log write latency thresholds: (average: 10 msec/write, maximum: 100 msec/write). 7/4/2013 8:55:22 PM -- Operation mix: Sessions 42, Inserts 40%, Deletes 20%, Replaces 5%, Reads 35%, Lazy Commits 70%. 7/4/2013 8:55:22 PM -- Performance logging started (interval: 15000 ms). 7/4/2013 8:55:22 PM -- Attaining prerequisites: 7/4/2013 8:59:23 PM -- \MSExchange Database(JetstressWin)\Database Cache Size, Last: 5820097000.0 (lower bound: 5798205000.0, upper bound: none) 7/4/2013 10:59:23 PM -- Performance logging has ended. 7/7/2013 10:16:31 PM -- JetInterop batch transaction stats: 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730 and 1140730. 7/7/2013 10:16:31 PM -- Dispatching transactions ends. 7/7/2013 10:16:31 PM -- Shutting down databases ... 7/7/2013 10:16:35 PM -- Instance2548.1 (complete), Instance2548.2 (complete), Instance2548.3 (complete), Instance2548.4 (complete), Instance2548.5 (complete), Instance2548.6 (complete), Instance2548.7 (complete), Instance2548.8 (complete), Instance2548.9 (complete), Instance2548.10 (complete), Instance2548.11 (complete), Instance2548.12 (complete), Instance2548.13 (complete), Instance2548.14 (complete),
37
Instance2548.15 (complete), Instance2548.16 (complete), Instance2548.17 (complete), Instance2548.18 (complete), Instance2548.19 (complete), Instance2548.20 (complete), Instance2548.21 (complete), Instance2548.22 (complete), Instance2548.23 (complete) and Instance2548.24 (complete) 7/7/2013 10:16:35 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\Performance_2013_7_4_20_54_55.blg has 493 samples. 7/7/2013 10:16:35 PM -- Creating test report ... 7/7/2013 10:16:47 PM -- Instance2548.1 has 13.9 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.1 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.1 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.2 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.2 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.2 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.3 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.3 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.3 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.4 has 13.9 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.4 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.4 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.5 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.5 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.5 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.6 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.6 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.6 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.7 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.7 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.7 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.8 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.8 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.8 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.9 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.9 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.9 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.10 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.10 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.10 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.11 has 13.8 for I/O Database Reads Average Latency. 38
7/7/2013 10:16:47 PM -- Instance2548.11 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.11 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.12 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.12 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.12 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.13 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.13 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.13 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.14 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.14 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.14 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.15 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.15 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.15 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.16 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.16 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.16 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.17 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.17 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.17 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.18 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.18 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.18 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.19 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.19 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.19 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.20 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.20 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.20 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.21 has 13.5 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.21 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.21 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.22 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.22 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.22 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.23 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.23 has 0.4 for I/O Log Writes Average Latency. 39
7/7/2013 10:16:47 PM -- Instance2548.23 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.24 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.24 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.24 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Test has 0 Maximum Database Page Fault Stalls/sec. 7/7/2013 10:16:47 PM -- The test has 0 Database Page Fault Stalls/sec samples higher than 0. 7/7/2013 10:16:47 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\Performance_2013_7_4_20_54_55.xml has 477 samples queried.
40
Performance Test Database Checksums Result: CB10 Checksum Statistics - All Database
Seen pages
Bad pages
Correctable pages
Wrong page-number pages
File length / seconds taken
C:\dbluns\db1\Jetstress001001.edb
25115186
0
0
0
784849 MB/6690 sec
C:\dbluns\db2\Jetstress002001.edb
25115186
0
0
0
784849 MB/6752 sec
C:\dbluns\db3\Jetstress003001.edb
25115442
0
0
0
784857 MB/6754 sec
C:\dbluns\db4\Jetstress004001.edb
25115954
0
0
0
784873 MB/6690 sec
C:\dbluns\db5\Jetstress005001.edb
25114674
0
0
0
784833 MB/6745 sec
C:\dbluns\db6\Jetstress006001.edb
25114930
0
0
0
784841 MB/6754 sec
C:\dbluns\db7\Jetstress007001.edb
25114674
0
0
0
784833 MB/6684 sec
C:\dbluns\db8\Jetstress008001.edb
25115698
0
0
0
784865 MB/6676 sec
C:\dbluns\db9\Jetstress009001.edb
25115186
0
0
0
784849 MB/6683 sec
C:\dbluns\db10\Jetstress010001.edb
25115186
0
0
0
784849 MB/6669 sec
C:\dbluns\db11\Jetstress011001.edb
25115698
0
0
0
784865 MB/6675 sec
C:\dbluns\db12\Jetstress012001.edb
25115442
0
0
0
784857 MB/6673 sec
C:\dbluns\db13\Jetstress013001.edb
25115954
0
0
0
784873 MB/6446 sec
C:\dbluns\db14\Jetstress014001.edb
25115442
0
0
0
784857 MB/6443 sec
C:\dbluns\db15\Jetstress015001.edb
25114930
0
0
0
784841 MB/6390 sec
C:\dbluns\db16\Jetstress016001.edb
25115442
0
0
0
784857 MB/6441 sec
C:\dbluns\db17\Jetstress017001.edb
25115442
0
0
0
784857 MB/6422 sec
C:\dbluns\db18\Jetstress018001.edb
25115698
0
0
0
784865 MB/6396 sec
C:\dbluns\db19\Jetstress019001.edb
25116978
0
0
0
784905 MB/6349 sec
C:\dbluns\db20\Jetstress020001.edb
25115698
0
0
0
784865 MB/6394 sec
C:\dbluns\db21\Jetstress021001.edb
25115442
0
0
0
784857 MB/6383 sec
C:\dbluns\db22\Jetstress022001.edb
25115698
0
0
0
784865 MB/6356 sec
C:\dbluns\db23\Jetstress023001.edb
25114674
0
0
0
784833 MB/6354 sec
C:\dbluns\db24\Jetstress024001.edb
25114930
0
0
0
784841 MB/6378 sec
(Sum)
602769584
0
0
0
18836549 MB/6754 sec
41
Disk Subsystem Performance (of checksum) LogicalDisk
Avg. Disk sec/Read
Avg. Disk sec/Write
Disk Reads/sec
Disk Writes/sec
Avg. Disk Bytes/Read
C:\dbluns\db1
0.008
0.000
1879.611
0.000
65536.000
C:\dbluns\db2
0.008
0.000
1859.274
0.000
65536.000
C:\dbluns\db3
0.008
0.000
1857.420
0.000
65536.000
C:\dbluns\db4
0.008
0.000
1879.377
0.000
65536.000
C:\dbluns\db5
0.008
0.000
1862.815
0.000
65536.000
C:\dbluns\db6
0.008
0.000
1858.001
0.000
65536.000
C:\dbluns\db7
0.008
0.000
1881.569
0.000
65536.000
C:\dbluns\db8
0.008
0.000
1884.679
0.000
65536.000
C:\dbluns\db9
0.008
0.000
1882.225
0.000
65536.000
C:\dbluns\db10
0.008
0.000
1885.791
0.000
65536.000
C:\dbluns\db11
0.008
0.000
1884.647
0.000
65536.000
C:\dbluns\db12
0.008
0.000
1885.571
0.000
65536.000
C:\dbluns\db13
0.008
0.000
1948.090
0.000
65536.000
C:\dbluns\db14
0.008
0.000
1950.095
0.000
65536.000
C:\dbluns\db15
0.008
0.000
1970.108
0.000
65536.000
C:\dbluns\db16
0.008
0.000
1949.798
0.000
65536.000
C:\dbluns\db17
0.008
0.000
1953.941
0.000
65536.000
C:\dbluns\db18
0.008
0.000
1961.621
0.000
65536.000
C:\dbluns\db19
0.008
0.000
1980.962
0.000
65536.000
C:\dbluns\db20
0.008
0.000
1961.039
0.000
65536.000
C:\dbluns\db21
0.008
0.000
1967.152
0.000
65536.000
C:\dbluns\db22
0.008
0.000
1973.002
0.000
65536.000
C:\dbluns\db23
0.008
0.000
1973.455
0.000
65536.000
C:\dbluns\db24
0.008
0.000
1965.467
0.000
65536.000
42
Memory System Performance (of checksum) Counter
Average
Minimum
Maximum
% Processor Time
9.622
2.891
11.073
Available MBytes
60496.710
60480.000
60523.000
Free System Page Table Entries
33555792.996
33555792.000
33555793.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
98348544.000
97906688.000
98775040.000
Pool Paged Bytes
217641984.000
217640960.000
217669632.000
Test Log 7/4/2013 8:54:04 PM -- Preparing for testing ... 7/4/2013 8:54:29 PM -- Attaching databases ... 7/4/2013 8:54:29 PM -- Preparations for testing are complete. 7/4/2013 8:54:29 PM -- Starting transaction dispatch .. 7/4/2013 8:54:29 PM -- Database cache settings: (minimum: 768.0 MB, maximum: 6.0 GB) 7/4/2013 8:54:29 PM -- Database flush thresholds: (start: 61.4 MB, stop: 122.9 MB) 7/4/2013 8:54:55 PM -- Database read latency thresholds: (average: 20 msec/read, maximum: 100 msec/read). 7/4/2013 8:54:55 PM -- Log write latency thresholds: (average: 10 msec/write, maximum: 100 msec/write). 7/4/2013 8:55:22 PM -- Operation mix: Sessions 42, Inserts 40%, Deletes 20%, Replaces 5%, Reads 35%, Lazy Commits 70%. 7/4/2013 8:55:22 PM -- Performance logging started (interval: 15000 ms). 7/4/2013 8:55:22 PM -- Attaining prerequisites: 7/4/2013 8:59:23 PM -- \MSExchange Database(JetstressWin)\Database Cache Size, Last: 5820097000.0 (lower bound: 5798205000.0, upper bound: none) 7/4/2013 10:59:23 PM -- Performance logging has ended. 7/7/2013 10:16:31 PM -- JetInterop batch transaction stats: 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140731, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730, 1140730 and 1140730. 7/7/2013 10:16:31 PM -- Dispatching transactions ends. 7/7/2013 10:16:31 PM -- Shutting down databases ... 7/7/2013 10:16:35 PM -- Instance2548.1 (complete), Instance2548.2 (complete), Instance2548.3 (complete), Instance2548.4 (complete), Instance2548.5 (complete), Instance2548.6 (complete), Instance2548.7 (complete), Instance2548.8 (complete), Instance2548.9 (complete), Instance2548.10 (complete), Instance2548.11 (complete), Instance2548.12 (complete), Instance2548.13 (complete), Instance2548.14 (complete), Instance2548.15 (complete), Instance2548.16 (complete), Instance2548.17 (complete), Instance2548.18 (complete), Instance2548.19 (complete), Instance2548.20 (complete), Instance2548.21 (complete), Instance2548.22 (complete), Instance2548.23 (complete) and Instance2548.24 43
(complete) 7/7/2013 10:16:35 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\Performance_2013_7_4_20_54_55.blg has 493 samples. 7/7/2013 10:16:35 PM -- Creating test report ... 7/7/2013 10:16:47 PM -- Instance2548.1 has 13.9 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.1 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.1 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.2 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.2 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.2 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.3 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.3 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.3 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.4 has 13.9 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.4 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.4 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.5 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.5 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.5 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.6 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.6 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.6 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.7 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.7 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.7 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.8 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.8 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.8 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.9 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.9 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.9 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.10 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.10 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.10 has 0.5 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.11 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.11 has 0.5 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.11 has 0.5 for I/O Log Reads Average Latency. 44
7/7/2013 10:16:47 PM -- Instance2548.12 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.12 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.12 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.13 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.13 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.13 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.14 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.14 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.14 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.15 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.15 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.15 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.16 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.16 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.16 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.17 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.17 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.17 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.18 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.18 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.18 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.19 has 13.7 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.19 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.19 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.20 has 13.8 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.20 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.20 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.21 has 13.5 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.21 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.21 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.22 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.22 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.22 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.23 has 13.6 for I/O Database Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.23 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.23 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.24 has 13.7 for I/O Database Reads Average Latency. 45
7/7/2013 10:16:47 PM -- Instance2548.24 has 0.4 for I/O Log Writes Average Latency. 7/7/2013 10:16:47 PM -- Instance2548.24 has 0.4 for I/O Log Reads Average Latency. 7/7/2013 10:16:47 PM -- Test has 0 Maximum Database Page Fault Stalls/sec. 7/7/2013 10:16:47 PM -- The test has 0 Database Page Fault Stalls/sec samples higher than 0. 7/7/2013 10:16:47 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\Performance_2013_7_4_20_54_55.xml has 477 samples queried. 7/7/2013 10:16:47 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\Performance_2013_7_4_20_54_55.html was saved. 7/7/2013 10:16:48 PM -- Performance logging started (interval: 30000 ms). 7/7/2013 10:16:48 PM -- Verifying database checksums ... 7/8/2013 12:09:23 AM -- C:\dbluns\db1 (100% processed), C:\dbluns\db2 (100% processed), C:\dbluns\db3 (100% processed), C:\dbluns\db4 (100% processed), C:\dbluns\db5 (100% processed), C:\dbluns\db6 (100% processed), C:\dbluns\db7 (100% processed), C:\dbluns\db8 (100% processed), C:\dbluns\db9 (100% processed), C:\dbluns\db10 (100% processed), C:\dbluns\db11 (100% processed), C:\dbluns\db12 (100% processed), C:\dbluns\db13 (100% processed), C:\dbluns\db14 (100% processed), C:\dbluns\db15 (100% processed), C:\dbluns\db16 (100% processed), C:\dbluns\db17 (100% processed), C:\dbluns\db18 (100% processed), C:\dbluns\db19 (100% processed), C:\dbluns\db20 (100% processed), C:\dbluns\db21 (100% processed), C:\dbluns\db22 (100% processed), C:\dbluns\db23 (100% processed) and C:\dbluns\db24 (100% processed) 7/8/2013 12:09:23 AM -- Performance logging has ended. 7/8/2013 12:09:23 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Performance Test\DBChecksum_2013_7_7_22_16_47.blg has 224 samples.
46
Stress Test Result: CB10 Test Summary Overall Test Result
Pass
Machine Name
CB10
Test Description Test Start Time
7/8/2013 12:19:34 AM
Test End Time
7/9/2013 2:34:58 AM
Collection Start Time
7/8/2013 12:24:54 AM
Collection End Time
7/9/2013 12:24:49 AM
Jetstress Version
15.00.0658.004
ESE Version
14.01.0218.012
Operating System
Windows Server 2008 R2 Enterprise Service Pack 1 (6.1.7601.65536)
Performance Log
C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\Stress_2013_7_8_0_20_25.blg
Database Sizing and Throughput Achieved Transactional I/O per Second
1559.999
Target Transactional I/O per Second
1080
Initial Database Size (bytes)
19751553728512
Final Database Size (bytes)
19803277885440
Database Files (Count)
24
47
Jetstress System Parameters Thread Count
42
Minimum Database Cache
768.0 MB
Maximum Database Cache
6144.0 MB
Insert Operations
40%
Delete Operations
20%
Replace Operations
5%
Read Operations
35%
Lazy Commits
70%
Run Background Database Maintenance
True
Number of Copies per Database
2
48
Database Configuration Instance2548.1
Log path: C:\logluns\log1 Database: C:\dbluns\db1\Jetstress001001.edb
Instance2548.2
Log path: C:\logluns\log2 Database: C:\dbluns\db2\Jetstress002001.edb
Instance2548.3
Log path: C:\logluns\log3 Database: C:\dbluns\db3\Jetstress003001.edb
Instance2548.4
Log path: C:\logluns\log4 Database: C:\dbluns\db4\Jetstress004001.edb
Instance2548.5
Log path: C:\logluns\log5 Database: C:\dbluns\db5\Jetstress005001.edb
Instance2548.6
Log path: C:\logluns\log6 Database: C:\dbluns\db6\Jetstress006001.edb
Instance2548.7
Log path: C:\logluns\log7 Database: C:\dbluns\db7\Jetstress007001.edb
Instance2548.8
Log path: C:\logluns\log8 Database: C:\dbluns\db8\Jetstress008001.edb
Instance2548.9
Log path: C:\logluns\log9 Database: C:\dbluns\db9\Jetstress009001.edb
Instance2548.10
Log path: C:\logluns\log10 Database: C:\dbluns\db10\Jetstress010001.edb
Instance2548.11
Log path: C:\logluns\log11 Database: C:\dbluns\db11\Jetstress011001.edb
Instance2548.12
Log path: C:\logluns\log12 Database: C:\dbluns\db12\Jetstress012001.edb
Instance2548.13
Log path: C:\logluns\log13 Database: C:\dbluns\db13\Jetstress013001.edb
Instance2548.14
Log path: C:\logluns\log14 Database: C:\dbluns\db14\Jetstress014001.edb
Instance2548.15
Log path: C:\logluns\log15 Database: C:\dbluns\db15\Jetstress015001.edb
Instance2548.16
Log path: C:\logluns\log16 Database: C:\dbluns\db16\Jetstress016001.edb
Instance2548.17
Log path: C:\logluns\log17 Database: C:\dbluns\db17\Jetstress017001.edb
49
Instance2548.18
Log path: C:\logluns\log18 Database: C:\dbluns\db18\Jetstress018001.edb
Instance2548.19
Log path: C:\logluns\log19 Database: C:\dbluns\db19\Jetstress019001.edb
Instance2548.20
Log path: C:\logluns\log20 Database: C:\dbluns\db20\Jetstress020001.edb
Instance2548.21
Log path: C:\logluns\log21 Database: C:\dbluns\db21\Jetstress021001.edb
Instance2548.22
Log path: C:\logluns\log22 Database: C:\dbluns\db22\Jetstress022001.edb
Instance2548.23
Log path: C:\logluns\log23 Database: C:\dbluns\db23\Jetstress023001.edb
Instance2548.24
Log path: C:\logluns\log24 Database: C:\dbluns\db24\Jetstress024001.edb
50
Transactional I/O Performance
MSExchange Database ==> Instances
I/O Database Reads Average Latency (msec)
I/O Database Writes Average Latency (msec)
I/O Database Reads/sec
I/O Database Writes/sec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/sec
I/O Log Writes/sec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
13.977
1.020
43.562
21.389
33585.445
35097.989
0.000
0.443
0.000
16.984
0.000
4873.539
Instance2548.2
13.932
1.056
43.610
21.354
33607.125
35092.521
0.000
0.443
0.000
16.955
0.000
4851.512
Instance2548.3
13.921
1.096
43.550
21.354
33590.498
35083.214
0.000
0.444
0.000
16.962
0.000
4866.616
Instance2548.4
13.845
1.170
43.592
21.319
33597.696
35106.095
0.000
0.447
0.000
16.893
0.000
4865.471
Instance2548.5
13.844
1.219
43.648
21.428
33613.848
35088.410
0.000
0.443
0.000
17.002
0.000
4845.131
Instance2548.6
13.893
1.292
43.608
21.307
33586.261
35065.931
0.000
0.443
0.000
16.856
0.000
4863.797
Instance2548.7
13.880
1.370
43.618
21.404
33603.598
35082.997
0.000
0.442
0.000
16.984
0.000
4852.617
Instance2548.8
13.790
1.483
43.644
21.388
33602.501
35069.334
0.000
0.443
0.000
16.929
0.000
4860.736
Instance2548.9
13.766
1.557
43.559
21.344
33622.326
35092.313
0.000
0.445
0.000
16.941
0.000
4873.938
Instance2548.10
13.842
1.661
43.581
21.339
33592.454
35075.894
0.000
0.444
0.000
16.958
0.000
4854.407
Instance2548.11
13.746
1.758
43.628
21.373
33593.354
35067.151
0.000
0.443
0.000
16.971
0.000
4842.184
Instance2548.12
13.768
1.863
43.703
21.483
33622.139
35077.983
0.000
0.443
0.000
16.986
0.000
4865.097
Instance2548.13
13.809
1.931
43.590
21.369
33588.420
35089.680
0.000
0.407
0.000
16.965
0.000
4870.181
Instance2548.14
13.808
2.015
43.614
21.364
33617.329
35074.863
0.000
0.406
0.000
16.951
0.000
4858.527
Instance2548.15
13.680
2.103
43.678
21.454
33591.658
35074.475
0.000
0.405
0.000
17.017
0.000
4842.561
Instance2548.16
13.752
2.205
43.592
21.398
33621.105
35098.971
0.000
0.409
0.000
16.994
0.000
4873.477
Instance2548.17
13.703
2.280
43.591
21.336
33608.035
35079.329
0.000
0.406
0.000
16.892
0.000
4870.295
Instance2548.18
13.780
2.371
43.713
21.420
33599.637
35062.242
0.000
0.405
0.000
16.932
0.000
4833.968
Instance2548.19
13.705
2.456
43.681
21.345
33618.358
35061.918
0.000
0.407
0.000
16.899
0.000
4838.764
Instance2548.20
13.729
2.557
43.616
21.373
33597.496
35080.173
0.000
0.408
0.000
16.910
0.000
4859.030
Instance2548.21
13.725
2.638
43.632
21.345
33584.987
35077.464
0.000
0.406
0.000
16.914
0.000
4861.063
Instance2548.22
13.721
2.719
43.603
21.371
33571.627
35086.979
0.000
0.405
0.000
16.932
0.000
4863.017
Instance2548.23
13.678
2.787
43.656
21.376
33610.566
35086.679
0.000
0.407
0.000
16.874
0.000
4866.402
Instance2548.24
13.675
2.859
43.639
21.459
33605.979
35082.415
0.000
0.410
0.000
16.977
0.000
4870.124
51
Background Database Maintenance I/O Performance MSExchange Database ==> Instances
Database Maintenance IO Reads/sec
Database Maintenance IO Reads Average Bytes
Instance2548.1
32.003
261588.608
Instance2548.2
31.966
261597.029
Instance2548.3
31.964
261604.900
Instance2548.4
31.979
261604.589
Instance2548.5
31.982
261608.156
Instance2548.6
31.970
261589.147
Instance2548.7
31.967
261604.106
Instance2548.8
31.986
261593.930
Instance2548.9
31.972
261607.852
Instance2548.10
31.966
261596.210
Instance2548.11
32.005
261588.966
Instance2548.12
31.997
261591.094
Instance2548.13
31.975
261584.167
Instance2548.14
31.990
261592.409
Instance2548.15
31.991
261578.708
Instance2548.16
31.990
261600.143
Instance2548.17
31.994
261593.184
Instance2548.18
31.986
261608.622
Instance2548.19
32.007
261596.659
Instance2548.20
31.986
261584.046
Instance2548.21
31.994
261612.373
Instance2548.22
31.994
261609.050
Instance2548.23
32.010
261593.549
Instance2548.24
32.009
261612.563
52
Log Replication I/O Performance MSExchange Database ==> Instances
I/O Log Reads/sec
I/O Log Reads Average Bytes
Instance2548.1
0.331
129328.882
Instance2548.2
0.329
128566.034
Instance2548.3
0.330
128867.118
Instance2548.4
0.329
128255.043
Instance2548.5
0.329
128321.149
Instance2548.6
0.327
127732.041
Instance2548.7
0.330
128850.011
Instance2548.8
0.329
128619.504
Instance2548.9
0.330
128783.277
Instance2548.10
0.329
128471.555
Instance2548.11
0.329
128488.858
Instance2548.12
0.330
128921.456
Instance2548.13
0.330
128767.943
Instance2548.14
0.329
128340.988
Instance2548.15
0.329
128378.639
Instance2548.16
0.331
129078.078
Instance2548.17
0.329
128351.172
Instance2548.18
0.327
127860.725
Instance2548.19
0.327
127557.479
Instance2548.20
0.329
128389.924
Instance2548.21
0.329
128200.540
Instance2548.22
0.329
128728.184
Instance2548.23
0.328
128099.558
Instance2548.24
0.331
129240.975
53
Total I/O Performance
MSExchange Database ==> Instances
I/O Database Reads Average Latency (msec)
I/O Database Writes Average Latency (msec)
I/O Databas e Reads/s ec
I/O Databas e Writes/s ec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/s ec
I/O Log Writes/s ec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
13.977
1.020
75.565
21.389
130148.665
35097.989
2.100
0.443
0.331
16.984
129328.882
4873.539
Instance2548.2
13.932
1.056
75.576
21.354
130039.757
35092.521
2.884
0.443
0.329
16.955
128566.034
4851.512
Instance2548.3
13.921
1.096
75.514
21.354
130104.672
35083.214
2.390
0.444
0.330
16.962
128867.118
4866.616
Instance2548.4
13.845
1.170
75.570
21.319
130081.939
35106.095
2.299
0.447
0.329
16.893
128255.043
4865.471
Instance2548.5
13.844
1.219
75.631
21.428
130026.577
35088.410
1.971
0.443
0.329
17.002
128321.149
4845.131
Instance2548.6
13.893
1.292
75.578
21.307
130032.204
35065.931
2.491
0.443
0.327
16.856
127732.041
4863.797
Instance2548.7
13.880
1.370
75.585
21.404
130031.140
35082.997
2.441
0.442
0.330
16.984
128850.011
4852.617
Instance2548.8
13.790
1.483
75.630
21.388
130027.068
35069.334
2.403
0.443
0.329
16.929
128619.504
4860.736
Instance2548.9
13.766
1.557
75.531
21.344
130127.274
35092.313
1.975
0.445
0.330
16.941
128783.277
4873.938
Instance2548.10
13.842
1.661
75.548
21.339
130067.326
35075.894
2.713
0.444
0.329
16.958
128471.555
4854.407
Instance2548.11
13.746
1.758
75.633
21.373
130071.590
35067.151
2.427
0.443
0.329
16.971
128488.858
4842.184
Instance2548.12
13.768
1.863
75.700
21.483
129981.061
35077.983
2.414
0.443
0.330
16.986
128921.456
4865.097
Instance2548.13
13.809
1.931
75.565
21.369
130064.900
35089.680
1.880
0.407
0.330
16.965
128767.943
4870.181
Instance2548.14
13.808
2.015
75.604
21.364
130080.046
35074.863
2.551
0.406
0.329
16.951
128340.988
4858.527
Instance2548.15
13.680
2.103
75.669
21.454
129978.501
35074.475
2.614
0.405
0.329
17.017
128378.639
4842.561
Instance2548.16
13.752
2.205
75.582
21.398
130113.365
35098.971
2.389
0.409
0.331
16.994
129078.078
4873.477
Instance2548.17
13.703
2.280
75.586
21.336
130111.045
35079.329
2.076
0.406
0.329
16.892
128351.172
4870.295
Instance2548.18
13.780
2.371
75.698
21.420
129942.551
35062.242
2.648
0.405
0.327
16.932
127860.725
4833.968
Instance2548.19
13.705
2.456
75.688
21.345
130026.045
35061.918
2.497
0.407
0.327
16.899
127557.479
4838.764
Instance2548.20
13.729
2.557
75.602
21.373
130054.757
35080.173
2.316
0.408
0.329
16.910
128389.924
4859.030
Instance2548.21
13.725
2.638
75.626
21.345
130051.866
35077.464
1.985
0.406
0.329
16.914
128200.540
4861.063
Instance2548.22
13.721
2.719
75.597
21.371
130081.472
35086.979
2.615
0.405
0.329
16.932
128728.184
4863.017
Instance2548.23
13.678
2.787
75.666
21.376
130057.814
35086.679
2.437
0.407
0.328
16.874
128099.558
4866.402
Instance2548.24
13.675
2.859
75.648
21.459
130083.088
35082.415
2.309
0.410
0.331
16.977
129240.975
4870.124
54
Host System Performance Counter
Average
Minimum
Maximum
% Processor Time
1.374
0.000
4.869
Available MBytes
54078.853
53828.000
54697.000
Free System Page Table Entries
33555792.997
33555789.000
33555795.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
96137228.156
96071680.000
96448512.000
Pool Paged Bytes
218059329.073
216035328.000
225943552.000
Database Page Fault Stalls/sec
0.000
0.000
0.000
Test Log 7/8/2013 12:19:34 AM -- Preparing for testing ... 7/8/2013 12:19:58 AM -- Attaching databases ... 7/8/2013 12:19:58 AM -- Preparations for testing are complete. 7/8/2013 12:19:58 AM -- Starting transaction dispatch .. 7/8/2013 12:19:58 AM -- Database cache settings: (minimum: 768.0 MB, maximum: 6.0 GB) 7/8/2013 12:19:58 AM -- Database flush thresholds: (start: 61.4 MB, stop: 122.9 MB) 7/8/2013 12:20:25 AM -- Database read latency thresholds: (average: 20 msec/read, maximum: 200 msec/read). 7/8/2013 12:20:25 AM -- Log write latency thresholds: (average: 10 msec/write, maximum: 200 msec/write). 7/8/2013 12:20:54 AM -- Operation mix: Sessions 42, Inserts 40%, Deletes 20%, Replaces 5%, Reads 35%, Lazy Commits 70%. 7/8/2013 12:20:54 AM -- Performance logging started (interval: 15000 ms). 7/8/2013 12:20:54 AM -- Attaining prerequisites: 7/8/2013 12:24:54 AM -- \MSExchange Database(JetstressWin)\Database Cache Size, Last: 5803463000.0 (lower bound: 5798205000.0, upper bound: none) 7/9/2013 12:24:54 AM -- Performance logging has ended. 7/9/2013 2:34:43 AM -- JetInterop batch transaction stats: 151319, 151319, 151319, 151319, 151319, 151319, 151319, 151319, 151319, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318 and 151318. 7/9/2013 2:34:43 AM -- Dispatching transactions ends. 7/9/2013 2:34:45 AM -- Shutting down databases ... 7/9/2013 2:34:58 AM -- Instance2548.1 (complete), Instance2548.2 (complete), Instance2548.3 (complete), Instance2548.4 (complete), Instance2548.5 (complete), Instance2548.6 (complete), Instance2548.7 (complete), Instance2548.8 (complete), Instance2548.9 (complete),
55
Instance2548.10 (complete), Instance2548.11 (complete), Instance2548.12 (complete), Instance2548.13 (complete), Instance2548.14 (complete), Instance2548.15 (complete), Instance2548.16 (complete), Instance2548.17 (complete), Instance2548.18 (complete), Instance2548.19 (complete), Instance2548.20 (complete), Instance2548.21 (complete), Instance2548.22 (complete), Instance2548.23 (complete) and Instance2548.24 (complete) 7/9/2013 2:34:58 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\Stress_2013_7_8_0_20_25.blg has 5743 samples. 7/9/2013 2:34:58 AM -- Creating test report ... 7/9/2013 2:37:48 AM -- Instance2548.1 has 14.0 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.1 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.1 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.2 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.2 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.2 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.3 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.3 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.3 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.4 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.4 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.4 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.5 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.5 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.5 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.6 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.6 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.6 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.7 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.7 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.7 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.8 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.8 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.8 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.9 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.9 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.9 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.10 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.10 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.10 has 0.4 for I/O Log Reads Average Latency. 56
7/9/2013 2:37:48 AM -- Instance2548.11 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.11 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.11 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.12 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.12 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.12 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.13 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.13 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.13 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.14 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.14 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.14 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.15 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.15 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.15 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.16 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.16 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.16 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.17 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.17 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.17 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.18 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.18 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.18 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.19 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.19 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.19 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.20 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.20 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.20 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.21 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.21 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.21 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.22 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.22 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.22 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.23 has 13.7 for I/O Database Reads Average Latency. 57
7/9/2013 2:37:48 AM -- Instance2548.23 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.23 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.24 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.24 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.24 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Test has 0 Maximum Database Page Fault Stalls/sec. 7/9/2013 2:37:48 AM -- The test has 0 Database Page Fault Stalls/sec samples higher than 0. 7/9/2013 2:37:48 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\Stress_2013_7_8_0_20_25.xml has 5727 samples queried.
58
Stress Test Database Checksums Result: CB10 Checksum Statistics - All Database
Seen pages
Bad pages
Correctable pages
Wrong page-number pages
File length / seconds taken
C:\dbluns\db1\Jetstress001001.edb
25181234
0
0
0
786913 MB/22240 sec
C:\dbluns\db2\Jetstress002001.edb
25180978
0
0
0
786905 MB/22213 sec
C:\dbluns\db3\Jetstress003001.edb
25181490
0
0
0
786921 MB/22191 sec
C:\dbluns\db4\Jetstress004001.edb
25181490
0
0
0
786921 MB/22125 sec
C:\dbluns\db5\Jetstress005001.edb
25180722
0
0
0
786897 MB/22279 sec
C:\dbluns\db6\Jetstress006001.edb
25180210
0
0
0
786881 MB/22253 sec
C:\dbluns\db7\Jetstress007001.edb
25180722
0
0
0
786897 MB/22207 sec
C:\dbluns\db8\Jetstress008001.edb
25181490
0
0
0
786921 MB/22135 sec
C:\dbluns\db9\Jetstress009001.edb
25181234
0
0
0
786913 MB/22153 sec
C:\dbluns\db10\Jetstress010001.edb
25180978
0
0
0
786905 MB/22263 sec
C:\dbluns\db11\Jetstress011001.edb
25181234
0
0
0
786913 MB/22126 sec
C:\dbluns\db12\Jetstress012001.edb
25181234
0
0
0
786913 MB/22094 sec
C:\dbluns\db13\Jetstress013001.edb
25182002
0
0
0
786937 MB/21425 sec
C:\dbluns\db14\Jetstress014001.edb
25181490
0
0
0
786921 MB/21418 sec
C:\dbluns\db15\Jetstress015001.edb
25180722
0
0
0
786897 MB/21435 sec
C:\dbluns\db16\Jetstress016001.edb
25181490
0
0
0
786921 MB/21371 sec
C:\dbluns\db17\Jetstress017001.edb
25181234
0
0
0
786913 MB/21414 sec
C:\dbluns\db18\Jetstress018001.edb
25180978
0
0
0
786905 MB/21440 sec
C:\dbluns\db19\Jetstress019001.edb
25182258
0
0
0
786945 MB/21416 sec
C:\dbluns\db20\Jetstress020001.edb
25181490
0
0
0
786921 MB/21369 sec
C:\dbluns\db21\Jetstress021001.edb
25180978
0
0
0
786905 MB/21415 sec
C:\dbluns\db22\Jetstress022001.edb
25181490
0
0
0
786921 MB/21442 sec
C:\dbluns\db23\Jetstress023001.edb
25180210
0
0
0
786881 MB/21360 sec
C:\dbluns\db24\Jetstress024001.edb
25180722
0
0
0
786897 MB/21311 sec
(Sum)
604348080
0
0
0
18885877 MB/22279 sec
59
Disk Subsystem Performance (of checksum) LogicalDisk
Avg. Disk sec/Read
Avg. Disk sec/Write
Disk Reads/sec
Disk Writes/sec
Avg. Disk Bytes/Read
C:\dbluns\db1
0.028
0.000
564.285
0.000
65536.000
C:\dbluns\db2
0.028
0.000
565.268
0.000
65536.000
C:\dbluns\db3
0.028
0.000
566.099
0.000
65536.000
C:\dbluns\db4
0.027
0.000
568.647
0.000
65536.000
C:\dbluns\db5
0.028
0.000
562.632
0.000
65536.000
C:\dbluns\db6
0.028
0.000
565.715
0.000
65536.000
C:\dbluns\db7
0.028
0.000
566.098
0.000
65536.000
C:\dbluns\db8
0.027
0.000
568.724
0.000
65536.000
C:\dbluns\db9
0.027
0.000
567.920
0.000
65536.000
C:\dbluns\db10
0.028
0.000
564.495
0.000
65536.000
C:\dbluns\db11
0.027
0.000
568.573
0.000
65536.000
C:\dbluns\db12
0.027
0.000
569.461
0.000
65536.000
C:\dbluns\db13
0.027
0.000
586.657
0.000
65536.000
C:\dbluns\db14
0.027
0.000
587.523
0.000
65536.000
C:\dbluns\db15
0.027
0.000
585.417
0.000
65536.000
C:\dbluns\db16
0.027
0.000
588.541
0.000
65536.000
C:\dbluns\db17
0.027
0.000
587.827
0.000
65536.000
C:\dbluns\db18
0.027
0.000
585.262
0.000
65536.000
C:\dbluns\db19
0.027
0.000
587.675
0.000
65536.000
C:\dbluns\db20
0.027
0.000
588.595
0.000
65536.000
C:\dbluns\db21
0.027
0.000
587.819
0.000
65536.000
C:\dbluns\db22
0.027
0.000
587.142
0.000
65536.000
C:\dbluns\db23
0.027
0.000
589.179
0.000
65536.000
C:\dbluns\db24
0.026
0.000
590.307
0.000
65536.000
60
Memory System Performance (of checksum) Counter
Average
Minimum
Maximum
% Processor Time
3.037
1.729
5.468
Available MBytes
60442.254
60340.000
60470.000
Free System Page Table Entries
33555792.887
33555699.000
33555795.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
98945855.914
98324480.000
103473152.000
Pool Paged Bytes
227037045.808
225992704.000
234721280.000
Test Log 7/8/2013 12:19:34 AM -- Preparing for testing ... 7/8/2013 12:19:58 AM -- Attaching databases ... 7/8/2013 12:19:58 AM -- Preparations for testing are complete. 7/8/2013 12:19:58 AM -- Starting transaction dispatch .. 7/8/2013 12:19:58 AM -- Database cache settings: (minimum: 768.0 MB, maximum: 6.0 GB) 7/8/2013 12:19:58 AM -- Database flush thresholds: (start: 61.4 MB, stop: 122.9 MB) 7/8/2013 12:20:25 AM -- Database read latency thresholds: (average: 20 msec/read, maximum: 200 msec/read). 7/8/2013 12:20:25 AM -- Log write latency thresholds: (average: 10 msec/write, maximum: 200 msec/write). 7/8/2013 12:20:54 AM -- Operation mix: Sessions 42, Inserts 40%, Deletes 20%, Replaces 5%, Reads 35%, Lazy Commits 70%. 7/8/2013 12:20:54 AM -- Performance logging started (interval: 15000 ms). 7/8/2013 12:20:54 AM -- Attaining prerequisites: 7/8/2013 12:24:54 AM -- \MSExchange Database(JetstressWin)\Database Cache Size, Last: 5803463000.0 (lower bound: 5798205000.0, upper bound: none) 7/9/2013 12:24:54 AM -- Performance logging has ended. 7/9/2013 2:34:43 AM -- JetInterop batch transaction stats: 151319, 151319, 151319, 151319, 151319, 151319, 151319, 151319, 151319, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318, 151318 and 151318. 7/9/2013 2:34:43 AM -- Dispatching transactions ends. 7/9/2013 2:34:45 AM -- Shutting down databases ... 7/9/2013 2:34:58 AM -- Instance2548.1 (complete), Instance2548.2 (complete), Instance2548.3 (complete), Instance2548.4 (complete), Instance2548.5 (complete), Instance2548.6 (complete), Instance2548.7 (complete), Instance2548.8 (complete), Instance2548.9 (complete), Instance2548.10 (complete), Instance2548.11 (complete), Instance2548.12 (complete), Instance2548.13 (complete), Instance2548.14 (complete), 61
Instance2548.15 (complete), Instance2548.16 (complete), Instance2548.17 (complete), Instance2548.18 (complete), Instance2548.19 (complete), Instance2548.20 (complete), Instance2548.21 (complete), Instance2548.22 (complete), Instance2548.23 (complete) and Instance2548.24 (complete) 7/9/2013 2:34:58 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\Stress_2013_7_8_0_20_25.blg has 5743 samples. 7/9/2013 2:34:58 AM -- Creating test report ... 7/9/2013 2:37:48 AM -- Instance2548.1 has 14.0 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.1 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.1 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.2 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.2 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.2 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.3 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.3 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.3 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.4 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.4 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.4 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.5 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.5 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.5 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.6 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.6 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.6 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.7 has 13.9 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.7 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.7 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.8 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.8 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.8 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.9 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.9 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.9 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.10 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.10 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.10 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.11 has 13.7 for I/O Database Reads Average Latency. 62
7/9/2013 2:37:48 AM -- Instance2548.11 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.11 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.12 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.12 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.12 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.13 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.13 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.13 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.14 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.14 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.14 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.15 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.15 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.15 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.16 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.16 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.16 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.17 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.17 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.17 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.18 has 13.8 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.18 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.18 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.19 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.19 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.19 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.20 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.20 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.20 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.21 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.21 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.21 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.22 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.22 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.22 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.23 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.23 has 0.4 for I/O Log Writes Average Latency. 63
7/9/2013 2:37:48 AM -- Instance2548.23 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.24 has 13.7 for I/O Database Reads Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.24 has 0.4 for I/O Log Writes Average Latency. 7/9/2013 2:37:48 AM -- Instance2548.24 has 0.4 for I/O Log Reads Average Latency. 7/9/2013 2:37:48 AM -- Test has 0 Maximum Database Page Fault Stalls/sec. 7/9/2013 2:37:48 AM -- The test has 0 Database Page Fault Stalls/sec samples higher than 0. 7/9/2013 2:37:48 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\Stress_2013_7_8_0_20_25.xml has 5727 samples queried. 7/9/2013 2:37:49 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\Stress_2013_7_8_0_20_25.html was saved. 7/9/2013 2:37:50 AM -- Performance logging started (interval: 30000 ms). 7/9/2013 2:37:50 AM -- Verifying database checksums ... 7/9/2013 8:49:09 AM -- C:\dbluns\db1 (100% processed), C:\dbluns\db2 (100% processed), C:\dbluns\db3 (100% processed), C:\dbluns\db4 (100% processed), C:\dbluns\db5 (100% processed), C:\dbluns\db6 (100% processed), C:\dbluns\db7 (100% processed), C:\dbluns\db8 (100% processed), C:\dbluns\db9 (100% processed), C:\dbluns\db10 (100% processed), C:\dbluns\db11 (100% processed), C:\dbluns\db12 (100% processed), C:\dbluns\db13 (100% processed), C:\dbluns\db14 (100% processed), C:\dbluns\db15 (100% processed), C:\dbluns\db16 (100% processed), C:\dbluns\db17 (100% processed), C:\dbluns\db18 (100% processed), C:\dbluns\db19 (100% processed), C:\dbluns\db20 (100% processed), C:\dbluns\db21 (100% processed), C:\dbluns\db22 (100% processed), C:\dbluns\db23 (100% processed) and C:\dbluns\db24 (100% processed) 7/9/2013 8:49:09 AM -- Performance logging has ended. 7/9/2013 8:49:09 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Stress Test\DBChecksum_2013_7_9_2_37_49.blg has 741 samples
64
Backup Test Result: CB10 Database Backup Statistics - All Database Instance
Database Size (MBytes)
Elapsed Backup Time
MBytes Transferred/sec
Instance2548.1
786905.59
06:14:15
35.04
Instance2548.2
786897.59
06:12:40
35.19
Instance2548.3
786913.59
06:14:43
35.00
Instance2548.4
786913.59
06:11:39
35.29
Instance2548.5
786889.59
06:12:35
35.20
Instance2548.6
786873.59
06:13:31
35.11
Instance2548.7
786889.59
06:12:13
35.23
Instance2548.8
786913.59
06:12:35
35.20
Instance2548.9
786905.59
06:14:25
35.03
Instance2548.10
786897.59
06:13:34
35.11
Instance2548.11
786905.59
06:14:11
35.05
Instance2548.12
786905.59
06:13:13
35.14
Instance2548.13
786929.59
05:54:38
36.98
Instance2548.14
786913.59
05:54:21
37.01
Instance2548.15
786889.59
05:53:41
37.08
Instance2548.16
786913.59
05:54:37
36.98
Instance2548.17
786905.59
05:53:56
37.05
Instance2548.18
786897.59
05:54:18
37.02
Instance2548.19
786937.59
05:52:32
37.20
Instance2548.20
786913.59
05:51:24
37.32
Instance2548.21
786897.59
05:53:50
37.06
Instance2548.22
786913.59
05:51:53
37.27
Instance2548.23
786873.59
05:54:14
37.02
Instance2548.24
786889.59
05:53:43
37.08
65
Jetstress System Parameters Thread Count
42
Minimum Database Cache
768.0 MB
Maximum Database Cache
6144.0 MB
Insert Operations
40%
Delete Operations
20%
Replace Operations
5%
Read Operations
35%
Lazy Commits
70%
Database Configuration Instance2548.1
Log path: C:\logluns\log1 Database: C:\dbluns\db1\Jetstress001001.edb
Instance2548.2
Log path: C:\logluns\log2 Database: C:\dbluns\db2\Jetstress002001.edb
Instance2548.3
Log path: C:\logluns\log3 Database: C:\dbluns\db3\Jetstress003001.edb
Instance2548.4
Log path: C:\logluns\log4 Database: C:\dbluns\db4\Jetstress004001.edb
Instance2548.5
Log path: C:\logluns\log5 Database: C:\dbluns\db5\Jetstress005001.edb
Instance2548.6
Log path: C:\logluns\log6 Database: C:\dbluns\db6\Jetstress006001.edb
Instance2548.7
Log path: C:\logluns\log7 Database: C:\dbluns\db7\Jetstress007001.edb
Instance2548.8
Log path: C:\logluns\log8 Database: C:\dbluns\db8\Jetstress008001.edb
Instance2548.9
Log path: C:\logluns\log9 Database: C:\dbluns\db9\Jetstress009001.edb
Instance2548.10
Log path: C:\logluns\log10 Database: C:\dbluns\db10\Jetstress010001.edb
Instance2548.11
Log path: C:\logluns\log11
66
Database: C:\dbluns\db11\Jetstress011001.edb Instance2548.12
Log path: C:\logluns\log12 Database: C:\dbluns\db12\Jetstress012001.edb
Instance2548.13
Log path: C:\logluns\log13 Database: C:\dbluns\db13\Jetstress013001.edb
Instance2548.14
Log path: C:\logluns\log14 Database: C:\dbluns\db14\Jetstress014001.edb
Instance2548.15
Log path: C:\logluns\log15 Database: C:\dbluns\db15\Jetstress015001.edb
Instance2548.16
Log path: C:\logluns\log16 Database: C:\dbluns\db16\Jetstress016001.edb
Instance2548.17
Log path: C:\logluns\log17 Database: C:\dbluns\db17\Jetstress017001.edb
Instance2548.18
Log path: C:\logluns\log18 Database: C:\dbluns\db18\Jetstress018001.edb
Instance2548.19
Log path: C:\logluns\log19 Database: C:\dbluns\db19\Jetstress019001.edb
Instance2548.20
Log path: C:\logluns\log20 Database: C:\dbluns\db20\Jetstress020001.edb
Instance2548.21
Log path: C:\logluns\log21 Database: C:\dbluns\db21\Jetstress021001.edb
Instance2548.22
Log path: C:\logluns\log22 Database: C:\dbluns\db22\Jetstress022001.edb
Instance2548.23
Log path: C:\logluns\log23 Database: C:\dbluns\db23\Jetstress023001.edb
Instance2548.24
Log path: C:\logluns\log24 Database: C:\dbluns\db24\Jetstress024001.edb
67
Transactional I/O Performance
MSExchange Database ==> Instances
I/O Database Reads Average Latency (msec)
I/O Database Writes Average Latency (msec)
I/O Database Reads/sec
I/O Database Writes/sec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/sec
I/O Log Writes/sec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
14.093
0.000
140.160
0.000
262143.986
0.000
0.000
0.000
0.000
0.000
0.000
0.686
Instance2548.2
13.650
0.000
140.555
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.3
13.839
0.000
139.412
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.4
13.578
0.000
141.068
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.5
13.632
0.000
140.640
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.6
13.724
0.000
140.242
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.7
13.591
0.000
140.794
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.8
13.617
0.000
140.661
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.9
13.771
0.000
139.859
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.10
13.708
0.000
140.144
0.000
262143.995
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.11
13.756
0.000
139.675
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.12
13.708
0.000
140.191
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.13
12.962
0.000
147.450
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.14
12.932
0.000
147.927
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.15
12.903
0.000
148.099
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.16
12.933
0.000
147.461
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.17
12.940
0.000
148.101
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.18
12.931
0.000
147.993
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.19
12.830
0.000
148.664
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.20
12.791
0.000
149.241
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.21
12.920
0.000
148.209
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.22
12.819
0.000
149.040
0.000
262144.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.23
12.909
0.000
148.083
0.000
262143.985
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Instance2548.24
12.882
0.000
148.299
0.000
262143.972
0.000
0.000
0.007
0.000
0.000
0.000
0.726
68
Host System Performance Counter
Average
Minimum
Maximum
% Processor Time
2.056
0.681
3.628
Available MBytes
60420.700
60404.000
60424.000
Free System Page Table Entries
33555793.008
33555793.000
33555795.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
97009609.167
96948224.000
97071104.000
Pool Paged Bytes
228833491.106
228581376.000
229007360.000
Database Page Fault Stalls/sec
0.000
0.000
0.000
Test Log 7/10/2013 9:49:17 PM -- Preparing for testing ... 7/10/2013 9:49:42 PM -- Attaching databases ... 7/10/2013 9:49:42 PM -- Preparations for testing are complete. 7/10/2013 9:50:15 PM -- Performance logging started (interval: 30000 ms). 7/10/2013 9:50:15 PM -- Backing up databases ... 7/11/2013 4:04:58 AM -- Performance logging has ended. 7/11/2013 4:04:58 AM -- Instance2548.1 (100% processed), Instance2548.2 (100% processed), Instance2548.3 (100% processed), Instance2548.4 (100% processed), Instance2548.5 (100% processed), Instance2548.6 (100% processed), Instance2548.7 (100% processed), Instance2548.8 (100% processed), Instance2548.9 (100% processed), Instance2548.10 (100% processed), Instance2548.11 (100% processed), Instance2548.12 (100% processed), Instance2548.13 (100% processed), Instance2548.14 (100% processed), Instance2548.15 (100% processed), Instance2548.16 (100% processed), Instance2548.17 (100% processed), Instance2548.18 (100% processed), Instance2548.19 (100% processed), Instance2548.20 (100% processed), Instance2548.21 (100% processed), Instance2548.22 (100% processed), Instance2548.23 (100% processed) and Instance2548.24 (100% processed) 7/11/2013 4:04:58 AM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Database Backup\DatabaseBackup_2013_7_10_21_49_42.blg has 747 samples. 7/11/2013 4:04:58 AM -- Creating test report ...
69
Soft Recovery Test Result: CB10 Soft-Recovery Statistics - All Database Instance
Log files replayed
Elapsed seconds
Instance2548.1
508
2560.7756978
Instance2548.2
505
2554.4108866
Instance2548.3
504
2537.4380568
Instance2548.4
501
2528.9516419
Instance2548.5
506
2545.1288703
Instance2548.6
505
2527.6256396
Instance2548.7
504
2533.9904507
Instance2548.8
503
2548.5764764
Instance2548.9
505
2548.5764764
Instance2548.10
512
2547.5156745
Instance2548.11
506
2545.9244717
Instance2548.12
506
2550.4328796
Instance2548.13
502
2535.5816535
Instance2548.14
507
2548.8416768
Instance2548.15
501
2542.4768656
Instance2548.16
506
2532.1340475
Instance2548.17
505
2535.0512526
Instance2548.18
509
2544.5984694
Instance2548.19
505
2548.0460754
Instance2548.20
506
2550.1676792
Instance2548.21
508
2544.5984694
Instance2548.22
511
2540.0900615
Instance2548.23
506
2549.9024787
Instance2548.24
508
2544.5984694
70
Database Configuration Instance2548.1
Log path: C:\logluns\log1 Database: C:\dbluns\db1\Jetstress001001.edb
Instance2548.2
Log path: C:\logluns\log2 Database: C:\dbluns\db2\Jetstress002001.edb
Instance2548.3
Log path: C:\logluns\log3 Database: C:\dbluns\db3\Jetstress003001.edb
Instance2548.4
Log path: C:\logluns\log4 Database: C:\dbluns\db4\Jetstress004001.edb
Instance2548.5
Log path: C:\logluns\log5 Database: C:\dbluns\db5\Jetstress005001.edb
Instance2548.6
Log path: C:\logluns\log6 Database: C:\dbluns\db6\Jetstress006001.edb
Instance2548.7
Log path: C:\logluns\log7 Database: C:\dbluns\db7\Jetstress007001.edb
Instance2548.8
Log path: C:\logluns\log8 Database: C:\dbluns\db8\Jetstress008001.edb
Instance2548.9
Log path: C:\logluns\log9 Database: C:\dbluns\db9\Jetstress009001.edb
Instance2548.10
Log path: C:\logluns\log10 Database: C:\dbluns\db10\Jetstress010001.edb
Instance2548.11
Log path: C:\logluns\log11 Database: C:\dbluns\db11\Jetstress011001.edb
Instance2548.12
Log path: C:\logluns\log12 Database: C:\dbluns\db12\Jetstress012001.edb
Instance2548.13
Log path: C:\logluns\log13 Database: C:\dbluns\db13\Jetstress013001.edb
Instance2548.14
Log path: C:\logluns\log14 Database: C:\dbluns\db14\Jetstress014001.edb
Instance2548.15
Log path: C:\logluns\log15 Database: C:\dbluns\db15\Jetstress015001.edb
Instance2548.16
Log path: C:\logluns\log16 Database: C:\dbluns\db16\Jetstress016001.edb
Instance2548.17
Log path: C:\logluns\log17 Database: C:\dbluns\db17\Jetstress017001.edb
71
Instance2548.18
Log path: C:\logluns\log18 Database: C:\dbluns\db18\Jetstress018001.edb
Instance2548.19
Log path: C:\logluns\log19 Database: C:\dbluns\db19\Jetstress019001.edb
Instance2548.20
Log path: C:\logluns\log20 Database: C:\dbluns\db20\Jetstress020001.edb
Instance2548.21
Log path: C:\logluns\log21 Database: C:\dbluns\db21\Jetstress021001.edb
Instance2548.22
Log path: C:\logluns\log22 Database: C:\dbluns\db22\Jetstress022001.edb
Instance2548.23
Log path: C:\logluns\log23 Database: C:\dbluns\db23\Jetstress023001.edb
Instance2548.24
Log path: C:\logluns\log24 Database: C:\dbluns\db24\Jetstress024001.edb
72
Transactional I/O Performance
MSExchange Database ==> Instances
I/O Databas e Reads Average Latency (msec)
I/O Database Writes Average Latency (msec)
I/O Databas e Reads/s ec
I/O Databas e Writes/s ec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/sec
I/O Log Writes/s ec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
28.327
0.663
112.205
1.188
39168.443
26162.387
1.390
0.001
1.782
0.001
185250.217
0.813
Instance2548.2
27.980
0.799
111.616
1.180
39063.484
26036.994
1.094
0.000
1.770
0.000
184451.326
0.000
Instance2548.3
28.065
0.580
112.230
1.188
38933.112
26466.462
1.389
0.000
1.782
0.000
186409.062
0.000
Instance2548.4
28.169
0.539
112.345
1.184
38898.245
25814.019
1.149
0.000
1.776
0.000
183207.831
0.000
Instance2548.5
28.029
0.815
111.280
1.191
38970.335
26172.524
1.298
0.001
1.787
0.001
185582.518
0.818
Instance2548.6
27.977
0.531
111.634
1.196
38966.742
26235.473
1.456
0.001
1.794
0.001
185825.086
0.823
Instance2548.7
28.052
0.614
112.599
1.192
38975.978
25982.973
1.193
0.001
1.788
0.001
184042.806
0.822
Instance2548.8
27.989
0.546
112.609
1.182
39184.209
25973.997
1.008
0.004
1.773
0.001
183859.030
0.817
Instance2548.9
28.023
0.755
111.462
1.184
39222.548
26026.258
1.195
0.000
1.777
0.000
183563.478
0.000
Instance2548.10
27.953
0.663
110.836
1.203
39110.486
26287.566
1.330
0.001
1.807
0.002
186544.544
0.817
Instance2548.11
28.048
0.575
111.758
1.189
38864.930
25963.144
1.243
0.000
1.783
0.000
184240.013
0.000
Instance2548.12
27.950
0.704
111.418
1.187
39125.847
25817.212
1.250
0.000
1.780
0.000
182859.580
0.000
Instance2548.13
28.027
0.871
111.781
1.185
38936.704
25993.846
1.334
0.001
1.778
0.001
182672.957
0.821
Instance2548.14
27.918
0.583
111.218
1.189
39116.899
25921.735
1.153
0.000
1.784
0.000
183488.118
0.000
Instance2548.15
28.152
0.558
112.289
1.179
39054.855
25847.398
1.220
0.000
1.768
0.000
182985.758
0.000
Instance2548.16
28.032
0.589
112.391
1.194
38943.687
26351.152
1.336
0.000
1.791
0.000
186296.044
0.000
Instance2548.17
28.005
0.457
111.386
1.192
38958.648
26351.152
1.435
0.000
1.788
0.000
186699.106
0.000
Instance2548.18
27.985
0.517
111.505
1.196
39166.001
26172.524
1.251
0.000
1.794
0.000
185752.219
0.000
Instance2548.19
28.014
0.569
112.513
1.187
39097.951
26078.520
1.269
0.001
1.780
0.001
184755.078
0.817
Instance2548.20
27.923
0.599
110.777
1.187
39173.089
26130.781
1.287
0.000
1.780
0.000
184702.997
0.000
Instance2548.21
27.877
0.926
111.271
1.196
39001.090
26120.179
1.226
0.001
1.794
0.001
185009.210
0.818
Instance2548.22
27.879
0.479
111.267
1.205
38799.683
26371.686
1.376
0.001
1.807
0.001
186430.660
0.819
Instance2548.23
28.004
0.467
110.688
1.187
38994.874
26078.520
1.113
0.000
1.780
0.000
184745.507
0.000
Instance2548.24
27.924
0.701
112.134
1.193
38854.655
26172.524
1.204
0.000
1.790
0.000
185092.791
0.000
73
Background Database Maintenance I/O Performance MSExchange Database ==> Instances
Database Maintenance IO Reads/sec
Database Maintenance IO Reads Average Bytes
Instance2548.1
32.070
261708.270
Instance2548.2
32.050
261733.573
Instance2548.3
32.036
261720.886
Instance2548.4
32.037
261706.173
Instance2548.5
32.023
261618.894
Instance2548.6
32.038
261685.797
Instance2548.7
32.032
261642.387
Instance2548.8
32.034
261744.409
Instance2548.9
32.021
261817.090
Instance2548.10
32.040
261728.219
Instance2548.11
32.046
261693.718
Instance2548.12
32.032
261729.788
Instance2548.13
32.041
261554.101
Instance2548.14
32.034
261759.809
Instance2548.15
32.034
261714.838
Instance2548.16
32.025
261723.887
Instance2548.17
32.027
261804.880
Instance2548.18
32.049
261717.176
Instance2548.19
32.045
261706.898
Instance2548.20
32.038
261737.444
Instance2548.21
32.046
261711.269
Instance2548.22
32.038
261786.417
Instance2548.23
32.051
261673.458
Instance2548.24
32.040
261776.570
74
Total I/O Performance
MSExchange Database ==> Instances
I/O Databas e Reads Average Latency (msec)
I/O Databas e Writes Average Latency (msec)
I/O Databas e Reads/s ec
I/O Databas e Writes/s ec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/sec
I/O Log Writes/ sec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
28.327
0.663
144.275
1.188
88635.604
26162.387
1.390
0.001
1.782
0.001
185250.217
0.813
Instance2548.2
27.980
0.799
143.666
1.180
88737.944
26036.994
1.094
0.000
1.770
0.000
184451.326
0.000
Instance2548.3
28.065
0.580
144.266
1.188
88405.831
26466.462
1.389
0.000
1.782
0.000
186409.062
0.000
Instance2548.4
28.169
0.539
144.382
1.184
88337.266
25814.019
1.149
0.000
1.776
0.000
183207.831
0.000
Instance2548.5
28.029
0.815
143.303
1.191
88723.572
26172.524
1.298
0.001
1.787
0.001
185582.518
0.818
Instance2548.6
27.977
0.531
143.672
1.196
88632.141
26235.473
1.456
0.001
1.794
0.001
185825.086
0.823
Instance2548.7
28.052
0.614
144.631
1.192
88290.811
25982.973
1.193
0.001
1.788
0.001
184042.806
0.822
Instance2548.8
27.989
0.546
144.643
1.182
88473.966
25973.997
1.008
0.004
1.773
0.001
183859.030
0.817
Instance2548.9
28.023
0.755
143.483
1.184
88898.338
26026.258
1.195
0.000
1.777
0.000
183563.478
0.000
Instance2548.10
27.953
0.663
142.877
1.203
89032.919
26287.566
1.330
0.001
1.807
0.002
186544.544
0.817
Instance2548.11
28.048
0.575
143.804
1.189
88521.541
25963.144
1.243
0.000
1.783
0.000
184240.013
0.000
Instance2548.12
27.950
0.704
143.451
1.187
88833.193
25817.212
1.250
0.000
1.780
0.000
182859.580
0.000
Instance2548.13
28.027
0.871
143.822
1.185
88532.565
25993.846
1.334
0.001
1.778
0.001
182672.957
0.821
Instance2548.14
27.918
0.583
143.252
1.189
88903.813
25921.735
1.153
0.000
1.784
0.000
183488.118
0.000
Instance2548.15
28.152
0.558
144.324
1.179
88476.980
25847.398
1.220
0.000
1.768
0.000
182985.758
0.000
Instance2548.16
28.032
0.589
144.416
1.194
88346.729
26351.152
1.336
0.000
1.791
0.000
186296.044
0.000
Instance2548.17
28.005
0.457
143.413
1.192
88724.488
26351.152
1.435
0.000
1.788
0.000
186699.106
0.000
Instance2548.18
27.985
0.517
143.555
1.196
88851.763
26172.524
1.251
0.000
1.794
0.000
185752.219
0.000
Instance2548.19
28.014
0.569
144.558
1.187
88444.418
26078.520
1.269
0.001
1.780
0.001
184755.078
0.817
Instance2548.20
27.923
0.599
142.815
1.187
89102.014
26130.781
1.287
0.000
1.780
0.000
184702.997
0.000
Instance2548.21
27.877
0.926
143.317
1.196
88799.361
26120.179
1.226
0.001
1.794
0.001
185009.210
0.818
Instance2548.22
27.879
0.479
143.304
1.205
88651.852
26371.686
1.376
0.001
1.807
0.001
186430.660
0.819
Instance2548.23
28.004
0.467
142.739
1.187
88996.204
26078.520
1.113
0.000
1.780
0.000
184745.507
0.000
Instance2548.24
27.924
0.701
144.174
1.193
88394.698
26172.524
1.204
0.000
1.790
0.000
185092.791
0.000
75
Host System Performance Counter
Average
Minimum
Maximum
% Processor Time
1.652
0.000
4.262
Available MBytes
54194.577
54052.000
59592.000
Free System Page Table Entries
33555793.010
33555792.000
33555795.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
97243369.686
97193984.000
97746944.000
Pool Paged Bytes
232546680.494
232480768.000
232611840.000
Database Page Fault Stalls/sec
0.000
0.000
0.000
Test Log 7/11/2013 6:59:37 PM -- Preparing for testing ... 7/11/2013 7:00:01 PM -- Attaching databases ... 7/11/2013 7:00:01 PM -- Preparations for testing are complete. 7/11/2013 7:00:01 PM -- Starting transaction dispatch .. 7/11/2013 7:00:01 PM -- Database cache settings: (minimum: 768.0 MB, maximum: 6.0 GB) 7/11/2013 7:00:01 PM -- Database flush thresholds: (start: 61.4 MB, stop: 122.9 MB) 7/11/2013 7:00:28 PM -- Database read latency thresholds: (average: 20 msec/read, maximum: 100 msec/read). 7/11/2013 7:00:28 PM -- Log write latency thresholds: (average: 10 msec/write, maximum: 100 msec/write). 7/11/2013 7:00:42 PM -- Operation mix: Sessions 42, Inserts 40%, Deletes 20%, Replaces 5%, Reads 35%, Lazy Commits 70%. 7/11/2013 7:00:42 PM -- Performance logging started (interval: 15000 ms). 7/11/2013 7:00:42 PM -- Generating log files ... 7/11/2013 10:06:00 PM -- C:\logluns\log1 (101.6% generated), C:\logluns\log2 (101.0% generated), C:\logluns\log3 (100.8% generated), C:\logluns\log4 (100.2% generated), C:\logluns\log5 (101.2% generated), C:\logluns\log6 (101.0% generated), C:\logluns\log7 (100.8% generated), C:\logluns\log8 (100.6% generated), C:\logluns\log9 (101.0% generated), C:\logluns\log10 (102.4% generated), C:\logluns\log11 (101.2% generated), C:\logluns\log12 (101.2% generated), C:\logluns\log13 (100.4% generated), C:\logluns\log14 (101.4% generated), C:\logluns\log15 (100.2% generated), C:\logluns\log16 (101.2% generated), C:\logluns\log17 (101.0% generated), C:\logluns\log18 (101.8% generated), C:\logluns\log19 (101.0% generated), C:\logluns\log20 (101.2% generated), C:\logluns\log21 (101.6% generated), C:\logluns\log22 (102.2% generated), C:\logluns\log23 (101.2% generated) and C:\logluns\log24 (101.6% generated) 7/11/2013 10:06:00 PM -- Performance logging has ended. 7/11/2013 10:06:00 PM -- JetInterop batch transaction stats: 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22130, 22130, 22130, 22130, 22130, 22130 and 22130. 7/11/2013 10:06:00 PM -- Dispatching transactions ends. 7/11/2013 10:06:00 PM -- Shutting down databases ... 7/11/2013 10:06:03 PM -- Instance2548.1 (complete), Instance2548.2 (complete), Instance2548.3 (complete), Instance2548.4 (complete), 76
Instance2548.5 (complete), Instance2548.6 (complete), Instance2548.7 (complete), Instance2548.8 (complete), Instance2548.9 (complete), Instance2548.10 (complete), Instance2548.11 (complete), Instance2548.12 (complete), Instance2548.13 (complete), Instance2548.14 (complete), Instance2548.15 (complete), Instance2548.16 (complete), Instance2548.17 (complete), Instance2548.18 (complete), Instance2548.19 (complete), Instance2548.20 (complete), Instance2548.21 (complete), Instance2548.22 (complete), Instance2548.23 (complete) and Instance2548.24 (complete) 7/11/2013 10:06:03 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\Performance_2013_7_11_19_0_28.blg has 738 samples. 7/11/2013 10:06:03 PM -- Creating test report ... 7/11/2013 10:06:13 PM -- Instance2548.1 has 19.4 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.1 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.1 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.2 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.2 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.2 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.3 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.3 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.3 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.4 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.4 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.4 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.5 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.5 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.5 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.6 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.6 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.6 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.7 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.7 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.7 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.8 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.8 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.8 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.9 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.9 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.9 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.10 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.10 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.10 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.11 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.11 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.11 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.12 has 19.2 for I/O Database Reads Average Latency. 77
7/11/2013 10:06:13 PM -- Instance2548.12 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.12 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.13 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.13 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.13 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.14 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.14 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.14 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.15 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.15 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.15 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.16 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.16 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.16 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.17 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.17 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.17 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.18 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.18 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.18 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.19 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.19 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.19 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.20 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.20 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.20 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.21 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.21 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.21 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.22 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.22 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.22 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.23 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.23 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.23 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.24 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.24 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.24 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Test has 0 Maximum Database Page Fault Stalls/sec. 7/11/2013 10:06:14 PM -- The test has 0 Database Page Fault Stalls/sec samples higher than 0. 7/11/2013 10:06:14 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\Performance_2013_7_11_19_0_28.xml has 737 samples queried. 78
7/11/2013 10:06:14 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\Performance_2013_7_11_19_0_28.html was saved. 7/11/2013 11:03:27 PM -- Performance logging started (interval: 4000 ms). 7/11/2013 11:03:27 PM -- Recovering databases ... 7/11/2013 11:46:08 PM -- Performance logging has ended. 7/11/2013 11:46:08 PM -- Instance2548.1 (2560.7756978), Instance2548.2 (2554.4108866), Instance2548.3 (2537.4380568), Instance2548.4 (2528.9516419), Instance2548.5 (2545.1288703), Instance2548.6 (2527.6256396), Instance2548.7 (2533.9904507), Instance2548.8 (2548.5764764), Instance2548.9 (2548.5764764), Instance2548.10 (2547.5156745), Instance2548.11 (2545.9244717), Instance2548.12 (2550.4328796), Instance2548.13 (2535.5816535), Instance2548.14 (2548.8416768), Instance2548.15 (2542.4768656), Instance2548.16 (2532.1340475), Instance2548.17 (2535.0512526), Instance2548.18 (2544.5984694), Instance2548.19 (2548.0460754), Instance2548.20 (2550.1676792), Instance2548.21 (2544.5984694), Instance2548.22 (2540.0900615), Instance2548.23 (2549.9024787) and Instance2548.24 (2544.5984694) 7/11/2013 11:46:09 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\SoftRecovery_2013_7_11_23_3_17.blg has 631 samples. 7/11/2013 11:46:09 PM -- Creating test report ...
Soft Recovery Test Performance Result: CB10 Test Summary Overall Test Result
Pass
Machine Name
CB10
Test Description Test Start Time
7/11/2013 6:59:37 PM
Test End Time
7/11/2013 10:06:03 PM
Collection Start Time
7/11/2013 7:00:57 PM
Collection End Time
7/11/2013 10:05:52 PM
Jetstress Version
15.00.0658.004
ESE Version
14.01.0218.012
Operating System
Windows Server 2008 R2 Enterprise Service Pack 1 (6.1.7601.65536)
Performance Log
C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\Performance_2013_7_11_19_0_28.blg
79
Database Sizing and Throughput Achieved Transactional I/O per Second
1922.907
Capacity Percentage
100%
Throughput Percentage
100%
Initial Database Size (bytes)
19803277885440
Final Database Size (bytes)
19810827632640
Database Files (Count)
24
Jetstress System Parameters Thread Count
42
Minimum Database Cache
768.0 MB
Maximum Database Cache
6144.0 MB
Insert Operations
40%
Delete Operations
20%
Replace Operations
5%
Read Operations
35%
Lazy Commits
70%
80
Database Configuration Instance2548.1
Log path: C:\logluns\log1 Database: C:\dbluns\db1\Jetstress001001.edb
Instance2548.2
Log path: C:\logluns\log2 Database: C:\dbluns\db2\Jetstress002001.edb
Instance2548.3
Log path: C:\logluns\log3 Database: C:\dbluns\db3\Jetstress003001.edb
Instance2548.4
Log path: C:\logluns\log4 Database: C:\dbluns\db4\Jetstress004001.edb
Instance2548.5
Log path: C:\logluns\log5 Database: C:\dbluns\db5\Jetstress005001.edb
Instance2548.6
Log path: C:\logluns\log6 Database: C:\dbluns\db6\Jetstress006001.edb
Instance2548.7
Log path: C:\logluns\log7 Database: C:\dbluns\db7\Jetstress007001.edb
Instance2548.8
Log path: C:\logluns\log8 Database: C:\dbluns\db8\Jetstress008001.edb
Instance2548.9
Log path: C:\logluns\log9 Database: C:\dbluns\db9\Jetstress009001.edb
Instance2548.10
Log path: C:\logluns\log10 Database: C:\dbluns\db10\Jetstress010001.edb
Instance2548.11
Log path: C:\logluns\log11 Database: C:\dbluns\db11\Jetstress011001.edb
Instance2548.12
Log path: C:\logluns\log12 Database: C:\dbluns\db12\Jetstress012001.edb
Instance2548.13
Log path: C:\logluns\log13 Database: C:\dbluns\db13\Jetstress013001.edb
Instance2548.14
Log path: C:\logluns\log14 Database: C:\dbluns\db14\Jetstress014001.edb
Instance2548.15
Log path: C:\logluns\log15 Database: C:\dbluns\db15\Jetstress015001.edb
Instance2548.16
Log path: C:\logluns\log16 Database: C:\dbluns\db16\Jetstress016001.edb
Instance2548.17
Log path: C:\logluns\log17 Database: C:\dbluns\db17\Jetstress017001.edb
81
Instance2548.18
Log path: C:\logluns\log18 Database: C:\dbluns\db18\Jetstress018001.edb
Instance2548.19
Log path: C:\logluns\log19 Database: C:\dbluns\db19\Jetstress019001.edb
Instance2548.20
Log path: C:\logluns\log20 Database: C:\dbluns\db20\Jetstress020001.edb
Instance2548.21
Log path: C:\logluns\log21 Database: C:\dbluns\db21\Jetstress021001.edb
Instance2548.22
Log path: C:\logluns\log22 Database: C:\dbluns\db22\Jetstress022001.edb
Instance2548.23
Log path: C:\logluns\log23 Database: C:\dbluns\db23\Jetstress023001.edb
Instance2548.24
Log path: C:\logluns\log24 Database: C:\dbluns\db24\Jetstress024001.edb
82
Transactional I/O Performance
MSExchange Database ==> Instances
I/O Database Reads Average Latency (msec)
I/O Database Writes Average Latency (msec)
I/O Database Reads/sec
I/O Database Writes/sec
I/O Database Reads Average Bytes
I/O Database Writes Average Bytes
I/O Log Reads Average Latency (msec)
I/O Log Writes Average Latency (msec)
I/O Log Reads/sec
I/O Log Writes/sec
I/O Log Reads Average Bytes
I/O Log Writes Average Bytes
Instance2548.1
19.378
2.052
54.049
26.508
32768.000
35027.904
0.000
0.352
0.000
21.082
0.000
4845.712
Instance2548.2
19.188
2.395
53.980
26.358
32768.000
35016.255
0.000
0.350
0.000
21.255
0.000
4780.661
Instance2548.3
19.205
2.749
53.971
26.282
32768.000
35005.282
0.000
0.354
0.000
20.822
0.000
4869.049
Instance2548.4
19.236
3.103
53.989
26.209
32768.000
35021.688
0.000
0.350
0.000
20.891
0.000
4824.542
Instance2548.5
19.207
3.468
53.827
26.143
32768.000
35068.723
0.000
0.349
0.000
20.990
0.000
4865.468
Instance2548.6
19.222
3.840
53.751
26.020
32768.000
35084.092
0.000
0.349
0.000
20.728
0.000
4908.239
Instance2548.7
19.219
4.221
53.986
26.316
32768.000
35032.394
0.000
0.353
0.000
20.916
0.000
4855.092
Instance2548.8
19.224
4.603
54.144
26.531
32767.999
35002.944
0.000
0.351
0.000
21.013
0.000
4813.849
Instance2548.9
19.194
4.977
53.904
26.179
32768.000
35062.943
0.000
0.353
0.000
20.999
0.000
4833.899
Instance2548.10
19.213
5.351
53.613
26.044
32768.000
35078.461
0.000
0.349
0.000
20.961
0.000
4926.556
Instance2548.11
19.201
5.783
53.884
26.258
32768.000
35040.787
0.000
0.353
0.000
21.015
0.000
4834.395
Instance2548.12
19.194
6.179
53.894
26.266
32768.000
35073.153
0.000
0.350
0.000
21.114
0.000
4826.736
Instance2548.13
19.175
6.594
53.961
26.157
32768.000
35043.404
0.000
0.328
0.000
20.953
0.000
4829.276
Instance2548.14
19.172
6.899
53.750
26.120
32768.000
35065.662
0.000
0.331
0.000
20.819
0.000
4896.654
Instance2548.15
19.161
7.296
54.132
26.387
32768.000
35023.120
0.000
0.332
0.000
20.817
0.000
4841.271
Instance2548.16
19.189
7.618
53.998
26.266
32768.000
35057.915
0.000
0.332
0.000
20.944
0.000
4855.629
Instance2548.17
19.179
7.995
53.837
26.097
32768.000
35052.160
0.000
0.330
0.000
20.827
0.000
4875.698
Instance2548.18
19.189
8.333
53.856
26.193
32768.000
35074.175
0.000
0.329
0.000
20.978
0.000
4871.648
Instance2548.19
19.172
8.670
54.119
26.461
32768.000
35012.107
0.000
0.331
0.000
21.029
0.000
4834.854
Instance2548.20
19.166
8.992
53.799
26.083
32768.000
35073.406
0.000
0.333
0.000
20.781
0.000
4901.972
Instance2548.21
19.160
9.287
53.710
26.139
32768.000
35104.502
0.000
0.329
0.000
21.069
0.000
4842.239
Instance2548.22
19.201
9.617
53.609
26.041
32768.000
35092.503
0.000
0.330
0.000
20.919
0.000
4921.098
Instance2548.23
19.189
9.914
53.724
26.077
32768.000
35084.444
0.000
0.335
0.000
21.036
0.000
4853.697
Instance2548.24
19.164
10.170
53.941
26.348
32768.000
35047.418
0.000
0.330
0.000
21.125
0.000
4838.479
83
Host System Performance Counter
Average
Minimum
Maximum
% Processor Time
2.091
0.060
4.382
Available MBytes
54129.656
54057.000
59209.000
Free System Page Table Entries
33555793.003
33555791.000
33555795.000
Transition Pages RePurposed/sec
0.000
0.000
0.000
Pool Nonpaged Bytes
97023117.528
96940032.000
97230848.000
Pool Paged Bytes
230514710.201
230346752.000
230813696.000
Database Page Fault Stalls/sec
0.000
0.000
0.000
Test Log 7/11/2013 6:59:37 PM -- Preparing for testing ... 7/11/2013 7:00:01 PM -- Attaching databases ... 7/11/2013 7:00:01 PM -- Preparations for testing are complete. 7/11/2013 7:00:01 PM -- Starting transaction dispatch .. 7/11/2013 7:00:01 PM -- Database cache settings: (minimum: 768.0 MB, maximum: 6.0 GB) 7/11/2013 7:00:01 PM -- Database flush thresholds: (start: 61.4 MB, stop: 122.9 MB) 7/11/2013 7:00:28 PM -- Database read latency thresholds: (average: 20 msec/read, maximum: 100 msec/read). 7/11/2013 7:00:28 PM -- Log write latency thresholds: (average: 10 msec/write, maximum: 100 msec/write). 7/11/2013 7:00:42 PM -- Operation mix: Sessions 42, Inserts 40%, Deletes 20%, Replaces 5%, Reads 35%, Lazy Commits 70%. 7/11/2013 7:00:42 PM -- Performance logging started (interval: 15000 ms). 7/11/2013 7:00:42 PM -- Generating log files ... 7/11/2013 10:06:00 PM -- C:\logluns\log1 (101.6% generated), C:\logluns\log2 (101.0% generated), C:\logluns\log3 (100.8% generated), C:\logluns\log4 (100.2% generated), C:\logluns\log5 (101.2% generated), C:\logluns\log6 (101.0% generated), C:\logluns\log7 (100.8% generated), C:\logluns\log8 (100.6% generated), C:\logluns\log9 (101.0% generated), C:\logluns\log10 (102.4% generated), C:\logluns\log11 (101.2% generated), C:\logluns\log12 (101.2% generated), C:\logluns\log13 (100.4% generated), C:\logluns\log14 (101.4% generated), C:\logluns\log15 (100.2% generated), C:\logluns\log16 (101.2% generated), C:\logluns\log17 (101.0% generated), C:\logluns\log18 (101.8% generated), C:\logluns\log19 (101.0% generated), C:\logluns\log20 (101.2% generated), C:\logluns\log21 (101.6% generated), C:\logluns\log22 (102.2% generated), C:\logluns\log23 (101.2% generated) and C:\logluns\log24 (101.6% generated) 7/11/2013 10:06:00 PM -- Performance logging has ended. 7/11/2013 10:06:00 PM -- JetInterop batch transaction stats: 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22131, 22130, 22130, 22130, 22130, 22130, 22130 and 22130. 7/11/2013 10:06:00 PM -- Dispatching transactions ends.
84
7/11/2013 10:06:00 PM -- Shutting down databases ... 7/11/2013 10:06:03 PM -- Instance2548.1 (complete), Instance2548.2 (complete), Instance2548.3 (complete), Instance2548.4 (complete), Instance2548.5 (complete), Instance2548.6 (complete), Instance2548.7 (complete), Instance2548.8 (complete), Instance2548.9 (complete), Instance2548.10 (complete), Instance2548.11 (complete), Instance2548.12 (complete), Instance2548.13 (complete), Instance2548.14 (complete), Instance2548.15 (complete), Instance2548.16 (complete), Instance2548.17 (complete), Instance2548.18 (complete), Instance2548.19 (complete), Instance2548.20 (complete), Instance2548.21 (complete), Instance2548.22 (complete), Instance2548.23 (complete) and Instance2548.24 (complete) 7/11/2013 10:06:03 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\Performance_2013_7_11_19_0_28.blg has 738 samples. 7/11/2013 10:06:03 PM -- Creating test report ... 7/11/2013 10:06:13 PM -- Instance2548.1 has 19.4 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.1 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.1 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.2 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.2 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.2 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.3 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.3 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.3 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.4 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.4 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.4 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.5 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.5 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.5 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.6 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.6 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.6 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.7 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.7 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.7 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.8 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.8 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.8 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.9 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.9 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.9 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.10 has 19.2 for I/O Database Reads Average Latency.
85
7/11/2013 10:06:13 PM -- Instance2548.10 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.10 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.11 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.11 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.11 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.12 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.12 has 0.4 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.12 has 0.4 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.13 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.13 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.13 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.14 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.14 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.14 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.15 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.15 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.15 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.16 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.16 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.16 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.17 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:13 PM -- Instance2548.17 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.17 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.18 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.18 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.18 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.19 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.19 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.19 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.20 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.20 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.20 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.21 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.21 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.21 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.22 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.22 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.22 has 0.3 for I/O Log Reads Average Latency.
86
7/11/2013 10:06:14 PM -- Instance2548.23 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.23 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.23 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.24 has 19.2 for I/O Database Reads Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.24 has 0.3 for I/O Log Writes Average Latency. 7/11/2013 10:06:14 PM -- Instance2548.24 has 0.3 for I/O Log Reads Average Latency. 7/11/2013 10:06:14 PM -- Test has 0 Maximum Database Page Fault Stalls/sec. 7/11/2013 10:06:14 PM -- The test has 0 Database Page Fault Stalls/sec samples higher than 0. 7/11/2013 10:06:14 PM -- C:\HUS_VM_C1B10_SAS7.2K_ESRP_R10_ 5GB _mbox_Users\Soft Recovery\Performance_2013_7_11_19_0_28.xml has 737 samples queried.
87
© Hitachi Data Systems Corporation 2013. All rights reserved. HITACHI is a trademark or registered trademark of Hitachi, Ltd. Microsoft, Exchange 2013, and Exchange Server 2013 are trademarks or registered trademarks of Microsoft Corporation. All other trademarks, service marks, and company names are properties of their respective owners.. Notice: This document is for informational purposes only, and does not set forth any warranty, expressed or implied, concerning any equipment or service offered or to be offered by Hitachi Data Systems Corporation. © Hitachi Data Systems Corporation 2013. All Rights Reserved. ESRP-099-00 July-August 2013 Corporate Headquarters 2845 Lafayette Street, Santa Clara, California 95050-2639 USA www.HDS.com
Regional Contact Information Americas: +1 408 970 1000 or
[email protected] Europe, Middle East and Africa: +44 (0) 1753 618000 or
[email protected] Asia Pacific: +852 3189 7900 or
[email protected]
88
