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.
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.
