SQL Performance Optimization 1-Week Assesment

Itadel A/S

Azure SQL, Azure SQLaaS and related applications health check, performance review, and optimization

1 Content The goal of this review is to pin-point possible performance issues, non-optimal configurations, misuse or the lack of system intended to present recommendations based on the data collected, with the intent of mitigating findings if any. Mitigating actions prioritized by impact effort following recommendations handover, hours estimated separately. Azure SQL, Azure SQLaaS and related applications health check, performance review, and optimization fine tunes your Azure SQL services for optimal performance.

2 Steps SQL Server performance data collection, analysis and recommendations of Performance Resources. Furthermore, we pool data gathering. * Changes regarding the Performance Agent installation and access to the Performance Tool environment * Installations of Itadel Ithana Performance Agents (close to none performance overhead) * Normally 2+ weeks of data collection * Customer expectations conference Data analysis Analyze the collected data * Pin-point possible performance issues or bottlenecks. * Are performance issues related to the SQL Server and/or Application design? * Are performance issues related to certain user queries or is it a general issue? Recommendations * Recommend actions based on the collected data. * Deliver findings and recommendations. * Next step action plan

3 Cost We estimate normal spend round less than a week to do this review and will be able to do the run-through asap hereafter. Price: Initial investigation until result handover, ranges approx. 20 hrs. Mitigating actions according to separate agreement.

More information

https://www.itadel.dk/lp/database-performance

https://store-images.s-microsoft.com/image/apps.14208.71b382d6-8f6d-4d52-a42b-83180b44d64e.b16f4d6e-f449-4a9d-8417-514d7baccacd.fd8ba11f-19f4-4694-a2f7-707afb692443
https://store-images.s-microsoft.com/image/apps.14208.71b382d6-8f6d-4d52-a42b-83180b44d64e.b16f4d6e-f449-4a9d-8417-514d7baccacd.fd8ba11f-19f4-4694-a2f7-707afb692443
https://store-images.s-microsoft.com/image/apps.25782.71b382d6-8f6d-4d52-a42b-83180b44d64e.b16f4d6e-f449-4a9d-8417-514d7baccacd.49915723-e926-49d1-838b-1d9e693a7638
https://store-images.s-microsoft.com/image/apps.61868.71b382d6-8f6d-4d52-a42b-83180b44d64e.b16f4d6e-f449-4a9d-8417-514d7baccacd.a9e9fa43-86a0-4abb-b027-80a71a96b044