SQL Agent Insights:Documentation:Connecting to an Instance: Difference between revisions
| Line 27: | Line 27: | ||
The Connect to SQL Server dropdown will always contain any instances of SQL that have been enumerated. | The Connect to SQL Server dropdown will always contain any instances of SQL that have been enumerated. | ||
Post server/instance selection, toggle Windows Authentication on or off. Turning off Windows authentication will enable the SQL User and SQL Password textboxes for entry. | Post server/instance selection, toggle Windows Authentication on or off. Turning off Windows authentication will enable the SQL User and SQL Password textboxes for entry. | ||
|| [[File:manual-connection.png| | || [[File:manual-connection.png|thumb|frame|The Connection dialog showing examples of entering a SQL Server® instance manually.]] | ||
|- | |- | ||
|} | |} | ||
| Line 47: | Line 47: | ||
* No warning or critical logging of threshold breaches will occur within the Insight log. | * No warning or critical logging of threshold breaches will occur within the Insight log. | ||
{| style="background-color:#E9FBE5;border-style: solid; border-width: 1px; border-color: limegreen" cellpadding="3" | |||
|- style="color:limegreen;" | |||
| '''PRO TIP''' | |||
|- | |||
| | |||
Enable Start Insight in Maintenance Mode initially, until the configuration of all individual metric thresholds have been set to prevent unnecessary Insight logging and email notifications from occurring. | |||
Additionally, the option to starting all Insights in maintenance mode automatically can be enabled in SQL Agent Insight’s preferences. | |||
|} | |||
<hr> | <hr> | ||
Revision as of 02:05, 3 February 2023
Applies to: Error creating thumbnail: Unable to save thumbnail to destination SQL Agent Insight (all supported versions unless otherwise noted)
Connecting to an Instance of SQL Server®
This article will assist in connecting to an instance of SQL Server to start monitoring the SQL Agent in that instance quickly. There are multiple ways to connect to a SQL Server instance with SQL Agent Insight, including:
- Clicking on the New Insight button in the toolbar,
- Selecting New Insight… from the File menu,
- Double-clicking a server name from the list of Available SQL Servers, post enumeration,
- Double-clicking a server name from the list of Previously Connected Servers, or,
- Pressing the key sequence, CTRL+N
Depending on the action taken above, the server as it appears in the Connect to SQL Server dialog can be automatically populated.
| NOTE |
| The option to manually enter a server / instance name is always available; just start typing when the focus is in the Server dropdown menu of the Connection dialog. A successful connection will place that SQL instance into the Previously Connected Instances pane for quicker connections in the future. |
| When entering a SQL server instance name manually, ensure to follow SQL Server instance naming conventions. Additionally, if the SQL Server instance requires a specific port, it can be included after the instance name, separated by a comma.
The Connect to SQL Server dropdown will always contain any instances of SQL that have been enumerated. Post server/instance selection, toggle Windows Authentication on or off. Turning off Windows authentication will enable the SQL User and SQL Password textboxes for entry. |
 |
| NOTE |
| At the time of this writing, the user account (Windows or SQL authentication) must have sysadmin privileges for the SQL Server instance. |
After deciding on the authentication method (Windows or SQL), the connection dialog has an option to start the Insight in maintenance mode. Starting the Insight in maintenance mode has the following benefits:
- All metrics immediately go into a state of maintenance (they will appear grey within the Insight),
- No new alarms for this instance will appear in the dashboard,
- No email notifications are sent, if they are enabled for the Insight, and,
- No warning or critical logging of threshold breaches will occur within the Insight log.
| PRO TIP |
|
Enable Start Insight in Maintenance Mode initially, until the configuration of all individual metric thresholds have been set to prevent unnecessary Insight logging and email notifications from occurring. Additionally, the option to starting all Insights in maintenance mode automatically can be enabled in SQL Agent Insight’s preferences. |
Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8