Which statement is true?
You are the database administrator for your company and manage all the company’s SQL Server 2008 databases.
The production database named Prod1 contains all the product and sales data for the company. Database users complain that the database performance has degraded.
You must diagnose the problem andtune the database by using the Database Engine Tuning Advisor.
You create a workload by using SQL Server Profiler and want to use this workload to tune the database using theDatabase Engine Tuning Advisor.
Which statement is true?
What should you do?
You are the SQL administrator for your company. You manage two SQL Server 2008 instances named SQL_Prod and SQL_Test.
You have configured data collection to occur on both instances.
The instances uploadthe data collection set data to the Management Data Warehouse located on SQL_Test.
A non-cached data collection set named Perf_collection that you created runs on a schedule to collect data from SQL_Test.
However, you notice that the performance of SQL_Test is adversely affected when Perf_collection runs.
You decide to configure Perf_collection so that different schedules are used for data collection and upload.
What should you do?
Which Transact-SQL statement should you run?
You are the database administrator of your company. You need to manage the resource usage on an instance of SQL Server 2008 named SQL1.
You decide to enable the Resource Governor. Which Transact-SQL statement should you run?
Which data type should you use to replace the text data types in the application?
You are the database administrator for your company. You upgrade a SQL Server 2000 computer named SQL1 to SQL Server 2008.
You configure the SQLServer:Deprecated Features performance object to monitor the useof features that have been deprecated in SQL Server 2008.
During the monitoring process, you discover that the text , ntext , and image data types are being used in an application on SQL1.
You want to modify the data types in the application to ensure that these data types are not encountered by the SQLServer:Deprecated Features performance object.
Which data type should you use to replace the text data types in the application?
What should you do?
You are the SQL administrator for your company. A SQL Server 2008 instance named Prod contains allproduction databases.
You use the Resource Governor to manage resource usage on Prod . You configure a new resource pool and workload group.
Later that day, you discover that the new workload is notbeing enforced. What should you do?
Which system stored procedure should you use?
You are database administrator for your company. You manage an instance of SQL Server 2008 named SQL1.
You create a new trace for tracing server-level events by using the sp_trace_create system stored procedure on SQL1.
Next, you want to start the trace. Which system stored procedure should you use?
Which two performance monitor counters should you monitor?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL3 contains a databasenamed Sales.
The Sales database is accessed throughout the day. You need to monitor the amount of I/O generated by the instance.
Which two performance monitor counters should you monitor? (Choose two. Each correct answer represents partof the solution.)
Which performance monitor counters should you add in the counter log?
You are the database administrator for your company and manage all the company’s SQL Server 2008databases. Database users report that overall performance of the database has degraded. You suspect that lackof memory is the cause of the degrading performance. Before you add memory to the SQL server, you want to monitor the amount of memory used by SQL Server. Which performance monitor counters should you add in the counter log? (Choose three.)
What is the recommended action you should take to start global trace flags?
You manage an instance of SQL Server 2008. You discover some deadlocks on one of the databases stored inthe instance.
You want to start the global trace flag 1204 to obtain information about locks and resourcesparticipating in these deadlocks.
What is the recommended action you should take to start global trace flags?
Which performance object should you use?
You manage an instance of SQL Server 2008 named SQL1 . You install an Online Transaction Processing(OLTP) database application on SQL1 .
You want to monitor how server performance is affected by a large number of users connecting anddisconnecting from SQL1.
You want to identify the number of users connecting and disconnecting per secondfrom SQL1. Which performance object should you use?