June 24, 2008 at 9:03 am
I’m trying to run a good sized query on the production database. I’m consistently getting ODBC errors. The error consists of various numbers of “error in TDS stream”, “TDS buffer length too large”, and “Unknown token received from SQL Server”. I did the obligatory web search and it seems like I’m running across some asynchronous issues with the ODBC driver. It surprises me that query analyzer would use an ODBC connection as opposed to a native driver.
Has anyone seen this error? Know of a way to fix it?
June 25, 2008 at 9:55 pm
I saw such errors.
One of our servers has a limitation on amount of data returned to a client.
If any connection exceeds this limit server blocks further communications from this connection.
QA keeps connections open until you close corresponding window. Every time you run a query from the same window amount of data transferred adds to previously accumulated statistics.
Solution:
1) Don't run test queries on Production. There should be DEV or/and TEST server for this.
2) Avoid fat non-selective queries.
3) Once you've got such message move queries to a new QA window and keep working from there.
_____________
Code for TallyGenerator
June 26, 2008 at 8:00 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply