PrepAway - Latest Free Exam Questions & Answers

Which Transact-SQL statement should you use?

You are troubleshooting query performance on SQL Server 2008. You have profiler trace data in a table named PerfData. You need to determine which events are taking longer than one second of CPU time or run for more than two seconds.
Which Transact-SQL statement should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000 OR Duration > 2000 )

B.
SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000 OR Duration > 2000000 )

C.
SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000000 OR Duration > 2000 )

D.
SELECT TextData, Duration, CPU FROM PerfData
WHERE EventClass = 12 AND ( CPU > 1000000 OR Duration > 2000000 )

One Comment on “Which Transact-SQL statement should you use?


Leave a Reply