Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 More Use From Cpu for Faster Run Query

Author  Topic 

samira.emami
Starting Member

1 Post

Posted - 2015-03-08 : 03:24:48

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

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-08 : 04:49:17
Perhaps your query is io bound
Go to Top of Page

seshurtz
Starting Member

7 Posts

Posted - 2015-03-08 : 09:41:01
Hi samira.emami,

gbritton has a good point. I would take a further look into the IO statistics by using the command SET STATISTICS IO ON and take a look at the Output in the Messages section of your query results.

More information on that here:
https://msdn.microsoft.com/en-us/library/ms184361.aspx

Also, have you checked the execution plan?
This will give you insight into the most intensive operations within your query and give you an opportunity to see if a change could improve the execution.

Here's a nice video by Jes Borland from Brent Ozar Unlimited going over execution plans:
https://www.youtube.com/watch?v=I-jjgZ51_Sw

Hope this helps!

Steve Shurtz, MCP
Database Administrator
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2015-03-08 : 15:37:09
Do you have Resource Governor in place?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -