SQL Server Client bad Performance

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Philippe (Philippe_at_discussions.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 06:45:03 -0700

Hello,

I have an issue when I use both SQL Query Analyzer and Enterprise Manager.
The performance is very very bad.
At Enterprise Manager level, it lasts about 1 minute when I connect to server.
When I try to unfold to display the databases I don't get any answer even if I wait 1 hour.
At SQL Query Analyzer, any requests is very very long (for instance 15 seconds for the following request : select * from TableX ... even if TableX contains only 30 records).
My collegues that use the same databases on the same server don't have any problem then I assume that this is a client problem inside my PC. However I have the same configuration as my collegues (SQL Server 8.00.760 SP3a).
I don't have any trouble with any other application (ORACLE for instance).

Can anybody helps me ?

Philippe.

Relevant Pages

  • Re: sql server 2000 tools
    ... First you need to register production server with your username and password ... You don't need to access *.ldf files ... Then you should do a Transaction Log backup from Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver.odbc)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver)
  • Re: SA can not create users
    ... I also thought it may be enterprise manager but if I register different ... server on same enterprise manager I am able to create users for that new ... Simon Hayes wrote: ... >client tools completely. ...
    (comp.databases.ms-sqlserver)
  • Re: Processadmin problems
    ... Enterprise Manager was written a little earlier than some of the function ... > our server as well as by support personnel for the application. ... > This login had been a member of the sysadmin fixed server role but I ...
    (microsoft.public.sqlserver.security)