CommServe Database Recommendation
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 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 |
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:
|
|
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. |
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:
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 |
12. |
|
13. |
|
14. |
|
|
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.
|
Use the following steps to run Iometer with 8 worker thread:
|