Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ranjit2000
Starting Member
5 Posts |
 Posted - 2002-08-11 : 13:02:59
|
| You are database developer for your company's SQL Server 2000 database named Sales. The company has several custom Web-based applications that retrieve data from the Sales database. Some of these applications use the EXECUTE statement to allow users to issue administrator ad hoc queries. As the use of the Web-based applications increases, queries are taking longer to execute. You want to discover which applications are sending a high number of these queries to the database server. What should you do? A. Use SQL profiler to capture the RPC:Completed evemt. Group the trace by the HostName data column B. Use SQL profiler to capture the RPC:Completed evemt. Group the trace by the ApplicationName data column C. Use system monitor to monitor the SQLServer:Database counter. Select all counters for the sales database D. Use system monitor to monitor the SQLServer:General Statistics counter. Select all counters for the sales database |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-11 : 13:08:26
|
| We don't answer exam questions on SQL Team. |
 |
|
|
|
|
|
sql server 2000