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

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
Thanks
We are running SQL2K SP4 on a windows 2000 server.
"A.B." wrote:

> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks
|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks
|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:

> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>
>
|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...[vbcol=seagreen]
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:

> What if you remote desktop to the server using another machine? Is it slow
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>
>
|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...[vbcol=seagreen]
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:

> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>
>

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
ThanksWe are running SQL2K SP4 on a windows 2000 server.
"A.B." wrote:
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:
> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> > My EM and QA have started to run really slowly have have tried to find the
> > problem but I cannot seem to find it. Does anybody have any suggestions on
> > where to look to solve this problem?
> >
> > Thanks
>
>|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
>> A.B,
>> Are other applications on your machine running slowly as well? Does this
>> happen to other machines? Check out your resource usage on your machine
>> using Task Manager.
>> HTH
>> Jerry
>> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>> > My EM and QA have started to run really slowly have have tried to find
>> > the
>> > problem but I cannot seem to find it. Does anybody have any suggestions
>> > on
>> > where to look to solve this problem?
>> >
>> > Thanks
>>|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:
> What if you remote desktop to the server using another machine? Is it slow
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> > The CPU usage is low and the Memory usage is 1580636K/1942920K
> > They seem to work fine if I go to the server but if I remote desktop to
> > them
> > they are slow. Our network is working fine though so i dont think it is
> > that.
> > I am stumped. This just started happening 2 days ago.
> >
> > "Jerry Spivey" wrote:
> >
> >> A.B,
> >>
> >> Are other applications on your machine running slowly as well? Does this
> >> happen to other machines? Check out your resource usage on your machine
> >> using Task Manager.
> >>
> >> HTH
> >>
> >> Jerry
> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> >> > My EM and QA have started to run really slowly have have tried to find
> >> > the
> >> > problem but I cannot seem to find it. Does anybody have any suggestions
> >> > on
> >> > where to look to solve this problem?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
>> What if you remote desktop to the server using another machine? Is it
>> slow
>> from that machine as well?
>> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>> > The CPU usage is low and the Memory usage is 1580636K/1942920K
>> > They seem to work fine if I go to the server but if I remote desktop to
>> > them
>> > they are slow. Our network is working fine though so i dont think it is
>> > that.
>> > I am stumped. This just started happening 2 days ago.
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> A.B,
>> >>
>> >> Are other applications on your machine running slowly as well? Does
>> >> this
>> >> happen to other machines? Check out your resource usage on your
>> >> machine
>> >> using Task Manager.
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>> >> > My EM and QA have started to run really slowly have have tried to
>> >> > find
>> >> > the
>> >> > problem but I cannot seem to find it. Does anybody have any
>> >> > suggestions
>> >> > on
>> >> > where to look to solve this problem?
>> >> >
>> >> > Thanks
>> >>
>> >>
>> >>
>>|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:
> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
> >I will have to try this tomorrow. Everybody has gone home and there are no
> > computers for me to use right now. I will respond tomorrow.
> >
> > "Jerry Spivey" wrote:
> >
> >> What if you remote desktop to the server using another machine? Is it
> >> slow
> >> from that machine as well?
> >>
> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> >> > The CPU usage is low and the Memory usage is 1580636K/1942920K
> >> > They seem to work fine if I go to the server but if I remote desktop to
> >> > them
> >> > they are slow. Our network is working fine though so i dont think it is
> >> > that.
> >> > I am stumped. This just started happening 2 days ago.
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> A.B,
> >> >>
> >> >> Are other applications on your machine running slowly as well? Does
> >> >> this
> >> >> happen to other machines? Check out your resource usage on your
> >> >> machine
> >> >> using Task Manager.
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> >> >> > My EM and QA have started to run really slowly have have tried to
> >> >> > find
> >> >> > the
> >> >> > problem but I cannot seem to find it. Does anybody have any
> >> >> > suggestions
> >> >> > on
> >> >> > where to look to solve this problem?
> >> >> >
> >> >> > Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
ThanksWe are running SQL2K SP4 on a Windows 2000 server.
"A.B." wrote:

> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that
.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:

> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>
>|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...[vbcol=seagreen]
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
>|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:

> What if you remote desktop to the server using another machine? Is it slo
w
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>
>|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...[vbcol=seagreen]
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
>|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:

> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>
>