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?

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?

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 )



Leave a Reply 1

Your email address will not be published. Required fields are marked *