Query Analyzer Extremely Slow on New Server

Hello,
I'm transferring databases to a new server and noticed QA's performance
is very, very slow when querying against it. However, when I use the
same exact query in QA against the original server the results take
only a few seconds to return.

=============
Server 1: Win server 2000, 2 processors, 2 GB RAM, 100MBs adapter
Server 2: Win server 2003, 4 processors, 4 GB RAM, 1Gbit adapter.

SQL 2000 on both, and both configured exactly the same except # of
processors and MB RAM limit.

Both servers are on the same network, the same distance from the client
PC (~10 miles), and located in the same room.
=============

Both databases are identical and data is in synch on both (server 2's
database was created using last night's backup from server 1).

Query is the same: SELECT * FROM tbl1
Response time on server 1 = ~10sec, server 2 = ~4min 30 sec.

And, last, if I remote into server 2 and run the query locally in QA,
response time is ~2sec. Or, is I "Right-click --> Open" the table from
the client's QA it opens almost instantly. Only when I select * only
on server 2 is the response time extremely slow.

I've scoured these boards and haven't found anything out of whack. Any
help would be hugely appreciated!!

Thank you,
Cory

.

Relevant Pages

  • Re: Duplicating a database
    ... alternative to get a Query environment. ... on his OLTP, ... MVP SQL Server ... >>> of those databases. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Performance Benchmarks?
    ... Are attribute relationships defined properly on the dimensions? ... If you run Profiler against the server, how long is spent in "Query ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... the OWC10 with 3 dimensions on the row axis, ... The largest size of any of these 4 dimensions < 360 members. ... Performance Guide to optimize the query, the cube, the server, etc. ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)