IOPs For CommServe Database Volumes

Table of Contents

Overview

CommServe Database Recommendation

IoMeter On Windows

Overview

This document describes how to plan for and measure Input Output Operations per second (IOPs) when commissioning disk storage to store CommServe Database.

CommServe database volume stores Microsoft SQL database that acts as a central repository for CommCell wide configuration information. Since nearly every operation depends on this central critical resource, it is recommended that this volume be on a fast disk for speedy overall performance.

The following section explains the use of Iometer which is a widely used industry standard tool for measuring IOPs. Using IOPs rating provides a standard and simplified way to commission storage without having to understand and use proprietary tools.

CommServe Database Recommendation

CommServe database must be hosted on a separate volume that meets the below IOPs requirement.

If using CommNet, it is recommended to not host the CommNet Database on the same server as the active CommServe for optimal performance.

Suggested CommServe Database Volume Size IOPs With Single worker thread IOPs With 8 Worker Threads Client Count Example Configuration
300 GB 320+ 1000+ Handles up to 5000 clients within the CommCell 8 144 GB 15K SAS Spindles in RAID 10 Configuration

IoMeter On Windows

Installing Iometer

1. Download and install Iometer on the server (CommServe) where storage disks/volumes need to be tested.

Iometer can be downloaded from www.iometer.org.

 
2. Ensure to run the Iometer test on the complete raw disk.

If you wish to run the Iometer on a volume which has the data, then make sure to copy the data on a different location before performing the test. This is to avoid the data loss issue. Once the test is complete you can copy back the data to old location.

 
3. Stop all the services on the CommServe on which the IOPS need to be tested.

Perform the following steps to stop the services:

  • Click the Start button on the Windows task bar and then click All Programs.
  • Navigate to bull | Calypso and click Service Control Manager.
  • Right-click All Services and click Stop to stop all services.
 
4. Copy all the data from the volume that needs to be tested to a temporary folder.

Make sure that permission on the files/folders are also copied.

 
5. Delete the volume.  

Running Iometer with Single Worker Thread

Worker thread is an entity that runs the test defined under Access Specification Tab of IoMeter UI. Multiple worker threads run the tests in parallel to test concurrent performance.

Use the following steps to run Iometer using single worker thread:

6. Right-click Iometer and click Run as Administrator.
7. The Iometer dialog box will appear.  
8. Click on the name of the computer available in the Topology panel on the left side of the window.

The available disk drives will appear in the Disk Targets tab.

IoMeter, on startup, creates one Manager with multiple worker threads. Leave one worker thread and delete remaining worker threads by selecting the worker thread and clicking the Disconnect Selected Worker or Manager button.

  It is recommended to run Iometer on the physical disk that represents the storage volume for which IOPs need to be measured. Iometer will allow physical disks to be selected only when there are no volumes on the disk.
9.
  • In the Disk Targets tab, select a disk to use in the test.
  • Values for Maximum Disk Size and Starting Disk Sector should be set to default, that is 0, to test the complete disk.

    If running the test on a volume, Iometer needs to prepare the volume. It creates a file named iobw.tst file as part of this preparation phase and runs read/write tests on this file.

      In the figure, blue disk icon represent physical drives which has no partitions on them.

In the figure, PHYSICALDRIVE:2 is the disk selected for the test.

Access Specifications

10. Click the Access Specifications tab.  
11. From the Global Access Specifications area, select the Iometer profile that needs to be used for IOPs measurement test.
 

Recommended Iometer Profile for Testing CommServe Database Volume

4K Block Size, 100% Access, 100% Random, 67% Read and 33% Write

This profile closely emulates the way in which disk is accessed by MS SQL database lookups

Results Display

12.
  • Click the Results Display tab.
  • Change Update Frequency slider to 5 seconds.

Test Setup

13.
  • Click the Test Setup tab.
  • Set the time Run Time to 30 minutes

Results

14.
  • Press the Start Tests button (green flag) to run IOMeter test.
  • A standard Save File dialog will appears. Select a file to store the test results (by default it saves as results.csv)

    After a few seconds the test results will appear in the Results Display tab.

    Run the test for around 30 minutes or until IOPs value stabilized.

  • Press the Stop Test button (stop sign). The test stops and the final results are saved in the results.csv file. This can be viewed in any text editor.

    At the end of the test, note down the IOPs test rating. In the below figure, IOPs rating for the volume under test is 329.31 with one worker thread.

15. Recreate the volume on the disk with the same drive letter or mount path.

If required format the volume.

 
16. Copy all the data from temporary folder back to the volume.  
17. Start all the Services.
  • Click the Start button on the Windows task bar and then click All Programs.
  • Navigate to bull | Calypso and click Service Control Manager.
  • Right-click All Services and click Start to start all services.
 

Run Iometer With Multiple Worker Thread

Use the following steps to run Iometer with 8 worker thread:

  1. Follow the steps described in the below sections to run Iometer with single worker thread and set the access specifications.
    1. Installing Iometer
    2. Running Iometer
    3. Access Specifications
  2. Click the Start a Duplicate of This Worker on This Manager button to create a duplicate worker thread with the same settings.

    Create a total of 8 worker thread.

  3. Run the test by following the steps described in below sections:
    1. Results Display
    2. Test Setup
    3. Results

Back to Top