70-463 · Question #246
70-463 Question #246: Real Exam Question with Answer & Explanation
The correct answer is B: Processor\% Idle Time. The Processor: % User Time value “Corresponds to the percentage of time that the processor spends on executing user processes such as SQL Server.” In other words, this is the percentage of processor non-idle time spent on user processes If the Processor:% User Time high values ar
Question
Options
- ASQLServer:SSIS Pipeline 10.0:Buffers in use
- BProcessor% Idle Time
- CSQLServer:SSIS Pipeline 10.0:Buffers spooled
- DSQLServer:SSIS Pipeline 10.0:Private buffer memory
Explanation
The Processor: % User Time value “Corresponds to the percentage of time that the processor spends on executing user processes such as SQL Server.” In other words, this is the percentage of processor non-idle time spent on user processes If the Processor:% User Time high values are caused by SQL Server, the reason can be non- optimal SQL Server configuration, excessive querying, schema issues, etc. Further troubleshooting requires finding the process or batch that uses so much processor time processor-user-time-processor-privilege-time-total-times-thread-metrics/
Community Discussion
No community discussion yet for this question.