Database Performance Issue with UPDATE on SSMS
I am executing the simplest of UPDATE queries UPDATE pitch_data SET TEAM_HOME = HOME_TEAM; using SSMS/Azure, and on a dataset of only 123,000 rows, it is taking 3 minutes to complete. The same query on a local, slower, 2-y old laptop is executing in 30 seconds using MySQL. Any suggestions on possible performance reasons for this would be appreciated.
Hi @Craig Sorochuk , welcome to Microsoft Q&A forum.
There could be multiple factors which can cause slow queries like updating non-clustered index fields, current tier of Azure SQL database and other factors.
Would it be possible for you to provide the Create Script of the table which you are updating and we can try to replicate the issue at our end? Also if possible please share the configuration of Azure SQL Database.
Sign in to comment