January 29, 2014 at 10:34 pm
Hi Experts there is an issue on my production server where my cpu utilization is high.
Below are my configuration settings.
16 cpu with highperthreading enabled
Sp configure
Maxdop setting 12
Max server memory 32 GB
Windows and sqlserver 64 bit.
Cpu are always at more then 90 percent.
There are deadlocks errors on 1 table which might be the main cause.
Please let me know the requirements needed to get it into.
January 29, 2014 at 10:59 pm
Tune the code, tune the indexes
Chapter 3 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
and
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
January 29, 2014 at 11:07 pm
Hi Gail
Thankz for prompt reply the queries which are accuring in the dead locks are an undate satements which is a single line update statements can we put rowlock or there is an clustered index with primary key on it can I drop and create it as a moncluster index on as it these table is being highly utilized with insert upadate and delete.secondly there is an implicit conversion for some queries which is making index to scan instead of seek.
Also the adhoc cache is 43 % used with 35 being ised by prepared.
Kindly suggest.
January 29, 2014 at 11:15 pm
samsql (1/29/2014)
Kindly suggest.
Tune the code, tune the indexes (or get a consultant in to do so). See the book and articles I referenced to guide you.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply