Sentry Sentry 2.0 Guide de l'utilisateur

1 Cover Page QUICK START GUIDE SQL Sentry Quick Start 1©2015 SQL Sentry. All Rights Reserved.

Windows 8 Supported Operating Systems (x64) Windows Server 2008 Windows Server 2008 R2Windows Server 2012 Windows Server 2012 R

Monitoring Analysis Services with Performance Advisor requires SQL Server 2005 or higherIndexes tab and Fragmentation Manager require SQL Server 2005

7 Installation and Setup StepsOnce you receive your license and setup file download information, copy the setup executable to theserver on which you w

Only one Monitoring Service is required for your SQL Sentry Enterprise. Unless desired, there is noneed to install a Monitoring Service on any DBA wor

Click the Test button to validate the chosen credentials. After a successful test, click the Next buttonto continue the setup. Note: If an existing

For information on SQL Sentry Monitoring Service security settings see the SQL Sentry Security topics.Click the Test button to validate the chosen cr

Click below to proceed:Step 2: Complete the Setup Wizard7.2 Step 2: The Setup WizardLAUNCH THE SQL SENTRY CLIENTThe first time you launch the SQL Sent

Note: You may need to contact your network administrator first to ensure that the IP address ofthe Monitoring Service computer has been granted both

order to monitor SQL Server Agent Alerts with SQL Sentry. See SQL Server Books Online for moreinformation on tokens and security.2. SELECT CONNECTIONS

7.3 Step 3: Start Using the ClientCongratulations, you have successfully installed SQL Sentry, configured global notification settings,and are now rea

2 Table of Contents1. Cover Page 12. Table of Contents 2-33. Quick Start Guide 44. Important Concepts 5-65. Installation Recommendations 7-86. System

8 Additional Tasks OverviewADDITIONAL TASKSRefer to these topics for additional information on configuring SQL Sentry.Add Additional Users and GroupsM

any associated configured Conditions and Actions.Note: Immediately after adding a Connection or setting a Connection to watched status, SQLSentry will

disable the Send Email Action at the Connection level. This configuration would only apply to thatConnection and it would not affect any other server

Override This behavior can be thought of as a special set ofinstructions which are followed instead of the passeddown(inherited) instructions.Combine

For more information about Actions and Conditions please see the Alerting and Response Systemtopics in the SQL Sentry User Guide.8.3.2 How to Configur

3. Use the second drop-down list to select Top SQL Source. You should now see the Top SQLSource Settings that are being applied Globally.4. Change t

job on the calendar, then following the same steps as above to access and change the job's runtimethreshold settings.For more information about S

9 SQL Sentry Security OverviewThe Quick Start Guide covers the following topics related to SQL Sentry Security, including requiredpermissions for the

with SQL Sentry Performance Advisor.It is not necessary for this account to be a Domain Administrator account. Instead, it is recommendedthat the serv

1. Select the Services icon from Control Panel -> Administrative Tools.2. From the list of services select SQL Sentry Monitoring Service, then ri

10.3.1. Object Removal Script for Watched 2000 Servers 40-4610.3.2. Object Removal Script for Watched 2005+ Servers 47-5010.4. Watched Server Objects

User Connection Properties. The User Connection Properties for a Connection can be accessedthrough the right-click context menu of the Connection. Fir

Option DescriptionPass-through AuthenticationPass-through authentication enables Windows computers in different domains or in non-Windows network envi

the account exists in the local administrators group.Please see the Performance Advisor: WMI or Registry Access KB article for more information andcon

9.5 Non-Windows Network Environment SecurityIf you are not using Windows Active Directory for domain management, you may need to takeadditional steps

10 AppendixThe Appendix contains the following topics:SQL Sentry Performance AdvisorPerformance Advisor Security RequirementsPerformance Advisor Requi

"Services and Applications" in the Computer Management Client. On the Security tab, ensurethat the SQL Sentry Monitoring Service account has

that uses DCOM) connects to a target server initially using port 135, and the target responds with adynamic port number for WMI to use for the rest of

10.1.3 Performance Advisor Data Capacity PlanningPERFORMANCE ADVISOR DATA CAPACITY PLANNINGPerformance Advisor (PA) uses the SQLSentry database to sto

the two minute break level, or PerformanceAnalysisDataRollup2. The retention hours forthis, or any other break level, can be adjusted as needed.Reten

'PerformanceAnalysisDataRollup8','PerformanceAnalysisTraceData','PerformanceAnalysisPlan','PerformanceAnalysisPlanO

3 Quick Start GuidePURPOSE OF THIS GUIDEThis Quick Start Guide will quickly walk you through the basic Installation and Setup Steps for SQLSentry. Fol

10.3 Uninstalling SQL SentrySQL Sentry can be uninstalled through the Control Panel in Windows. When you uninstall the SQLSentry Client or Monitoring

WHERE(name=N'SQLSentry2.0QueueMonitor')IF(@JobIDISNOTNULL)BEGIN--Checkifthejobisamulti-serverjobIF(EXISTS(SELECT*FROM

dropprocedure[dbo].[spReadLogFile_20]ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[SQLSentryQueueLog_20]')andOBJ

dropprocedure[dbo].[spTrapAlert_20]ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[spSetupAlertsTrap_20]')andOBJEC

SELECT@ReturnCode=0--Deletethejobwiththesamename(ifitexists)SELECT@JobID=job_idFROMmsdb.dbo.sysjobsWHERE(name=N'SQLSentry2.

dropprocedure[dbo].[spQueueHeartbeat_20]ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[spQueueJob_Start_20]')andO

--Thereis,soabortthescriptRAISERROR(N'Unabletoimportjob''SQLSentryAlertTrap''sincethereisalreadyamulti-ser

10.3.2Object Removal Script for Watched 2005 andAbove ServersObject Removal Script for Watched 2005 and aboveUSEmsdbifexists(select*fromsys.obje

DECLARE@ReturnCodeINTSELECT@ReturnCode=0--Deletethejobwiththesamename(ifitexists)SELECT@JobID=job_idFROMmsdb.dbo.sysjobsWHERE(name

ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].[spQueueMonitor_20]')andOBJECTPROPERTY(object_id,N'IsProced

4 Important ConceptsSQL SENTRY COMPONENTSSQL Sentry consists of the Client (a thin client application), the Monitoring Service (a Windowsservice), and

COMMITTRANSACTIONGOTOEndSaveQuitWithRollback:IF(@@TRANCOUNT>0)ROLLBACKTRANSACTIONEndSave:GOifexists(select*fromsys.objectswhereobject

STORED PROCEDURES (MSDB):spGetBlockInfo_20EVENT MANAGER WATCHED SERVER OBJECTSWhen a SQL Server instance is watched by SQL Sentry Event Manager, the b

10.5 Standard Vs Enterprise EditionsPlease see this link for a Standard Vs. Enterprise feature comparison.SQL Sentry Quick Start 52©2015 SQL Sentry. A

11 The SQL Sentry User GuideFor advanced information on configuring and using SQL Sentry, please refer to the SQL Sentry UserGuide. The User Guide is

12 Contact InformationCUSTOMER PORTALAccess to the SQL Sentry Customer Portal is available around the clock, allowing you to retrieve abackup license

13 IndexAdd Users and Groups, 20Additional Tasks Overview, 20Appendix, 34Client Security, 29-30Contact Information, 54Cover Page, 1Customize Glo

System Requirements, 9-11ReferenceStandard Vs Enterprise Editions, 51-52Removing Watched Server Objects, 39-40Security and the SQL Sentry Client,

watching connections or objects. When you have SQL Sentry “watch” a connection or object via thecontext menu this simply means that SQL Sentry will be

5 Installation RecommendationsWHERE TO INSTALL THE SQL SENTRY COMPONENTSThe SQL Sentry Client, Monitoring Service, and SQL Sentry Database are typical

CLUSTERING SQL SENTRY MONITORING SERVICESMultiple Monitoring Services can be installed to handle more than 100 connections, and/or to provideautomatic

6 System RequirementsSQL SENTRY COMPONENTSSQL Sentry Client computer Windows version from supported list below Microsoft .NET 4.5 (included in the se