PrepAway - Latest Free Exam Questions & Answers

What should you do first?

You are the administrator of a SQL Server 2005 computer named SQL1. Users report that SQL1 is not responsive. You discover that SQL1s network segment is heavily utilized. You cannot connect to SQL1 by using the graphical SQL Server administrative tools. You suspect that SQL1 is the target of a Denial of Service (DoS) attack. You need to connect to SQL1 to examine the current activities. What should you do first?

PrepAway - Latest Free Exam Questions & Answers

A.
Restart SQL1.

B.
Stop and restart the SQL Server service on SQL1.

C.
Use the dedicated administrative connection to connect to SQL1.

D.
Use SQL Server Profiler to connect to SQL1.

Explanation:
SQL Server 2005 provides a special diagnostic connection for administrators when standard connections to the server are not possible. It allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests. This dedicated administrator connection (DAC) is available and supported through the command-line interface, sqlcmd, using a special administrator switch (-A).


Leave a Reply