Enterprise Manager not responding

Hi,
I have a large table in which an indexing operation initiated through
Enterprise Manager was interupted due to the server getting rebooted. Now
when I access Enterprise manager the memory usage for SQL Server goes very
high (almost 2 Gig) and Enterprise Manager does not respond. How I can I
start to resolve the issue of the high memory and Enterprise Manager not
responding?On Mon, 7 Nov 2005 15:12:02 -0800, Joe <Joe@.discussions.microsoft.com>
wrote:
>I have a large table in which an indexing operation initiated through
>Enterprise Manager was interupted due to the server getting rebooted. Now
>when I access Enterprise manager the memory usage for SQL Server goes very
>high (almost 2 Gig) and Enterprise Manager does not respond. How I can I
>start to resolve the issue of the high memory and Enterprise Manager not
>responding?
With luck, it was rolling back that interrupted transaction, and is
already back to normal!
How large was the table? Did you reboot the server because the
transaction was taking too long?
J.

Enterprise Manager not responding

Hi,
I have a large table in which an indexing operation initiated through
Enterprise Manager was interupted due to the server getting rebooted. Now
when I access Enterprise manager the memory usage for SQL Server goes very
high (almost 2 Gig) and Enterprise Manager does not respond. How I can I
start to resolve the issue of the high memory and Enterprise Manager not
responding?
On Mon, 7 Nov 2005 15:12:02 -0800, Joe <Joe@.discussions.microsoft.com>
wrote:
>I have a large table in which an indexing operation initiated through
>Enterprise Manager was interupted due to the server getting rebooted. Now
>when I access Enterprise manager the memory usage for SQL Server goes very
>high (almost 2 Gig) and Enterprise Manager does not respond. How I can I
>start to resolve the issue of the high memory and Enterprise Manager not
>responding?
With luck, it was rolling back that interrupted transaction, and is
already back to normal!
How large was the table? Did you reboot the server because the
transaction was taking too long?
J.

Enterprise Manager not responding

Hi,
I have a large table in which an indexing operation initiated through
Enterprise Manager was interupted due to the server getting rebooted. Now
when I access Enterprise manager the memory usage for SQL Server goes very
high (almost 2 Gig) and Enterprise Manager does not respond. How I can I
start to resolve the issue of the high memory and Enterprise Manager not
responding?On Mon, 7 Nov 2005 15:12:02 -0800, Joe <Joe@.discussions.microsoft.com>
wrote:
>I have a large table in which an indexing operation initiated through
>Enterprise Manager was interupted due to the server getting rebooted. Now
>when I access Enterprise manager the memory usage for SQL Server goes very
>high (almost 2 Gig) and Enterprise Manager does not respond. How I can I
>start to resolve the issue of the high memory and Enterprise Manager not
>responding?
With luck, it was rolling back that interrupted transaction, and is
already back to normal!
How large was the table? Did you reboot the server because the
transaction was taking too long?
J.

Enterprise Manager does not show databases

Hello...
We rebooted an SQL server last week...nothing installed or changed, just a
reboot.
Now, Enterprise Manager does not show any databases listed, however they are
present, they are being used, no calls or complaints. Query Analyzer lets
you run queries against them, just EM does not list any db's. We have tried
the hide/unhide on the General tab of the Properties box. It also seems any
scheduled jobs are not running, for dumping the tran logs, etc.
We are going to try a reboot when we can, but since the users are not
complaining, it will be awhile.
Anything I could check to fix this without rebooting?
Win2k3 server, SQL2000 SP3a
Thanks.Hi,
Can you try right-click on "Microsoft SqlServer" and add try creating a
new sql server group followed by new sqlserver registration with one of the
lost server name? I am not sure why it is lost, but I think it is worth
trying if it allows registration of the lost servers.
Thanks,
"JJP" wrote:
> Hello...
> We rebooted an SQL server last week...nothing installed or changed, just a
> reboot.
> Now, Enterprise Manager does not show any databases listed, however they are
> present, they are being used, no calls or complaints. Query Analyzer lets
> you run queries against them, just EM does not list any db's. We have tried
> the hide/unhide on the General tab of the Properties box. It also seems any
> scheduled jobs are not running, for dumping the tran logs, etc.
> We are going to try a reboot when we can, but since the users are not
> complaining, it will be awhile.
> Anything I could check to fix this without rebooting?
> Win2k3 server, SQL2000 SP3a
> Thanks.
>
>|||Thanks CD,
We ended up rebooting it after hours Friday night and everything showed up
as expected.
I appreciate your reply.
Jeff
"CD" <CD@.discussions.microsoft.com> wrote in message
news:D9EA74C5-4734-4BB3-B37E-038DED3536E0@.microsoft.com...
> Hi,
> Can you try right-click on "Microsoft SqlServer" and add try creating a
> new sql server group followed by new sqlserver registration with one of
> the
> lost server name? I am not sure why it is lost, but I think it is worth
> trying if it allows registration of the lost servers.
> Thanks,
> "JJP" wrote:
>> Hello...
>> We rebooted an SQL server last week...nothing installed or changed, just
>> a
>> reboot.
>> Now, Enterprise Manager does not show any databases listed, however they
>> are
>> present, they are being used, no calls or complaints. Query Analyzer
>> lets
>> you run queries against them, just EM does not list any db's. We have
>> tried
>> the hide/unhide on the General tab of the Properties box. It also seems
>> any
>> scheduled jobs are not running, for dumping the tran logs, etc.
>> We are going to try a reboot when we can, but since the users are not
>> complaining, it will be awhile.
>> Anything I could check to fix this without rebooting?
>> Win2k3 server, SQL2000 SP3a
>> Thanks.
>>

Enterprise Manager does not show databases

Hello...
We rebooted an SQL server last week...nothing installed or changed, just a
reboot.
Now, Enterprise Manager does not show any databases listed, however they are
present, they are being used, no calls or complaints. Query Analyzer lets
you run queries against them, just EM does not list any db's. We have tried
the hide/unhide on the General tab of the Properties box. It also seems any
scheduled jobs are not running, for dumping the tran logs, etc.
We are going to try a reboot when we can, but since the users are not
complaining, it will be awhile.
Anything I could check to fix this without rebooting?
Win2k3 server, SQL2000 SP3a
Thanks.
Hi,
Can you try right-click on "Microsoft SqlServer" and add try creating a
new sql server group followed by new sqlserver registration with one of the
lost server name? I am not sure why it is lost, but I think it is worth
trying if it allows registration of the lost servers.
Thanks,
"JJP" wrote:

> Hello...
> We rebooted an SQL server last week...nothing installed or changed, just a
> reboot.
> Now, Enterprise Manager does not show any databases listed, however they are
> present, they are being used, no calls or complaints. Query Analyzer lets
> you run queries against them, just EM does not list any db's. We have tried
> the hide/unhide on the General tab of the Properties box. It also seems any
> scheduled jobs are not running, for dumping the tran logs, etc.
> We are going to try a reboot when we can, but since the users are not
> complaining, it will be awhile.
> Anything I could check to fix this without rebooting?
> Win2k3 server, SQL2000 SP3a
> Thanks.
>
>
|||Thanks CD,
We ended up rebooting it after hours Friday night and everything showed up
as expected.
I appreciate your reply.
Jeff
"CD" <CD@.discussions.microsoft.com> wrote in message
news:D9EA74C5-4734-4BB3-B37E-038DED3536E0@.microsoft.com...[vbcol=seagreen]
> Hi,
> Can you try right-click on "Microsoft SqlServer" and add try creating a
> new sql server group followed by new sqlserver registration with one of
> the
> lost server name? I am not sure why it is lost, but I think it is worth
> trying if it allows registration of the lost servers.
> Thanks,
> "JJP" wrote:

Enterprise Manager does not show databases

Hello...
We rebooted an SQL server last week...nothing installed or changed, just a
reboot.
Now, Enterprise Manager does not show any databases listed, however they are
present, they are being used, no calls or complaints. Query Analyzer lets
you run queries against them, just EM does not list any db's. We have tried
the hide/unhide on the General tab of the Properties box. It also seems any
scheduled jobs are not running, for dumping the tran logs, etc.
We are going to try a reboot when we can, but since the users are not
complaining, it will be awhile.
Anything I could check to fix this without rebooting?
Win2k3 server, SQL2000 SP3a
Thanks.Hi,
Can you try right-click on "Microsoft SqlServer" and add try creating a
new sql server group followed by new sqlserver registration with one of the
lost server name? I am not sure why it is lost, but I think it is worth
trying if it allows registration of the lost servers.
Thanks,
"JJP" wrote:

> Hello...
> We rebooted an SQL server last week...nothing installed or changed, just a
> reboot.
> Now, Enterprise Manager does not show any databases listed, however they a
re
> present, they are being used, no calls or complaints. Query Analyzer lets
> you run queries against them, just EM does not list any db's. We have tri
ed
> the hide/unhide on the General tab of the Properties box. It also seems a
ny
> scheduled jobs are not running, for dumping the tran logs, etc.
> We are going to try a reboot when we can, but since the users are not
> complaining, it will be awhile.
> Anything I could check to fix this without rebooting?
> Win2k3 server, SQL2000 SP3a
> Thanks.
>
>|||Thanks CD,
We ended up rebooting it after hours Friday night and everything showed up
as expected.
I appreciate your reply.
Jeff
"CD" <CD@.discussions.microsoft.com> wrote in message
news:D9EA74C5-4734-4BB3-B37E-038DED3536E0@.microsoft.com...[vbcol=seagreen]
> Hi,
> Can you try right-click on "Microsoft SqlServer" and add try creating a
> new sql server group followed by new sqlserver registration with one of
> the
> lost server name? I am not sure why it is lost, but I think it is worth
> trying if it allows registration of the lost servers.
> Thanks,
> "JJP" wrote:
>