Overhead using SDAC to access SQL
Posted: Tue 03 Apr 2007 15:44
I was testing protocol overhead using SQL Profiler vs QueryAnalyzer. What part of SDAC can I use to get rid of all the overhead that becomes form using high level componets?
The bigest problem is when using sp_bindsession. SDAC automatically calls COMMIT/ROLLBACK TRAN (and forces binding transaction to be completed, what I don't want to be done). How can I force SDAC not to call anything without explicitly saying (e.g. using native SQL)
Regards,
Frenk
The bigest problem is when using sp_bindsession. SDAC automatically calls COMMIT/ROLLBACK TRAN (and forces binding transaction to be completed, what I don't want to be done). How can I force SDAC not to call anything without explicitly saying (e.g. using native SQL)
Regards,
Frenk