EM very slow..

Hi all
When I select properties for any object within EM, i have a major delay of
around 10-20secs at times, this is very strange indeed. The sqlserver 2k
sp2 instance is running on a win2000 cluster, san storage, nothing amazing
really. I cant seem to work out what is going on here, will revist profiler
late tomorrow, but anyone else experienced this?
Cheers
CkDo you have Autoclose ON?
--
Andrew J. Kelly
SQL Server MVP
"Chris K" <dsfdsf> wrote in message
news:3f6d3fda$0$23607$5a62ac22@.freenews.iinet.net.au...
> Hi all
> When I select properties for any object within EM, i have a major delay of
> around 10-20secs at times, this is very strange indeed. The sqlserver 2k
> sp2 instance is running on a win2000 cluster, san storage, nothing amazing
> really. I cant seem to work out what is going on here, will revist
profiler
> late tomorrow, but anyone else experienced this?
> Cheers
> Ck
>|||Does it only happen on 1 machine or from any client? Are you using TCPIP
or NetBios?
--
Andrew J. Kelly
SQL Server MVP
"Chris K" <dsfdsf> wrote in message
news:3f6dc101$0$23590$5a62ac22@.freenews.iinet.net.au...
> Hi Andrew
> This is the first option I checked, and no unfortunatly. Ill run some
> traces when I get a chance next.
> Cheers
> Ck
>|||Perhaps you are on a machine where ODBC tracing is on?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Chris K" <dsfdsf> wrote in message news:3f6dc101$0$23590$5a62ac22@.freenews.iinet.net.au...
> Hi Andrew
> This is the first option I checked, and no unfortunatly. Ill run some
> traces when I get a chance next.
> Cheers
> Ck
>|||I still suggest that you check if ODBC tracing turned on the machine which runs EM.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Chris K" <dsfdsf> wrote in message news:3f6e2e82$0$23597$5a62ac22@.freenews.iinet.net.au...
> Hi guys, its a terminal service session to the cluster, even so, a local
> registration is also slow. Again, its a cluster hooked to a SAN. I will
> double check the protocols enabled, i only had 1hr on the box last week
> along with some base line perf tuning! sales guys are truely hopeless at
> times :)
> Cheers
> Ck
>|||Chris
As you don't have the latest service pack this may be
relevent to your problem.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;282416
Hope this helps
John|||Make sure you trace the local client pc to resolve problems like this with
client tools as it's just as likely to be a performance problem on the PC as
the server. As Tibor's already pointed out twice (& you've not responded
yet), I'd also suggest you check ODBC tracing settings as these sometimes
get turned on without your knowledge by new applications you've installed or
network managers etc..
Regards,
Greg Linwood
SQL Server MVP
"Chris K" <dsfdsf> wrote in message
news:3f6dc101$0$23590$5a62ac22@.freenews.iinet.net.au...
> Hi Andrew
> This is the first option I checked, and no unfortunatly. Ill run some
> traces when I get a chance next.
> Cheers
> Ck
>|||Hi all
The fix was disabling netbios in the private nics of the cluster (I think I
had the terminology right).
Ill post the specifics when I get a chance.
Thanks for the help...
Cheers
Ck