How to create SQL Performance Investigator agents for monitoring

Welcome to Dell Software Foglight Video Solutions. This video will cover how to create SQL Performance Investigator agents for monitoring. My name is Darrel Williams, and I'm a Technical Product Specialist. The objective of this demo will cover how to create SQL Performance Investigator agents for monitoring. The demo will focus on adding the performance investigator extension after the agent connection details has been set up. For assistance with setting up the agent connection details part, please consult videos-- how to set up a single agent for monitoring using a simple mode, or how to set up multiple agents using the advanced mode, depending on the type of deployment desire. As a set up reference, review the prerequisites and requirements. Also consult the Foglight guides mentioned below. To add agents, login to the Foglight web console with your Foglight user and click on Databases to access the Databases dashboard. Click on Monitor, and select SQL Server. The Monitor SQL Server Instance setup GUI should display in a simple mode format, requesting the needed setup configurations for creating a single instance. A similar screen exists at the set credential step within the Edit credentials dialog box to add the SQL PI extension using the discover multiple SQL Server instances to create multiple SQL performance investigator agents in a setting. Click on Use this option to discover multiple SQL Server instances. Review the informational i's for reference when setting the connection details. Proceeding with configuring under the SQL Server connection portion-- the agent manager host specifies the agent manager defaulted to use to discover the instance. Enter the connection details for the instance. The connection parameters for this demo is against a default instance. Insert in this format-- host, backslash, instance name. Depot optional defaults to 1433. For Windows Authentication, enter in the domain backslash user and password. The current alarm sensitivity level is acceptable for this presentation. Under the Monitoring extensions section is where to add extension features, such as SQL PI. Before adding the performance investigator extension, become familiar with the features and how to obtain the add-on license, if it hasn't been done. Included in this version is a 30-day trial key for the Performance Investigator Add-on extension. To add the SQL PI extension, check the box, and another container pops up showing a pick list of agent managers reporting into the Foglight management server that are possible candidates for performance investigator repository host. Included are the agent manager names and the corresponding OS's. And if there are preexisting PI repositories from another instance, creation on that agent manager is now indicated by a green checkmark, which is also available to add the agent to that existing repository. Take heed of the noting and necessary recommendations and hardware sizing referencing link. Consequently, the PI repository can support up to 100 instances with the proper resource sizing. For this demo, the agent manager selected host will not have an existing PI repository to show what's involved with that part of the agent creation. Select a qualified agent manager, and click Apply. The process will verify the system requirements. If the agent manager selected fails to meet the requirements, another informing box will pop up indicating with some options. This step may not occur if the agent manager host chosen already has a preexisting SPI repository. Click Monitor. Configuration starts. Within a process, connection details and credentials are getting validated. The setting up text indicates PR Repository Creation. Since the agent manager host selected did not have an existing PI repository. If the selected agent manager host did have an existing PI repository, the setup text may not mention a PI repository. Instead, in the background, link the agent to the chosen host managers existing SQL PI repository. Once completed, the initialize successfully monitoring pop-up is indicated. There's a choice of adding another database which would take you back to the setup screen, or click Finish. The new agent is now created and viewable in the databases dashboards. After a couple of collection intervals, the dashboard should become fully populated with associated metrics. Furthermore, there is an entry in the databases SQL PI dashboard. Finally, the monitor status shows PI is enabled. To learn of Foglight for SQL Server, visit software.dell.com/products/foglight-for-sql-server. For more video tutorials, visit DellSoftware.com/Support.