EM locks up

On certain occasions, when I'm running a long-running query in Query
Analyzer, I can't get in to Enterprise Manager. What happens is the list of
tables can't be enumerated until the long-running query finishes. What's
odd to me is that the query only affects 1 or 2 tables. So why can't I get
into EM until this job finishes?
Thanks, Andre
Hi,
This might be because your ISQLW.EXE in client machine will be using the
CPU and Memory fully. If you have better processor PIII or higher +
512 MB ram you should have such issues.
Check your virtual memory definition in your client machine. Always try to
run the long running queries in text result mode.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
> On certain occasions, when I'm running a long-running query in Query
> Analyzer, I can't get in to Enterprise Manager. What happens is the list
of
> tables can't be enumerated until the long-running query finishes. What's
> odd to me is that the query only affects 1 or 2 tables. So why can't I
get
> into EM until this job finishes?
> Thanks, Andre
>
|||Actually, the long-running query is running on a different box. For
example, if you and I were in the same office, and I was running the query,
you might not be able to get into EM.
Andre
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> This might be because your ISQLW.EXE in client machine will be using the
> CPU and Memory fully. If you have better processor PIII or higher +
> 512 MB ram you should have such issues.
> Check your virtual memory definition in your client machine. Always try to
> run the long running queries in text result mode.
> Thanks
> Hari
> MCDBA
>
>
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
list[vbcol=seagreen]
> of
What's
> get
>
|||Hi,
Means , you will be able to open the enterprise manager, but while expanding
your SQL Server it just hangs..
Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
performance will be slow and cause a time out. The CPU usage in the log
running query can be minimized by tuning the query by effect sql statement
and adding proper indexes.
Did you installed SP3 in SQL server machine. If not install SP3.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Actually, the long-running query is running on a different box. For
> example, if you and I were in the same office, and I was running the
query,[vbcol=seagreen]
> you might not be able to get into EM.
> Andre
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
to[vbcol=seagreen]
> list
> What's
I
>
|||sp3a was installed shortly after it was released. Yes, I (or other users)
can launch EM, can expand the server, but can't get a list of tables when
trying to expand the tables folder. Query analyzer works just fine. CPU
usage on the server is typically low when this is happening. sp_who2 shows
that the long running query is blocking the EM process. I just can't figure
out why a query that "might" have a lock on a table would prevent the list
of tables from being displayed in EM.
Andre
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ODjXezpLEHA.3052@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Means , you will be able to open the enterprise manager, but while
expanding[vbcol=seagreen]
> your SQL Server it just hangs..
> Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
> performance will be slow and cause a time out. The CPU usage in the log
> running query can be minimized by tuning the query by effect sql statement
> and adding proper indexes.
> Did you installed SP3 in SQL server machine. If not install SP3.
> Thanks
> Hari
> MCDBA
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> query,
> the
try[vbcol=seagreen]
> to
can't
> I
>
|||Hi,
Do you have the problem yet? I am having a similar problem. I have 2 machines:
1 .- SQL server 2000 + SP3, without problems
2 .- SQL Server 2000 + SP3a, with performance problems
I am reinstalling Sql server + SP3 and I am testing machine 1. I am sending you information.
Lina
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...