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 then 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

 

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels