What should you do to identify both the server process ID and the start time of the oldest active transaction
You manage a database named DB1, which is located on a SQL Server 2005 computer. You receive a warning that the drive on which the DB1 log file is located is near capacity. Although the transaction log is backed up every five minutes, you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate.
You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do?
What should you do to identify both the server process ID and the start time of the oldest active transaction
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of a database named CK_Data that is situated on a SQL Server 2005 computer named Certkiller -DB03. As the administrator you receive a warning that the drive on which the CK_Data log file is situated is near capacity. The transaction log is backed up every five minutes. You notice that this is steadily growing. You suspect that an uncommitted transaction may be the reason and you want to investigate it. You want to identify both the server process ID and the start time of the oldest active transaction in CK_Data.
What should you do?
What should you do to ensure that your attempt to resolve the problem has the least possible impact on network
You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a file server named Certkiller -SR10 and a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
Domain.com users in the Accounts department use a proprietary application to access the CK_Sales database. After a few months Domain.com users in the Accounts department complain that the application takes a considerable amount of time to perform certain operations. You need to determine which queries that are used by the application are performing poorly. You intend to use SQL Server Profiler to replay the queries. You need to ensure that your attempt to resolve the problem has the least possible impact on network performance and the performance of Certkiller -DB01.
What should you do?
What should you do to get information about each participant in the deadlock?
Domain.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application. You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock.
exhibit What should you do?
What should you do to get data regarding every participant in the deadlock?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database named Certkiller -DB03.
You have received several reports from users’ stating that they received deadlock error messages in an order processing application. You monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want data regarding every participant in the deadlock.
What should you do?
What should you do to monitor which objects and SQL Server session IDs are involved when deadlock conditions o
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB03.
You have received a report from the Domain.com users that they receive deadlock error messages in an order processing application.
You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You also want information about each participant in the deadlock.
What should you do?
What should you do to improve performance of the CK_Sales database by implementing database snapshots?
You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all clients run Windows XP Professional.
The Domain.com network contains a database server named Certkiller -DB01 that is running SQL Server 2005, Standard Edition. Certkiller -DB01 contains a database named CK_Sales which is used to store data for the Sales department. Members of the Sales department usually access CK_Sales at the start of the day. You want to improve performance of the CK_Sales database by implementing database snapshots. However, the Snapshot Agent is not available in SQL Server Management Studio.
What should you do?
What should you do to revert the CK_Catalog online database to the CK_catss_thursday snapshot?
You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all clients run Windows XP Professional.
The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 contains a large database named CK_Catalog which is updated every Monday and every Thursday. An online version of the CK_Catalog database is available to customers on the Domain.com e-Commerce Web site. Clive Wilson, the Webmaster of the Domain.com e-Commerce Web site is responsible for updating the online version of the CK_Catalog database. To optimize performance of the CK_Catalog online database, you create database snapshots at 5:30 PM every Monday and every Thursday. Each time you create a new snapshot, you delete the snapshot from the previous week. The two snapshots are named CK_catss_monday and CK_catss_thursday. One Tuesday morning Clive Wilson informs you that he imported the wrong data into the CK_Catalog online database. You need to revert the CK_Catalog online database to the CK_catss_thursday snapshot and allow Clive Wilson to import the correct data.
What should you do?
What are two possible ways to achieve this goal?
Domain.com uses SQL Server 2005. A user reports that an order processing application stopped responding during a transaction. You investigate and discover that the user’s session, which is session ID 85, is being blocked by an errant process. The session ID of the errant process is 101. You need to solve this blocking situation quickly so that the user can continue using the application without losing any work. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
What should you do to create the appropriate objects that support the reports?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include the administration of a SQL Server 2005 database named Certkiller -DB02.
Certkiller -DB02 provides the clients with their banking information. The CIO wants the clients see the investment reports that combine the information retrieved from Certkiller -DB02 with real-time investment information that comes from a Web service provided which is provided by a third party. You need to ensure that the investment information is current when the reports are executed. You need to create the appropriate objects that support the reports.
What should you do?