How do I optimize my Database query to respond fast?

Anonymous
2024-10-08T06:31:58+00:00

Hello,

I have an application that runs on Asp.Net and MSSQL server. But the database grows constantly. Now it has gotten to the point where the sql request takes time to respond making the page load to take upto 60 seconds or more to respond.

Please, I there any solution for this type of my issue?

Windows Server High availability

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2024-10-09T01:13:23+00:00

    Hello,

    Thank you for posting in Microsoft Support Community. Based on the description, I understand your question is related to SQL Server.

    Since SQL Server is not currently supported in the Microsoft Support Community, it is recommended to repost your question in Microsoft Q&A.

    https://learn.microsoft.com/en-us/answers/questions/

    Click the "Ask a Question" button in the upper right corner to post your question and select the "SQL Server" tag.

    Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

    0 comments No comments