LS DB Store Test

Microsoft Skype for Business server performance is affected by various factors such as user profiles, system architecture, software, hardware components, third-party integration points such as gateways and telephony equipment, network connectivity and performance, Windows Active Directory service configuration and performance in addition to the Windows operating system functionality. At the core of the Skype for Business server deployments’ performance is the server software and hardware it is implemented on. As an example, a front-end server must have sufficient hardware resources to cope with the expected (short-term) user load. If a respective front-end server is required to provide services to 10 thousand users, then an adequately configured server must meet the expected load requirements to ultimately help ensure the best possible end-user experience.

Monitoring server performance is therefore extremely important to gauge whether the implemented server infrastructure have suitable hardware resources for the day-to-day peak-load requirements. Monitoring server performance helps identify system bottlenecks allowing administrators to apply corrective action before the end-user experience is affected. The performance data obtained is then used for long-term capacity planning. For a server performance to be uniform, it is mandatory to track the performance of the backend SQL server database server used by the front end pool of the Microsoft Skype for Business server deployment. This is exactly where the LS DB Store test helps! This test monitors the backend database server and proactively alerts the administrators if the following exceeds/decreases far beyond the optimal range:

  • The time spent by the requests in the queue while waiting to contact the backend server;
  • The time taken by the backend server to process a request;
  • The rate at which the requests were throttled, etc.

Target of the test : A Microsoft Skype for Business server

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the target Microsoft Skype for Business server that is to be monitored.

Configurable parameters for the test
Parameters Description

Test Period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port at which the specified host listens. The default port is 5060.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Queue depth

Indicates the number of requests that are waiting in the queue to be run.

Number

The value of this measure should be less than 500. A value above 500 indicates that the backend database is busy and is unale to respond to requests quickly.

 

Queue latency

Indicates the time spent by a request in the queue while waiting to contact the backend server.

Secs

A low value is desired for this measure. A gradual/sudden increase in the value of this measure indicates that the resource utilization of the backend server is high. Also, there may be a high network latency between the frontend and backend servers.

Sproc latency

Indicates the time taken by the backend server to process a request.

Secs

A low value is desired for this measure. If both the Sproc latency and Queue latency measures are high, then it indicates a bottleneck in the SQL Server back-end database. The disk IO contention and the SQL Server database active transactions are good indicators to identify the database that is having more contention than other databases.

Throttled requests rate

Indicates the rate at which the requests were rejected after being retried.

Request/Sec

The value of this measure will be high if the value of the Queue latency measure is abnormally high.