Azure SQL Database
An Azure relational database service.
5,444 questions
Database Performance Issue with UPDATE on SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 12%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Craig Sorochuk
1
Reputation point
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.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,591 Reputation points2021-03-01T07:17:52.423+00:00 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