We have Windows Advanced Server 2000 and SQL Enterprise Edt. 2000. Our application is client-server application.
On server we have Server Components they use - IIS, COM+, message queueing and SQL.
On client side is VB 6.0 client. Client sends XML request to our IIS.
Now, we are trying to do migration from 2000 to 2008 Environment (x32).
We install Windows Enterprise Edt. 2008 and SQL Enterprise Edt. 2008 R2.
DBA did conversion of our 2000 database, and now it is on SQL 2008 R2.
On server we also install Server Components they use IIS 7, COM+, message queueing and SQL.
We have problems with big quantity of data.
On server, through SQL Analyser - when we send a query - it works - very quickly.
On client when we send same search it fails. It depend on question, client sometimes failed after 30 sec, sometimes after 50 sec.
I don't know where to start looking?
I check IIS 7, time out, etc.
- could it be that SQL 2008 R2 sends some other type of data, then client expects?
- could it be some xml parser error?
- or somewhere on Windows 2008 or IIS ?
This looks for me like "cloudy" question, but pls if anyone have some idea let me know.
thank you for your time,
View Complete Post