Properties

Why is it on some sql server 2000 machines - sp3a, running windows 2000,
all being similar in hardware setup, speed, memory, etc that it really
takes long to return a properties screen or simply right click to
disconnect? Curious, any ideas?
Thanks
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!"Dave Brooks" <dbrooks@.neca.org> wrote in message
news:uW9y8Jo6DHA.1636@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Why is it on some sql server 2000 machines - sp3a, running windows 2000,
> all being similar in hardware setup, speed, memory, etc that it really
> takes long to return a properties screen or simply right click to
> disconnect? Curious, any ideas?
> Thanks
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

---

If you're talking about slow access through Enterprise Manager, then one
cause could be that there are databases on the server which are set to
auto-close; another possibility is that you have ODBC tracing enabled.
Simon