Slow DB queries with MS-SQL

Hi,

We are running CI and and MS-SQL however when doing a sql query such as select * from tblTest, it can take over 22 seconds to get a result back (of say 17,000 rows) compared to the same query run in sql studio returning in less than 2 seconds the result.

We are running on windows 2003 server, apache 2.2, php 5.3.5 with microsoft drivers and CI 3.1.0.  MS-SQL is installed on a seperate server but running the MS studio locally or on a client the time difference is still over 20seconds.

Any clues as to what is causing the delay.