SQL server related

Prathap G

6y955

Hi All,

Q) We have a SQL server-based application and we have some performance issue, How you will handle those performance issues, How will provide a more efficient way and how will do that???

Q) How can we handle maximum records in a single table??

Please reply to these queries and help with this.

Please help with this.more help for me.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
hi

If you ask for performance of a stored procedure or some query performance.

Please provide some query

Thanks and regards
+1
Jignesh Kumar6y ago
Hi,

Please use SQL server Execution plan to understand Query Performance where it is taking more time,
use below link which will help you,
https://www.c-sharpcorner.com/article/improve-stored-procedure-performance-in-sql-server-store-procedure-performance/
+1
Atul Warade6y ago
Hi Pratap,

One more URL you can refer

https://dzone.com/articles/6-simple-performance-tips-sql
+1
Atul Warade6y ago
Hi Pratap,

Please find below URL it will help you to increase sql query performance

https://www.developer.com/db/slideshows/10-ways-to-improve-sql-query-performance.html
+1
Rajanikant Hawaldar6y ago
Hello Pratap Veera, below links might help you.
https://stackoverflow.com/questions/3779088/database-that-can-handle-500-millions-rows
https://www.mssqltips.com/sqlservertip/1200/handling-large-sql-server-tables-with-data-partitioning/
https://mstechtalk.com/sql-server-performance-issues-and-solutions/
https://dzone.com/articles/10-ways-to-speed-up-your-aspnet-mvc-application
https://redmondmag.com/articles/2004/04/01/speed-up-your-aspnet-pages.aspx
https://blog.sqlauthority.com/2016/12/06/sql-server-speed-performance-without-code-change/
+1
Farhan Ahmed6y ago
https://dzone.com/articles/10-ways-to-speed-up-your-aspnet-mvc-application
+1