This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(179.20000000000002, 47%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES9%3C/text%3E%3C/svg%3E)
How to fix slower performance with Microsoft.Data.SqlClient.TdsParserStateObject ReadSniSyncOverAsync method when it has multiple calls (21) in a transaction with average execution time of 6116 ms per call and totalling to 128436 ms?
How is the issue going?
We are awaiting your reply and the latest updates at any time. If the answer solves your problem, please don't forget to 'Accept it.'
This will help others who have similar issues and assist us in closing this thread.
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
make the sql query faster. ReadSniSyncOverAsync() is waiting for a packet response from the sql server (result set). apparently the SQL Server does not return a result set until after performing a lot of work.
Hello, ShahSamir-9495
due to insufficient information, we are unable to analyze the specific execution process.
You need to perform a stack trace on the client side and conduct performance analysis on the SQL Server side. You can choose Profiler or XEvent to filter out long-running transactions and troubleshoot deadlocks and blocking issues.
There are many factors affecting performance, including but not limited to: server performance (CPU, I/O), network status, switching to asynchronous methods, whether indexes are properly established, and whether statistics are updated.
You can refer to this blog：https://www.red-gate.com/simple-talk/blogs/identifying-client-timeouts/
Best regards,
Mikey Qiao
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".