PrepAway - Latest Free Exam Questions & Answers

Tag: sql trace cpu threshold exceeded

What should you do?

You are the SQL administrator for your company. A SQL Server 2008 instance named SQL1 contains severalproduction databases.
Because of the number of users accessing the databases, performance is the primaryconcern.
You configure a SQL trace that monitors the CPU Threshold Exceeded event class.
After the trace is running forseveral days, the trace does not generate any warnings of the condition.
You are concerned that the thresholdthat was specified is too large.
You want to reset the threshold to its default value. What should you do?