You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. Domain.com has its headquarters in Chicago and branch offices in Dallas and Miami. You work in the Miami office. Head office contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
Several Domain.com users in the Miami office start complaining about difficulty in connecting to the CK_Sales database. You discover that connection between the clients and Certkiller -DB01 is being terminated. You need to determine the cause of the network connectivity problem as quickly as possible. Unfortunately, the administrator at the Chicago office is on sick leave and you are unable to travel to the Chicago office. You need to access Certkiller -DB01 from your administrative computer.
What should you do?
A.
Open the Event Viewer and connect to Certkiller -DB01 and review the System and Application logs.
B.
Open the SQL Server Management console and review the SQL Server Agent log.
C.
Run the Network Monitor and capture network traffic to and from Certkiller -DB01.
D.
Open the SQL Server Management console run the SQL Server Profiler.
Explanation:
you can use the Event Viewer to connect to a remote server and review the logs on the remote server. Client connectivity problems will appear in the Application log and the System log.
Incorrect Answers:
B: The SQL Server Agent log records events related to the SQL Server Agent service. The SQL Server Agent service is not responsible for network connectivity to the database server.
C: The Network Monitor is used to capture an analyze network traffic. It does not provide information related to the cause of network connectivity problems.
D: The SQL Server Profiler is used to monitor server and database activity but not network connectivity issues.