October 8, 2018 at 7:53 pm
Hello everyone,
I have a web app for a school, which runs student term marks report. The same report for a student from one grade runs for 4 sec and for another grade runs for 40 sec. There are about 30 separate queries running. Number of students, subjects and mark records is the same in both cases. I rebuilt indexes and stats.
Taking in account I'm not very experienced with performance tuning, how can I find what affects performance in the second report?
Thanks a lot.
October 9, 2018 at 3:13 am
Bit outdated, but still usable.
https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/
https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-2/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2018 at 4:06 am
Capture the query metrics to understand which queries are running slow. Extended Events are your friend. Then, for the queries that are slow, look for common code smells and, if necessary, the execution plans to figure why they are running slow. That's pretty much it. Query tuning in a nutshell.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 9, 2018 at 9:30 pm
Thank you guys. Will check and report the results.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply