SQL Optimization

[Chaminda Bandara]

If my one of customer saying they could a generate a report withing 30 second before and now they have to wait for 3min so how I can track that as a Senior Technical Support Analyst that whether it is a database issue or programming issue ?

Chaminda Bandara

[Lost User]

Chaminda Aruna Bandara wrote:

as a Senior Technical Support Analyst

Use your skills and experience, and run some tests on the system. Has something changed recently, is the database server having problems, is the network slow ... ?

[Corporal Agarn]

Check the execution plan and the index fragmentation, to start.

Mongo: Mongo only pawn... in game of life.

[Mycroft Holmes]

If there have been no changes to the code base then it is a server issue, easy. You really should know if there have been changes to the code! There are a bunch of tuning possibilities that you should be aware/doing from degragging thee indexes to tuning the queries to checking disk space and fragmentation.

Never underestimate the power of human stupidity RAH

[Chaminda Bandara]

If we assume that the issue with indexes how can I optimize using indexes ?

[Mycroft Holmes]

I would use the execution plan to identify bottlenecks in the existing indexes and any missing indexes for the query, I would then defrag those indexes

Never underestimate the power of human stupidity RAH