May 12, 2011 at 1:06 am
Hello All,
I am trying to improve performance of the few queries which are causing most CPU used. which had caused us to restart the process and system down time.
can anyone help me to improve performance of the query. I have attached the execution plan
Thank you All
May 12, 2011 at 2:58 pm
Without knowing what the functions used in the query actually look like it's close to impossible to help you any further...
All I can say is: maybe the good old divide'n'conquer approach would help here...
May 13, 2011 at 11:50 am
Execute your query and then execute this query on another server
Select st.text,sp.* from sys.sysprocesses sp
cross apply sys.dm_exec_sql_text(sp.sql_handle) st
order by sp.cpu desc
it will tell you bottleneck
mostly only CPU usage depend on bad queries,provide queries and your plan link is not working
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 16, 2011 at 5:05 am
LutzM (5/12/2011)
Without knowing what the functions used in the query actually look like it's close to impossible to help you any further...All I can say is: maybe the good old divide'n'conquer approach would help here...
I addition, Can you llok at the indexes on users and labs tables?Whats the datatype of the VarId?
Can you post the query?
May 16, 2011 at 5:06 am
Queries, table and index definitions please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply