Enterprise Manager very slowly

Hi,
Is there any parameters to configure to improve the performance in the
Enterprise Manager ? I have installed 7 small databases but when I click in
the "Databases" option, for example, I need to wait for several seconds (I
don´t think this is right). There are other options with the same problem.
It´s occur and my two machines (and I already see this in other machines),
the first running Windows 2003 Server Standard RC2 and the second running
Windows XP Professional, both with SQL Server 2000 - SP3.
Any suggest ?
Vitor Mauricio de N. Silva
Rio de Janeiro - BrazilVitor
Have you check odbc trace is running?
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>|||Perfect. I had some databases with the option AUTO CLOSE clicked. After
changed everything works fine.
Thanks,
Vitor Mauricio de N. Silva
Rio de Janeiro - Brazil
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>