How to slove performance issues in database table in Sql server. Please give me steps.

NAVINN T 20 Reputation points
2023-08-13T04:16:32.49+00:00

How to slove performance issues in database table in Sql server. Please give me steps.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 120.2K Reputation points MVP
    2023-08-13T08:20:54.6566667+00:00

    See https://www.sqlshack.com/sql-server-performance-tuning-tips-for-beginners/

    I have not read the article myself, but it was the top hit when I entered introduction to sql server performance tuning in the search box Google. There may be want to more hits that you want to pursue.

    If you have a specific problem you need help with, you are welcome to ask, but you need to share enough details so that we can help.

    0 comments No comments

  2. RahulRandive 10,401 Reputation points
    2023-08-13T12:49:44.23+00:00

    Hi @NAVINN T

    You can also check out these two community blogs to get started and explore.

    TSQL Scripts for Troubleshooting Common Issues with SQL Server

    SQL Server slow performance troubleshooting documentation expanded

    Thank you!

    0 comments No comments

  3. Javier Villegas 900 Reputation points MVP
    2023-08-14T12:26:57.4633333+00:00

    Hi @NAVINN T

    I will suggest you to take a look to Glenn Berry Blog and run his diagnostics script for a analysis.

    https://glennsqlperformance.com/

    Same for Brent Ozar First responder scripts

    https://www.brentozar.com/responder/

    Hope this helps

    Regards

    Javier

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.