{"id":15424,"date":"2016-01-27T10:00:28","date_gmt":"2016-01-27T09:00:28","guid":{"rendered":"http:\/\/nolabnoparty.com\/en\/?p=15424"},"modified":"2016-01-27T12:00:00","modified_gmt":"2016-01-27T11:00:00","slug":"vmturbo-5-target-ms-sql-servers","status":"publish","type":"post","link":"https:\/\/nolabnoparty.com\/en\/vmturbo-5-target-ms-sql-servers\/","title":{"rendered":"VMTurbo 5: target MS-SQL Servers"},"content":{"rendered":"

\"vmturbomssql01\"<\/p>\n

VMTurbo Operations Manager allows the control of\u00a0MS-SQL Servers to improve database\u00a0performance<\/strong>\u00a0resizing\u00a0connection pools, database memory or transaction log.<\/p>\n

To control\u00a0memory sizing inside applications and databases, the Application Control Module<\/a> must be activated\u00a0in Operations Manager\u00a0enabling auto-scaling up or out to meet real-time demands<\/strong>.<\/p>\n

 <\/p>\n

Enter\u00a0the license key<\/h2>\n

To enable the Application Control Module a valid license<\/strong>\u00a0must be installed in\u00a0Operations Manager. From VMTurbo website you can\u00a0request a\u00a030-day trial<\/a>\u00a0to test the application.<\/p>\n

\"vmturbomssql02\"<\/p>\n

From your favorite browser access VMTurbo web console, type the correct credentials then click Login<\/strong>.<\/p>\n

\"vmturbomssql03\"<\/p>\n

Select Admin<\/strong>\u00a0tab\u00a0from\u00a0main menu.<\/p>\n

\"vmturbomssql04\"<\/p>\n

Click on Workflows<\/strong> item to open the panel and\u00a0select License Configuration<\/strong> option.<\/p>\n

\"vmturbomssql05\"<\/p>\n

Click License Configuration<\/strong> button to enter the license received from VMTurbo.<\/p>\n

\"vmturbomssql06\"<\/p>\n

Paste the license key then click Save<\/strong>.<\/p>\n

\"vmturbomssql07\"<\/p>\n

The Application Control Module<\/strong> has been enabled.<\/p>\n

\"vmturbomssql08\"<\/p>\n

 <\/p>\n

Setup MS-SQL Server<\/h2>\n

Starting from version\u00a05.2<\/strong>, VMTurbo\u00a0Operation Managers supports MS-SQL<\/strong> Server 2008 R2, 2012 and 2014. You can add an individual database<\/strong> server as a target or all matching targets<\/strong> within a given scope.<\/p>\n

Using VMTurbo to manage database servers, you can monitor the following resources<\/strong>:<\/p>\n

    \n
  • DBMem<\/strong> - the memory utilized by the database<\/li>\n
  • Connection<\/strong> - the active connections as a percentage of the maximum number of connections for the database<\/li>\n
  • Transactions<\/strong> - active transactions as a percentage of allocated capacity<\/li>\n
  • Response Time<\/strong> - averaged response time (ms), as a percentage of the allocated capacity<\/li>\n
  • Transaction Log<\/strong> - consumption of storage dedicated to transaction logs<\/li>\n<\/ul>\n

     <\/p>\n

    Create an\u00a0administrative account<\/h4>\n

    From MS-SQL Server, open the SQL Server Management Studio<\/strong>.<\/p>\n

    \"vmturbomssql09\"<\/p>\n

    Expand Security<\/strong> item, right click Logins<\/strong> and select New Login<\/strong> option.<\/p>\n

    \"vmturbomssql10\"<\/p>\n

    Specify the\u00a0Active Directory\u00a0Login Name<\/strong> VMTurbo will use to access the\u00a0SQL Server.<\/p>\n

    \"vmturbomssql11\"<\/p>\n

    In\u00a0Securables<\/strong> tab, click Search<\/strong> button and select the SQL Server. Click OK<\/strong> to confirm.<\/p>\n

    \"vmturbomssql12\"<\/p>\n

    Under Explicit<\/strong> section, grant Connect SQL<\/strong> permission to the selected user.<\/p>\n

    \"vmturbomssql13\"<\/p>\n

    Grant also View Server State<\/strong> permission then click OK<\/strong>.<\/p>\n

    \"vmturbomssql14\"<\/p>\n

    The specified user is now listed under Logins<\/strong>\u00a0folder and will be used by VMTurbo to connect the SQL Server.<\/p>\n

    \"vmturbomssql15\"<\/p>\n

     <\/p>\n

    Target MS-SQL Server<\/h2>\n

    From VMTurbo console, select Workflows > Target Configuration<\/strong> in Admin<\/strong> tab.<\/p>\n

    \"vmturbomssql16\"<\/p>\n

    Click Add<\/strong> to add a new target.<\/p>\n

    \"vmturbomssql17\"<\/p>\n

    Select Database<\/strong>\u00a0as Target Type and select\u00a0SQLServer<\/strong>\u00a0option.\u00a0To connect the database you need to specify the following:<\/p>\n

      \n
    • Scope\/Address<\/strong> - name or IP address of the VM hosting the application server<\/li>\n
    • Port number<\/strong> - the port that reaches the database service listener (1433 default)<\/li>\n
    • Full Domain Name<\/strong> - the full name of the domain<\/li>\n
    • Username and Password<\/strong> - valid client credentials for the database service with\u00a0administrator privileges in SQL Server<\/li>\n<\/ul>\n

      \"vmturbomssql18\"<\/p>\n

      Click Add<\/strong> to add the database to control.<\/p>\n

      \"vmturbomssql19\"<\/p>\n

      Click Apply<\/strong> to store the\u00a0new target.<\/p>\n

      \"vmturbomssql20\"<\/p>\n

      Click Rediscover<\/strong> button to discover\u00a0and validate the added target.<\/p>\n

      \"vmturbomssql21\"<\/p>\n

      The discovery process is being performed.<\/p>\n

      \"vmturbomssql22\"<\/p>\n

      When the Discovery process has\u00a0completed, the Last Discovery Time<\/strong> label is updated with current date and time.<\/p>\n

      \"vmturbomssql23\"<\/p>\n

       <\/p>\n

      VMTurbo analytics<\/h2>\n

      From Inventory<\/strong>\u00a0tab, select Applications > Apps_SQLSERVER<\/strong>\u00a0and select the configured SQL Server.<\/p>\n

      \"vmturbomssql24\"<\/p>\n

      In the right side, VMTurbo shows three main panels\u00a0with the following information<\/strong>:<\/p>\n

      Resources<\/strong> - the resources the application server provides and the resources it consumes from the hosting\u00a0VM.<\/p>\n

      \"vmturbomssql25\"<\/p>\n

      Utilization<\/strong> - a\u00a0chart showing the utilization of the provided resources over time.<\/p>\n

      \"vmturbomssql26\"<\/p>\n

      To Do<\/strong> - recommended\u00a0actions for the selected application server.<\/p>\n

      \"vmturbomssql27\"<\/p>\n

      With Application Control Module, VMTurbo understands application resource demand<\/strong> of target SQL Server assuring best performance maximizing infrastructure utilization.<\/p>\n

      \"firma\"<\/p>\n","protected":false},"excerpt":{"rendered":"

      VMTurbo Operations Manager allows the control of\u00a0MS-SQL Servers to improve database\u00a0performance\u00a0resizing\u00a0connection pools, database memory or transaction log. To control\u00a0memory sizing inside applications and databases, the Application Control Module must be activated\u00a0in Operations Manager\u00a0enabling auto-scaling up or out to meet real-time demands.<\/p>\n","protected":false},"author":3,"featured_media":15425,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"linkedin_93tdZWzMZc_93tdZWzMZc":"","facebook_2879994398731222_17841400390232720":"","twitter_113568041_113568041":"","mastodon_115463926174894442_115463926174894442":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","footnotes":""},"categories":[1497,903],"tags":[1646,1642,1495,1498],"class_list":["post-15424","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-turbonomic-en","category-vmware-en","tag-application-control-module","tag-ms-sql","tag-operations-manager","tag-vmturbo-en","has_thumb"],"_links":{"self":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/15424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/comments?post=15424"}],"version-history":[{"count":0,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/15424\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media\/15425"}],"wp:attachment":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media?parent=15424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/categories?post=15424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/tags?post=15424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}