Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Last Updated: Tuesday, February 2, 2016 SolarWinds Database Performance Analyze

Last Updated: Tuesday, February 2, 2016 SolarWinds Database Performance Analyzer Administrator Guide Version 10.1 Copyright © 1999-2016 SolarWinds Worldwide, LLC. All rights reserved worldwide. No part of this document may be reproduced by any means nor modified, decompiled, disassembled, published or distributed, in whole or in part, or translated to any electronic medium or other means without the written consent of SolarWinds. All right, title, and interest in and to the software and documentation are and shall remain the exclusive property of SolarWinds and its respective licensors. SOLARWINDS DISCLAIMS ALL WARRANTIES, CONDITIONS OR OTHER TERMS, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, ON SOFTWARE AND DOCUMENTATION FURNISHED HEREUNDER INCLUDING WITHOUT LIMITATION THE WARRANTIES OF DESIGN, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT. IN NO EVENT SHALL SOLARWINDS, ITS SUPPLIERS, NOR ITS LICENSORS BE LIABLE FOR ANY DAMAGES, WHETHER ARISING IN TORT, CONTRACT OR ANY OTHER LEGAL THEORY EVEN IF SOLARWINDS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. The SolarWinds, the SolarWinds & Design, ipMonitor, LANsurveyor, Orion, and other SolarWinds marks, identified on the SolarWinds website, as updated from SolarWinds from time to time and incorporated herein, are registered with the U.S. Patent and Trademark Office and may be registered or pending registration in other countries. All other SolarWinds trademarks may be common law marks or registered or pending registration in the United States or in other countries. All other trademarks or registered trademarks contained and/or mentioned herein are used for identification purposes only and may be trademarks or registered trademarks of their respective companies. Microsoft®, Windows®, and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries. Version 10.1, revised 2/2/2016 For legal notices regarding the third-party components used in this software, see: http://www.solarwinds.com/documentation/legal/dpa/10.1/ 2 About SolarWinds SolarWinds, Inc. develops and markets an array of network management, monitoring, and discovery tools to meet the diverse requirements of today’s network management and consulting professionals. SolarWinds products continue to set benchmarks for quality and performance and have positioned the company as the leader in network management and discovery technology. The SolarWinds customer base includes over 85 percent of the Fortune 500 and customers from over 170 countries. Our global business partner distributor network exceeds 100 distributors and resellers. Contact SolarWinds TEAM CONTACT INFORMATION Sales sales@solarwinds.com www.solarwinds.com 1-866-530-8100 +353-21-500-2900 Technical Support www.solarwinds.com/support User Forums www.thwack.com 3 About SolarWinds 3 Contact SolarWinds 3 Installation 9 Introduction 9 SolarWinds DPA architecture 9 Two key functions of the SolarWinds DPA server 9 Monitored database instances 9 Monitored virtualization environment 10 Before you install 10 Requirements 10 Server requirements 11 Requirements for a self-managed SolarWinds DPA server 11 Supported operating systems 11 More than 250 monitored instances 11 Requirements for an Amazon EC2 SolarWinds DPA server 12 Repository database requirements 12 Minimum system requirements for the repository database server 12 Adequate disk space for the repository database 13 Administrator credentials are required 13 Database versions you can monitor 13 Self-managed databases 13 Amazon RDS databases 14 You can repoint MySQL but not Oracle or Microsoft SQL Server instances 15 Web browsers 15 MySQL requirements 16 MySQL Performance Schema 16 4 Table of Contents Global Instrumentation and Thread Instrumentation 16 show_compatibility_56 system variable 16 Java requirements 16 Installation overview 17 Install on Windows 17 Start the Installer 17 After installation 17 Install on UNIX or Linux 18 After installation 18 Install on Amazon Web Services 18 Differences between Amazon Web Services (AWS) and self-managed servers 18 Launch a SolarWinds DPA instance in Amazon EC2 19 Log in to the AWS SolarWinds DPA server 22 Upgrade SolarWinds DPA 22 Upgrade on Windows 22 Upgrade on UNIX or Linux 23 Upgrade on an Amazon Machine Image instance 23 Resize to a more powerful Amazon AWS instance type 23 Licensing 24 License types 24 Database instance licenses 24 Category 1 licenses 24 Category 2 licenses 24 Virtual machine licenses 24 Purchase licenses 25 5 SolarWinds DPA Administrator Guide 6 View purchased licenses 25 Activate your licenses 25 Activate licenses online 25 Activate licenses offline 26 Allocate licenses to database instances 26 Current license allocation 26 Allocate licenses to database instances to monitor and collect information 27 Allocate VM licenses to VM database instances 27 Deallocate licenses 27 Deactivate your licenses 27 Deactivate online 27 Deactivate offline 27 Troubleshoot over-allocated licenses 27 Get started 29 Get started 29 Identify the top three query problems 29 Correlate response time with system resources 31 Determine wait bottlenecks that delay response time 31 Diagnose current performance issues 34 The SolarWinds DPA worksheet 34 Identify the top three query problems 34 Correlate response time with system resources 35 Determine wait bottlenecks that delay response time 35 Diagnose performance issues 36 Admin guide 37 Table of Contents Users and groups 37 Create a user 37 Create a group 37 User authentication options 37 Active Directory user authentication 37 LDAP user authentication 37 Single sign-on 38 Common Access Cards 38 Reports 38 Report types 38 Trend reports 40 Trend reports use summarized data 40 Minimum data to create a trend report 40 Create a Top SQL Statements report 40 Schedule a report for email delivery 40 Alerts 41 Alert types 41 Alert attributes 42 SNMP alerts 43 Create an SNMP contact 43 Alert on increases in SQL wait times 44 Determine the average execution time for your queries 44 Create an alert based on the wait threshold 44 Advanced analysis 45 Stop monitoring a database instance for a period of time 45 7 SolarWinds DPA Administrator Guide 8 Enable SNMP Monitoring in SCOM 45 Automatic grouping of Oracle CDBs 46 Turn off automatic grouping of Oracle CDBs 46 Link together separate DPA servers 46 Set up a Central Server 46 Configure authentication for Central Server 47 Log in with a SolarWinds DPA user 47 Log in with an Active Directory or LDAP user 47 Add remote DPA servers 47 View the Central Server page 48 Central Server advanced configuration 48 Thread pool settings 48 General Central Server settings 49 Client factory cache 50 Troubleshooting tips 51 Table of Contents Installation Introduction You can use SolarWinds Database Performance Analyzer to monitor, diagnose, and resolve performance problems for Oracle, SQL Server, MySQL, DB2, and Sybase databases. SolarWinds DPA has agentless architecture that allows for extended database monitoring without draining performance from production systems. SolarWinds DPA architecture SolarWinds Database Performance Analyzer consists of: n A SolarWinds DPA server n A SolarWinds DPA repository database n One or more database instances you want to monitor The SolarWinds DPA server collects performance data from a set of database instances you choose to monitor. SolarWinds DPA stores this data in the repository database. For optimal performance, the repository and the monitored database instances must reside on the same high-speed local area network (LAN). If your environment contains database instances that are on separate LANs, SolarWinds recommends setting up a repository on each LAN. The SolarWinds DPA server provides a web interface that displays performance data in a web browser from any computer with access to the SolarWinds DPA server. SolarWinds recommends installing one SolarWinds DPA instance on a computer. If you must install multiple instances on the same computer, contact www.solarwinds.com/support. Two key functions of the SolarWinds DPA server n Collecting data from the monitored database instances and storing the data in the repository database. n Providing a web interface that displays performance data from any computer with access to the SolarWinds DPA server. From this interface, you can configure monitoring, alerting, and email reports. Monitored database instances SolarWinds DPA remotely connects to each database instance using Java Database Connectivity (JDBC). SolarWinds DPA causes less than 1% overhead on the instance. No software is installed on the monitored server. 9 Monitored virtualization environment In a virtual environment, SolarWinds DPA can remotely connect to each VMware vCenter Server, ESX, or ESXi host. SolarWinds DPA causes less than 1% overhead on the monitored systems. No software is installed in the vCenter Server, ESX or ESXi host, or virtual machines. Before you install 1. Identify the server where SolarWinds DPA will be installed. Make sure the server: n Is powerful enough to handle the load of the potential number of monitored database instances that you will register. See the Server requirements. n Has network connectivity to the SolarWinds DPA repository and each of the monitored database instances that you will register. SolarWinds DPA can be installed on the same server as the repository instance, although it is not required or recommended. 2. Identify the Microsoft SQL Server or Oracle database instance that will host the SolarWinds DPA repository and make sure: a. The repository is not installed in a critical production database instance. b. You have credentials with SYSADMIN privileges for a Microsoft SQL Server repository. c. You have credentials with database administrator (DBA) privileges for an Oracle repository. 3. Obtain login credentials for each of the monitored databases. See the table below. SolarWinds DPA performs best if a high-speed network exists between the repository and the monitored database uploads/s1/ dpa-administrator-guide.pdf