You are responsible for administering 30 SQL Servers located in various cities. You spend a significant amount of time each day logging into each server to check for new alerts. What can you do to ease this administrative burden?

206.

You are responsible for administering 30 SQL Servers located in various cities.
You spend a significant amount of time each day logging into each server to check for new alerts.
What can you do to ease this administrative burden?

Use the xp_alertrelay stored procedure

Configure the remote servers to use event forwarding

Set up Enterprise Manager to query each server for alerts

Use Query Analyzer to execute Transact-SQL code that checks for new alerts

View Description

Event forwarding allows for centralization, scalability and efficiency of SQL Server event monitoring