0

my problem is server CPU and ram goes to 100% .

Is any problem in my indexing i had checked the index size by googling that the size is nearly 100 GB (94582.4 MB). what is the issue and its problem to server and SQL performance.

TheGameiswar
  • 27,855
  • 8
  • 56
  • 94
arun kumar
  • 1
  • 1
  • 1
    `what is the issue and its problem to server and SQL performance` a million dollar question isn't it? :) if we all could get answers for this question from online platforms no one will be hiring SQL Server consultants or even DBAs :) . – M.Ali Sep 14 '17 at 08:34
  • 2
    [How to analyse SQL Server performance](http://rusanu.com/2014/02/24/how-to-analyse-sql-server-performance/) – Remus Rusanu Sep 14 '17 at 08:37
  • @RemusRusanu thank u for your suggestion – arun kumar Sep 14 '17 at 09:27

0 Answers0