March 8, 2015 at 12:03 am
My Server have Good CUP and Memory
When I Run a Query Cup usage is 30% and query Execution time is 30 Sec
Why Instead Query Execution time Increase SQL Not Use Cup More for Run Faster
March 8, 2015 at 4:40 am
Because MSSQL is waiting for another resource eg. disk, etc. You could use sp_whoisactive to check on what resource the MSSQL is waiting or extend events.
March 9, 2015 at 6:24 am
Your process is not hung on CPU. You may need more memory, faster, or more, disks, or a faster network. You can use sys.dm_os_wait_stats to understand what precisely is causing your server to run slow. You can also query that DMV before and after a query runs to get an understanding of what that query is waiting on. Since you're on 2014, you can also use extended events to capture wait metrics for a specific query.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 9, 2015 at 12:25 pm
samira.emami.g (3/8/2015)
My Server have Good CUP and MemoryWhen I Run a Query Cup usage is 30% and query Execution time is 30 Sec
Why Instead Query Execution time Increase SQL Not Use Cup More for Run Faster
CPU time is most definitely not the problem here. Memory could be. It could also be the query is badly written.
We need to see the query to make a more informed decision.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply