| title | description | services | documentationcenter | manager | author | editor | ms.assetid | ms.service | ms.custom | ms.workload | ms.tgt_pltfrm | ms.devlang | ms.topic | ms.date | ms.author |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Performance counters for shard map manager |
ShardMapManager class and data dependent routing performance counters |
sql-database |
jhubbard |
ddove |
b090aba0-2e30-454c-96b3-dffa281f539a |
sql-database |
multiple databases |
sql-database |
na |
na |
article |
05/23/2016 |
ddove |
You can capture the performance of a shard map manager, especially when using data dependent routing. Counters are created with methods of the Microsoft.Azure.SqlDatabase.ElasticScale.Client class.
Counters are used to track the performance of data dependent routing operations. These counters are accessible in the Performance Monitor, under the "Elastic Database: Shard Management" category.
For the latest version: Go to Microsoft.Azure.SqlDatabase.ElasticScale.Client. See also Upgrade an app to use the latest elastic database client library.
- To create the performance category and counters, the user must be a part of the local Administrators group on the machine hosting the application.
- To create a performance counter instance and update the counters, the user must be a member of either the Administrators or Performance Monitor Users group.
To create the counters, call the CreatePeformanceCategoryAndCounters method of the ShardMapManagmentFactory class. Only an administrator can execute the method:
ShardMapManagerFactory.CreatePerformanceCategoryAndCounters()
You can also use this PowerShell script to execute the method. The method creates the following performance counters:
- Cached mappings: Number of mappings cached for the shard map.
- DDR operations/sec: Rate of data dependent routing operations for the shard map. This counter is updated when a call to OpenConnectionForKey() results in a successful connection to the destination shard.
- Mapping lookup cache hits/sec: Rate of successful cache lookup operations for mappings in the shard map.
- Mapping lookup cache misses/sec: Rate of failed cache lookup operations for mappings in the shard map.
- Mappings added or updated in cache/sec: Rate at which mappings are being added or updated in cache for the shard map.
- Mappings removed from cache/sec: Rate at which mappings are being removed from cache for the shard map.
Performance counters are created for each cached shard map per process.
The following events trigger the creation of the performance counters:
- Initialization of the ShardMapManager with eager loading, if the ShardMapManager contains any shard maps. These include the GetSqlShardMapManager and the TryGetSqlShardMapManager methods.
- Successful lookup of a shard map (using GetShardMap(), GetListShardMap() or GetRangeShardMap()).
- Successful creation of shard map using CreateShardMap().
The performance counters will be updated by all cache operations performed on the shard map and mappings. Successful removal of the shard map using DeleteShardMap()reults in deletion of the performance counters instance.
- Creation of the performance category and counters should be performed only once before the creation of ShardMapManager object. Every execution of the command CreatePerformanceCategoryAndCounters() clears the previous counters (losing data reported by all instances) and creates new ones.
- Performance counter instances are created per process. Any application crash or removal of a shard map from the cache will result in deletion of the performance counters instances.
Elastic Database features overview
[!INCLUDE elastic-scale-include]