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 TransactSQL
statement should you use?
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 )