Multiple choice technology databases

You are gathering performance and optimization data for your SQL Server 2005 database. Your company has three custom applications that routinely make use of the database. Each application accesses the database using separate login credentials. You wish to gather information concerning the queries executed by each custom application. To gather this data you decide to create a trace using the SQL Server Profiler. You decide to use one of the predefined SQL Server Profiler templates to define what data should be gathered. Which predefined SQL Server Profiler template would best suit your requirements?

  1. TSQL_Duration

  2. TSQL_Grouped

  3. TSQL_Replay

  4. TSQL_SPs
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The TSQL_Grouped template in SQL Server Profiler groups trace information by the application name and login credentials, making it ideal for analyzing queries executed by specific applications.

Keep practicing — related questions