February 15, 2023 at 9:01 am
Hi All,
Seeing slow INSERTS for a table. Its taking 3 secs for the inserting a row into the table.
The table has some triggers and bunch of check and Foreign key constraints.
We don't have control on this database design. It is a vendor specific database.
I have attached the table structures, row counts and other info like what indexes, triggers defined on the tables.
Also, seeing a lot of lock request timeout when trying access the table from GUI. Not sure how the app team is using this table
and how frequently they are going to changes to the table.
My questions.
Q) What should be the right questions to be asked in this situation to the app team?
Q) How to prove these triggers , constraints and datatype chosen and wide rows in the table is slowing down the performance ?
What are the alternative solutions for triggers ?
Q) What can be done to improve performance of this INSERT statement. We have pre-sized the db files and auto growth settings looks fine.
Appreciate your help on this. It looks more like application design issue to me.
What should be correct approach for troubleshooting this problem?
Regards,
Sam
February 15, 2023 at 12:52 pm
It's going to be the same as the other stuff we've been talking about. You have to capture metrics that show where the slow points are. Extended Events are your friends here.
"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
February 15, 2023 at 12:52 pm
It's going to be the same as the other stuff we've been talking about. You have to capture metrics that show where the slow points are. Extended Events are your friends here.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply