VMTurbo 5: target MS-SQL Servers

vmturbomssql01

VMTurbo Operations Manager allows the control of MS-SQL Servers to improve database performance resizing connection pools, database memory or transaction log.

To control memory sizing inside applications and databases, the Application Control Module must be activated in Operations Manager enabling auto-scaling up or out to meet real-time demands.

 

Enter the license key

To enable the Application Control Module a valid license must be installed in Operations Manager. From VMTurbo website you can request a 30-day trial to test the application.

vmturbomssql02

From your favorite browser access VMTurbo web console, type the correct credentials then click Login.

vmturbomssql03

Select Admin tab from main menu.

vmturbomssql04

Click on Workflows item to open the panel and select License Configuration option.

vmturbomssql05

Click License Configuration button to enter the license received from VMTurbo.

vmturbomssql06

Paste the license key then click Save.

vmturbomssql07

The Application Control Module has been enabled.

vmturbomssql08

 

Setup MS-SQL Server

Starting from version 5.2, VMTurbo Operation Managers supports MS-SQL Server 2008 R2, 2012 and 2014. You can add an individual database server as a target or all matching targets within a given scope.

Using VMTurbo to manage database servers, you can monitor the following resources:

  • DBMem – the memory utilized by the database
  • Connection – the active connections as a percentage of the maximum number of connections for the database
  • Transactions – active transactions as a percentage of allocated capacity
  • Response Time – averaged response time (ms), as a percentage of the allocated capacity
  • Transaction Log – consumption of storage dedicated to transaction logs

 

Create an administrative account

From MS-SQL Server, open the SQL Server Management Studio.

vmturbomssql09

Expand Security item, right click Logins and select New Login option.

vmturbomssql10

Specify the Active Directory Login Name VMTurbo will use to access the SQL Server.

vmturbomssql11

In Securables tab, click Search button and select the SQL Server. Click OK to confirm.

vmturbomssql12

Under Explicit section, grant Connect SQL permission to the selected user.

vmturbomssql13

Grant also View Server State permission then click OK.

vmturbomssql14

The specified user is now listed under Logins folder and will be used by VMTurbo to connect the SQL Server.

vmturbomssql15

 

Target MS-SQL Server

From VMTurbo console, select Workflows > Target Configuration in Admin tab.

vmturbomssql16

Click Add to add a new target.

vmturbomssql17

Select Database as Target Type and select SQLServer option. To connect the database you need to specify the following:

  • Scope/Address – name or IP address of the VM hosting the application server
  • Port number – the port that reaches the database service listener (1433 default)
  • Full Domain Name – the full name of the domain
  • Username and Password – valid client credentials for the database service with administrator privileges in SQL Server

vmturbomssql18

Click Add to add the database to control.

vmturbomssql19

Click Apply to store the new target.

vmturbomssql20

Click Rediscover button to discover and validate the added target.

vmturbomssql21

The discovery process is being performed.

vmturbomssql22

When the Discovery process has completed, the Last Discovery Time label is updated with current date and time.

vmturbomssql23

 

VMTurbo analytics

From Inventory tab, select Applications > Apps_SQLSERVER and select the configured SQL Server.

vmturbomssql24

In the right side, VMTurbo shows three main panels with the following information:

Resources – the resources the application server provides and the resources it consumes from the hosting VM.

vmturbomssql25

Utilization – a chart showing the utilization of the provided resources over time.

vmturbomssql26

To Do – recommended actions for the selected application server.

vmturbomssql27

With Application Control Module, VMTurbo understands application resource demand of target SQL Server assuring best performance maximizing infrastructure utilization.

firma

Leave a Reply