The Custom Counter Value window of the Add Custom Counter wizard allows you to select the type of calculation used by your counter and set a scale factor so that your counter information displays values in their correct format. While the Scale drop-down list displays the same scale factors available in PerfMon, you can also type in a custom scale factor to use.
Custom Calculation Type
Choose to either have your counter display the value collected or calculate the value per second between refreshes.
Customize Scale Factor
Select a custom scale to convert the value into a more manageable number.
Access the Add Custom Counter wizard
You can open the Add Custom Counter wizard by clicking Administration > Custom Counters and clicking Add in the Custom Counters view.
Scale factor examples
The following table covers some conversion factors that allows you to precisely convert common units:
Collected Value | Desired Value | Scale Factor |
---|---|---|
Kilobyte | Byte | 1024 |
Megabyte | Byte | 1048576 |
Megabyte | Kilobyte | 1024 |
Gigabyte | Kilobyte | 1048576 |
Terabyte | Megabyte | 1048576 |
Terabyte | Gigabyte | 1024 |
Byte | Kilobyte | 0.0009765625 |
Byte | Megabyte | 0.000000953674316 |
Kilobyte | Megabyte | 0.0009765625 |
Kilobyte | Gigabyte | 0.0009765625 |
Megabyte | Gigabyte | 0.0009765625 |
Megabyte | Terabyte | 0.000000953674316 |
Gigabyte | Terabyte | 0.0009765625 |
Kilobyte | SQL Server Page | 0.125 |
Megabyte | SQL Server Page | 128 |
Gigabyte | SQL Server Page | 131072 |
SQL Server Page | Kilobyte | 8 |
SQL Server page | Megabyte | 0.007813 |
SQL Server Page | Gigabyte | 0.000007629395 |
Kilobyte | SQL Server Extent | 0.015625 |
Megabyte | SQL Server Extent | 16 |
Gigabyte | SQL Server Extent | 16384 |
SQL Server Extent | Kilobyte | 64 |
SQL Server Extent | Megabyte | 0.0625 |
SQL Server Extent | Gigabyte | 0.000061035156 |