SQL Server Performance

Creating a Non-Cluster Index

Discussion in 'ALL SQL SERVER QUESTIONS' started by Ksr39, Oct 23, 2012.

  1. Ksr39 Member

    Hi Experts,
    I need a small help in creating non cluster index on a table as we were facing a performance issue. The issue was in one of our production server I found that the CPU utilization is going high in peak till 100% and its fluctuating, so I found some queries which are utilizing the CPU resource more, So I run these queries in tuning advisor and got the recommendations to create a non-cluster index on a table but here the index need to be create on a single table but on 18 columns out of 21 in which 1 is a cluster index and 4 are non-cluster index already created.
    Please suggest me what I need to do and.
  2. FrankKalis Moderator

    Sorry, but we need more information to provide any useful suggestion. The table structure with already existing indexes and maybe some queries that cause the high load would be beneficial.

Share This Page