Adding a single SQL Server agent to a SQL Server PI repository (4308797)

How to create SQL Performance Investigator agents for monitoring for cartridge versions 5.9.5.20 and higher using a SQL Server PI repository.

1. Login to the Foglight console

2. From the databases dashboard (Global View) click the Monitor button, then SQL Server

   

3. Fill in the Connection Details with the Server name and instance name (separated by a backslash) or just the server name if the Default SQL Server instance is used. Also add the port (if it is not the default port of 1433) and the Username and Password, as well as if SSL is used. The username and password can either be an Active Directory (AD) account such as DOMAIN\USERNAME or a SQL Server account. Alternatively, a radio button is available to use the AD account used to run the Foglight Agent Manager.
   

4. Configure the Sensitivity Level and agent name if desired.
5. Then click the Operating System entry
   
6. Add the OS connection information with the connection type, userid, and password details, a stored login can be used if an agent used the same credentials was previously configured and added to the lockbox. Then click the OK button
   
7. Update the VMWare connection information if desired
8. Click the SQL PI checkbox or entry
   
9. Accept the licensing agreement
   
10. Select the Foglight Agent Manager (FglAM) where the SQL PI agents will be created
    
11. Fill in the SQL Server connection details where the SQL Server instance used as the SQL PI repository will be located, and then click the Next button
    
12. Choose the radio button to either create a new SQL PI repository or use an existing PI repository.  
13. Either use the default database name, primary file group, and transaction log location, or optionally enter a new value
14. Add a file directory location on the SQL Server instance to store 1m data. This folder must already exist on the server.
    
15. Click the Finish button
16. Click OK to create the repository
    
17. Click Monitor to begin creating the new agent
    
18. Click the button to either Add Another Database or Close the dialog when the agent creation process completes.
    
19. The new agent should now be created and after a few minutes data should be visible in the databases dashboard.
    

The following video details how to add a SQL Server agent with PI monitoring to a SQL Server PI repository.