How would you configure the ABC_Prod database?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that contains a database named ABC_Prod. Recently ABC_Prod has frequently become
deadlocked. You have received instructions from management to have the database log
information when it becomes deadlocked.
How would you configure the ABC_Prod database? (Choose TWO)

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that contains a database named ABC_Prod. Recently ABC_Prod has frequently become
deadlocked. You have received instructions from management to have the database log
information when it becomes deadlocked.
How would you configure the ABC_Prod database? (Choose TWO)

A.
You should consider running the SQL Profiler.

B.
You should consider configuring startup parameters using trace flags.

C.
You should consider configuring SQL Server Auditing.

D.
You should consider using the Transactions Log.

E.
You should stop and restart the SQL instance.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *