SQL Server Performance

cpu utilization

Discussion in 'Getting Started' started by rmd.jilan, Dec 23, 2010.

  1. rmd.jilan New Member

    my sql server cpu utilization reached to 80% how to troubleshoot and how can i improve the performance?
  2. Luis Martin Moderator

    Welcome to the forums.
    1) What OS and SP do yo have?
    2) What SQL and SP do you have?
    3) What tool are you using to measure CPU?
    4) What is your hardware?
    5) Is SQL Server dedicated?
  3. rmd.jilan New Member

    windows server 2003 service pack2sql server 2005 enterprise edition
  4. Luis Martin Moderator

    [quote user="rmd.jilan"]windows server 2003 service pack2sql server 2005 enterprise edition[/quote]
    Thanks for answering 1) and 2) questions.
    Now, could you do the same with 3), 4) and 5)?
  5. satya Moderator

  6. Sdyckes New Member

    Paul Randal has some great info on CPU utilization as well as troubleshooting ideas. His most recent posts may give you some great incite.
    http://www.sqlskills.com/blogs/Paul/
    Stephen

Share This Page