• That question is way too broad to be answered in just a few lines.

    First of all you have to set-up monitoring so you know where things go wrong. You have to find the bottlenecks.

    And then you have to remove these bottlenecks one by one.

    A good resource:

    SQL Server 2012 Query Performance Tuning

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP