Windows 2003 Terminal Server R2

micheldumenil · Post by **micheldumenil** » Mon 10 Mar 2008 17:31

I use sdac 3.80 with delphi 5 and MS Sql Server 2000. With Windows Xp there are no problem but when I want to execute my sotfware on Windows 2003 with Terminal Server R2 under Remote Console, I have performance problems (when open the MSTable or MSQuery). With Windows 2003 TSE R1, the performance are better. I have test the sdac 4.35 trial version and the problem of performance is not resolve. Can anybody help me.

Antaeus · Post by **Antaeus** » Wed 12 Mar 2008 07:52

Could you specify, for what else operation except fetch you have been observing the performance loss? What tool have you been using for measurements? What is the difference in performance (in seconds or in percent)? What are the exact client versions on each of the operating systems? You can see it in the Info sheet of TMSConnection Editor at design time. At runtime you can read the ClientVersion property of the TMSConnection component.

Are you sure that this performance loss is not related to network, setting of your operating system, firewall, or something else?

micheldumenil · Post by **micheldumenil** » Wed 12 Mar 2008 08:59

The performance loss for operation like "select * from". I use DBMonitor for measurements. The operation take 15 seconds on Windows 2003 sp2 Terminal Server and less than 1 second on Windows XP. On Windows XP, I use "Microsoft SQL Server: 08.00.0760" and "Microsoft OLE DB Provider for SQL Server: 08.00.1117". On "Windows 2003 sp2 Terminal Server", I use "Microsoft SQL Server: 08.00.0760" and "Microsoft OLE DB Provider for SQL Server: 08.10.3959". Note that with "Windows 2003 sp1 Terminal Server", the performance is better ("Microsoft OLE DB Provider for SQL Server: 08.10.1830").
I'm sure that this performance are not related to network, firewall or something else.

Antaeus · Post by **Antaeus** » Fri 14 Mar 2008 15:02

Thank you for information. I could not reproduce the problem.
Please send me a complete small sample at sdac*crlab*com to demonstrate it, including script to create and fill table.