February 6, 2025 at 10:54 am
bump for visibility.
and speed differences may be to do with settings on ssms vs vb.net
February 6, 2025 at 10:16 pm
I would check the connection settings - and verify ARITHABORT setting is the same for both. It definitely sounds like a different plan is being used when called from VB.NET vs SSMS and the ANSI settings can cause different plans to be generated.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 14, 2025 at 6:22 pm
how it is executed
This might be key... is this query executed many more times than others you might be comparing it too? If so, could the problem be an inability to get a connection from the pool? Just a guess.
This happened to me once in a .Net Core app, and it turned out that the query was being invoked many times as a page rendered, as certain conditions were evaluated and built up, where it should have been delayed until other stuff was set up and then invoked once.
The actual query contents were mundane/innocuous/not relevant to the problem...
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy