Mysterious Sql2000 process blocking

I have made several posts regarding my sql2000 cpu mysteriously staying at
100% for 10 minutes at a time. Using a performance monitor, I finally
noticed that during these times there is a sql process that is blocking the
others and causing some kind of "race" condition. The blocked processes
time out, but the blocking process seems to stay blocked often until the
service is restarted. It seems like sql should not allow this. I have not
been able to find out the cause or statements that produced the problem.
The only application using the sql server is an ASP.NET application that
uses 100% stored procedures (no dynamic sql). Does anyone have any
suggestions for finding the cause of process blocking like this? Thanks.
Dan,
You'd have to examine the code to determine this.
These may help:
http://www.sql-server-performance.co...prevention.asp
and
http://www.support.microsoft.com/?id=224453
and
http://www.support.microsoft.com/?id=271509
and
http://support.microsoft.com/?id=224587
and
http://support.microsoft.com/?id=243589
and
http://support.microsoft.com/?id=243588
HTH
Jerry
"Dan English" <dan_english2@.cox.net> wrote in message
news:eUAAmR4zFHA.2960@.tk2msftngp13.phx.gbl...
>I have made several posts regarding my sql2000 cpu mysteriously staying at
>100% for 10 minutes at a time. Using a performance monitor, I finally
>noticed that during these times there is a sql process that is blocking the
>others and causing some kind of "race" condition. The blocked processes
>time out, but the blocking process seems to stay blocked often until the
>service is restarted. It seems like sql should not allow this. I have
>not been able to find out the cause or statements that produced the
>problem. The only application using the sql server is an ASP.NET
>application that uses 100% stored procedures (no dynamic sql). Does anyone
>have any suggestions for finding the cause of process blocking like this?
>Thanks.
>

Mysterious Sql2000 process blocking

I have made several posts regarding my sql2000 cpu mysteriously staying at
100% for 10 minutes at a time. Using a performance monitor, I finally
noticed that during these times there is a sql process that is blocking the
others and causing some kind of "race" condition. The blocked processes
time out, but the blocking process seems to stay blocked often until the
service is restarted. It seems like sql should not allow this. I have not
been able to find out the cause or statements that produced the problem.
The only application using the sql server is an ASP.NET application that
uses 100% stored procedures (no dynamic sql). Does anyone have any
suggestions for finding the cause of process blocking like this? Thanks.Dan,
You'd have to examine the code to determine this.
These may help:
http://www.sql-server-performance.com/sf_block_prevention.asp
and
http://www.support.microsoft.com/?id=224453
and
http://www.support.microsoft.com/?id=271509
and
http://support.microsoft.com/?id=224587
and
http://support.microsoft.com/?id=243589
and
http://support.microsoft.com/?id=243588
HTH
Jerry
"Dan English" <dan_english2@.cox.net> wrote in message
news:eUAAmR4zFHA.2960@.tk2msftngp13.phx.gbl...
>I have made several posts regarding my sql2000 cpu mysteriously staying at
>100% for 10 minutes at a time. Using a performance monitor, I finally
>noticed that during these times there is a sql process that is blocking the
>others and causing some kind of "race" condition. The blocked processes
>time out, but the blocking process seems to stay blocked often until the
>service is restarted. It seems like sql should not allow this. I have
>not been able to find out the cause or statements that produced the
>problem. The only application using the sql server is an ASP.NET
>application that uses 100% stored procedures (no dynamic sql). Does anyone
>have any suggestions for finding the cause of process blocking like this?
>Thanks.
>

Mysterious Sql2000 process blocking

I have made several posts regarding my sql2000 cpu mysteriously staying at
100% for 10 minutes at a time. Using a performance monitor, I finally
noticed that during these times there is a sql process that is blocking the
others and causing some kind of "race" condition. The blocked processes
time out, but the blocking process seems to stay blocked often until the
service is restarted. It seems like sql should not allow this. I have not
been able to find out the cause or statements that produced the problem.
The only application using the sql server is an ASP.NET application that
uses 100% stored procedures (no dynamic sql). Does anyone have any
suggestions for finding the cause of process blocking like this? Thanks.Dan,
You'd have to examine the code to determine this.
These may help:
http://www.sql-server-performance.c..._prevention.asp
and
http://www.support.microsoft.com/?id=224453
and
http://www.support.microsoft.com/?id=271509
and
http://support.microsoft.com/?id=224587
and
http://support.microsoft.com/?id=243589
and
http://support.microsoft.com/?id=243588
HTH
Jerry
"Dan English" <dan_english2@.cox.net> wrote in message
news:eUAAmR4zFHA.2960@.tk2msftngp13.phx.gbl...
>I have made several posts regarding my sql2000 cpu mysteriously staying at
>100% for 10 minutes at a time. Using a performance monitor, I finally
>noticed that during these times there is a sql process that is blocking the
>others and causing some kind of "race" condition. The blocked processes
>time out, but the blocking process seems to stay blocked often until the
>service is restarted. It seems like sql should not allow this. I have
>not been able to find out the cause or statements that produced the
>problem. The only application using the sql server is an ASP.NET
>application that uses 100% stored procedures (no dynamic sql). Does anyone
>have any suggestions for finding the cause of process blocking like this?
>Thanks.
>

My SQL7.0 Problems

I have a SQL 7.0 DB that is working fine, except for some records that a
user deleted. She wants me to restore them. My normal process for
restoring SQL data is to restore last night's backup to a test DB and let
the user access this DB for their information. My problem is that the test
DB is corrupt. When I try to access the DB through Enterprise Manager, I
get this: An error occurred while trying to access the database information.
When I try to get properties on the database, I get this: Error 945:
Database 'database' cannot be opened because some of the files could not be
activated.
I was able to try to restore (and import) data to the DB, but got various
error messages.
My questions:
1. Can this DB be repaired?
2. If this DB can't be repaired, can restore or import to it?
I made a new blank DB and tried to restore (and import) to it, but got
errors when I tried that too.
Any ideas?
Thanks,
JohnHi
Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE" is
the command.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
news:11411o8s8vrbibf@.corp.supernews.com...
> I have a SQL 7.0 DB that is working fine, except for some records that a
> user deleted. She wants me to restore them. My normal process for
> restoring SQL data is to restore last night's backup to a test DB and let
> the user access this DB for their information. My problem is that the
test
> DB is corrupt. When I try to access the DB through Enterprise Manager, I
> get this: An error occurred while trying to access the database
information.
> When I try to get properties on the database, I get this: Error 945:
> Database 'database' cannot be opened because some of the files could not
be
> activated.
> I was able to try to restore (and import) data to the DB, but got various
> error messages.
> My questions:
> 1. Can this DB be repaired?
> 2. If this DB can't be repaired, can restore or import to it?
> I made a new blank DB and tried to restore (and import) to it, but got
> errors when I tried that too.
> Any ideas?
> Thanks,
> John
>|||Thanks for the response!
How do I use the 'DROP DATABASE' command? After I delete and restore the
database, do I go into 'Query Analyzer' and issue the command there? What
does it do?
Thanks again,
John
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u7J0bPzLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Hi
> Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE"
is
> the command.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
> news:11411o8s8vrbibf@.corp.supernews.com...
> > I have a SQL 7.0 DB that is working fine, except for some records that a
> > user deleted. She wants me to restore them. My normal process for
> > restoring SQL data is to restore last night's backup to a test DB and
let
> > the user access this DB for their information. My problem is that the
> test
> > DB is corrupt. When I try to access the DB through Enterprise Manager,
I
> > get this: An error occurred while trying to access the database
> information.
> > When I try to get properties on the database, I get this: Error 945:
> > Database 'database' cannot be opened because some of the files could not
> be
> > activated.
> >
> > I was able to try to restore (and import) data to the DB, but got
various
> > error messages.
> >
> > My questions:
> >
> > 1. Can this DB be repaired?
> >
> > 2. If this DB can't be repaired, can restore or import to it?
> >
> > I made a new blank DB and tried to restore (and import) to it, but got
> > errors when I tried that too.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > John
> >
> >
>

My SQL7.0 Problems

I have a SQL 7.0 DB that is working fine, except for some records that a
user deleted. She wants me to restore them. My normal process for
restoring SQL data is to restore last night's backup to a test DB and let
the user access this DB for their information. My problem is that the test
DB is corrupt. When I try to access the DB through Enterprise Manager, I
get this: An error occurred while trying to access the database information.
When I try to get properties on the database, I get this: Error 945:
Database 'database' cannot be opened because some of the files could not be
activated.
I was able to try to restore (and import) data to the DB, but got various
error messages.
My questions:
1. Can this DB be repaired?
2. If this DB can't be repaired, can restore or import to it?
I made a new blank DB and tried to restore (and import) to it, but got
errors when I tried that too.
Any ideas?
Thanks,
John
Hi
Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE" is
the command.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
news:11411o8s8vrbibf@.corp.supernews.com...
> I have a SQL 7.0 DB that is working fine, except for some records that a
> user deleted. She wants me to restore them. My normal process for
> restoring SQL data is to restore last night's backup to a test DB and let
> the user access this DB for their information. My problem is that the
test
> DB is corrupt. When I try to access the DB through Enterprise Manager, I
> get this: An error occurred while trying to access the database
information.
> When I try to get properties on the database, I get this: Error 945:
> Database 'database' cannot be opened because some of the files could not
be
> activated.
> I was able to try to restore (and import) data to the DB, but got various
> error messages.
> My questions:
> 1. Can this DB be repaired?
> 2. If this DB can't be repaired, can restore or import to it?
> I made a new blank DB and tried to restore (and import) to it, but got
> errors when I tried that too.
> Any ideas?
> Thanks,
> John
>
|||Thanks for the response!
How do I use the 'DROP DATABASE' command? After I delete and restore the
database, do I go into 'Query Analyzer' and issue the command there? What
does it do?
Thanks again,
John
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u7J0bPzLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Hi
> Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE"
is[vbcol=seagreen]
> the command.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
> news:11411o8s8vrbibf@.corp.supernews.com...
let[vbcol=seagreen]
> test
I[vbcol=seagreen]
> information.
> be
various
>

My SQL7.0 Problems

I have a SQL 7.0 DB that is working fine, except for some records that a
user deleted. She wants me to restore them. My normal process for
restoring SQL data is to restore last night's backup to a test DB and let
the user access this DB for their information. My problem is that the test
DB is corrupt. When I try to access the DB through Enterprise Manager, I
get this: An error occurred while trying to access the database information.
When I try to get properties on the database, I get this: Error 945:
Database 'database' cannot be opened because some of the files could not be
activated.
I was able to try to restore (and import) data to the DB, but got various
error messages.
My questions:
1. Can this DB be repaired?
2. If this DB can't be repaired, can restore or import to it?
I made a new blank DB and tried to restore (and import) to it, but got
errors when I tried that too.
Any ideas?
Thanks,
JohnHi
Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE" is
the command.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
news:11411o8s8vrbibf@.corp.supernews.com...
> I have a SQL 7.0 DB that is working fine, except for some records that a
> user deleted. She wants me to restore them. My normal process for
> restoring SQL data is to restore last night's backup to a test DB and let
> the user access this DB for their information. My problem is that the
test
> DB is corrupt. When I try to access the DB through Enterprise Manager, I
> get this: An error occurred while trying to access the database
information.
> When I try to get properties on the database, I get this: Error 945:
> Database 'database' cannot be opened because some of the files could not
be
> activated.
> I was able to try to restore (and import) data to the DB, but got various
> error messages.
> My questions:
> 1. Can this DB be repaired?
> 2. If this DB can't be repaired, can restore or import to it?
> I made a new blank DB and tried to restore (and import) to it, but got
> errors when I tried that too.
> Any ideas?
> Thanks,
> John
>|||Thanks for the response!
How do I use the 'DROP DATABASE' command? After I delete and restore the
database, do I go into 'Query Analyzer' and issue the command there? What
does it do?
Thanks again,
John
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u7J0bPzLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Hi
> Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE"
is
> the command.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
> news:11411o8s8vrbibf@.corp.supernews.com...
let[vbcol=seagreen]
> test
I[vbcol=seagreen]
> information.
> be
various[vbcol=seagreen]
>

My Report Manager Broke "The underlying connection was closed"

Our company recently re-located the servers and somehow in the process of
disconnecting -> reconnecting the Report Server the Report Manager now cannot
be run. All we get is the error:
"The underlying connection was closed: Unable to connect to the remote
server."
Interestingly, this affects ONLY the Report Manager, the Report Service is
running OK and all reports run fine via our web application and in Visual
Studio IDE etc...
Any clues?Hi!
We had a similar problem and resolved it by correcting the Applications
Extensions Mapping for the ReportServer virtual directory. Information about
configuring Reporting Services' virtual directories is available here:
http://support.microsoft.com/Default.aspx?kbid=867872
Good luck,
Bob
"neokortex" wrote:
> Our company recently re-located the servers and somehow in the process of
> disconnecting -> reconnecting the Report Server the Report Manager now cannot
> be run. All we get is the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> Interestingly, this affects ONLY the Report Manager, the Report Service is
> running OK and all reports run fine via our web application and in Visual
> Studio IDE etc...
> Any clues?|||thanks for the tip,
but Im not quite sure this will help me. I checked the extensions for our
ReportServer virtual directory and they are already mapped exactly as
specified in the Support article. Also, ReportServer is working fine in so
far as reports can still be run through it.
It is only the Report Manager Web UI that is flaking out.
"bobhug" wrote:
> Hi!
> We had a similar problem and resolved it by correcting the Applications
> Extensions Mapping for the ReportServer virtual directory. Information about
> configuring Reporting Services' virtual directories is available here:
> http://support.microsoft.com/Default.aspx?kbid=867872
> Good luck,
> Bob
> "neokortex" wrote:
> > Our company recently re-located the servers and somehow in the process of
> > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > be run. All we get is the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > running OK and all reports run fine via our web application and in Visual
> > Studio IDE etc...
> >
> > Any clues?|||I am having the exact same problem. ReportServer is working fine, but report
manager web interface gives The underlying connection was closed. was there a
resolution to this problem?
"neokortex" wrote:
> thanks for the tip,
> but Im not quite sure this will help me. I checked the extensions for our
> ReportServer virtual directory and they are already mapped exactly as
> specified in the Support article. Also, ReportServer is working fine in so
> far as reports can still be run through it.
> It is only the Report Manager Web UI that is flaking out.
> "bobhug" wrote:
> > Hi!
> > We had a similar problem and resolved it by correcting the Applications
> > Extensions Mapping for the ReportServer virtual directory. Information about
> > configuring Reporting Services' virtual directories is available here:
> > http://support.microsoft.com/Default.aspx?kbid=867872
> >
> > Good luck,
> > Bob
> >
> > "neokortex" wrote:
> >
> > > Our company recently re-located the servers and somehow in the process of
> > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > be run. All we get is the error:
> > >
> > > "The underlying connection was closed: Unable to connect to the remote
> > > server."
> > >
> > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > running OK and all reports run fine via our web application and in Visual
> > > Studio IDE etc...
> > >
> > > Any clues?|||No resolution yet. Since that was a test server and we were/are in the
process of migrating to a production server, it is not a emergency for us. I
do know this is a general web service error, not necessarily specfic to RS.
However if you find the answer please respond. I am curious.
"Paul" wrote:
> I am having the exact same problem. ReportServer is working fine, but report
> manager web interface gives The underlying connection was closed. was there a
> resolution to this problem?
> "neokortex" wrote:
> > thanks for the tip,
> >
> > but Im not quite sure this will help me. I checked the extensions for our
> > ReportServer virtual directory and they are already mapped exactly as
> > specified in the Support article. Also, ReportServer is working fine in so
> > far as reports can still be run through it.
> >
> > It is only the Report Manager Web UI that is flaking out.
> >
> > "bobhug" wrote:
> >
> > > Hi!
> > > We had a similar problem and resolved it by correcting the Applications
> > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > configuring Reporting Services' virtual directories is available here:
> > > http://support.microsoft.com/Default.aspx?kbid=867872
> > >
> > > Good luck,
> > > Bob
> > >
> > > "neokortex" wrote:
> > >
> > > > Our company recently re-located the servers and somehow in the process of
> > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > be run. All we get is the error:
> > > >
> > > > "The underlying connection was closed: Unable to connect to the remote
> > > > server."
> > > >
> > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > running OK and all reports run fine via our web application and in Visual
> > > > Studio IDE etc...
> > > >
> > > > Any clues?|||Hi ,
I figured out the solution to this problem. Follwoing 3 things should be
made sure of:
1. Never reinstall reporting services without first uninstalling it
completely... i.e first remove the registry entiries manually then only
reporting services uninstallation is complete.
2. In the RSWebApplication.Config file in Reports Manager , the
ReportServerURL key should have a value as https:/IP(of the report manager
virtual directory)/ReportServer . If in other Report Server and Report
manager .Config files, you find localhost... replace it with the IP of the
virtual directory where reports manager and report server are installed.
3. When you deploy the report, in the configuration properties for the
project .. in the deployment path, again specify the IP instaed of
localhost...
If all these 3 things are taken care of.. then this error will not occur...
When i fixed all these, it worked for me.
pmud
"neokortex" wrote:
> No resolution yet. Since that was a test server and we were/are in the
> process of migrating to a production server, it is not a emergency for us. I
> do know this is a general web service error, not necessarily specfic to RS.
> However if you find the answer please respond. I am curious.
> "Paul" wrote:
> > I am having the exact same problem. ReportServer is working fine, but report
> > manager web interface gives The underlying connection was closed. was there a
> > resolution to this problem?
> >
> > "neokortex" wrote:
> >
> > > thanks for the tip,
> > >
> > > but Im not quite sure this will help me. I checked the extensions for our
> > > ReportServer virtual directory and they are already mapped exactly as
> > > specified in the Support article. Also, ReportServer is working fine in so
> > > far as reports can still be run through it.
> > >
> > > It is only the Report Manager Web UI that is flaking out.
> > >
> > > "bobhug" wrote:
> > >
> > > > Hi!
> > > > We had a similar problem and resolved it by correcting the Applications
> > > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > > configuring Reporting Services' virtual directories is available here:
> > > > http://support.microsoft.com/Default.aspx?kbid=867872
> > > >
> > > > Good luck,
> > > > Bob
> > > >
> > > > "neokortex" wrote:
> > > >
> > > > > Our company recently re-located the servers and somehow in the process of
> > > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > > be run. All we get is the error:
> > > > >
> > > > > "The underlying connection was closed: Unable to connect to the remote
> > > > > server."
> > > > >
> > > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > > running OK and all reports run fine via our web application and in Visual
> > > > > Studio IDE etc...
> > > > >
> > > > > Any clues?