Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL 2000 Optimize Maint Step locks up server

  
   Database Forums (Home) -> Tools RSS
Next:  "The SQL Server service failed to start&quot..  
Author Message
TMurnion

External


Since: Jul 28, 2008
Posts: 5



(Msg. 1) Posted: Wed Jul 23, 2008 4:36 pm
Post subject: SQL 2000 Optimize Maint Step locks up server
Archived from groups: microsoft>public>sqlserver>tools (more info?)
We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check. There are no event logs or entries in the activity logs for
what happens. The server is just locks up and has to be powered off to
restart

Any assistance is greatly appreciated.
Tony

 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 1649



(Msg. 2) Posted: Wed Jul 23, 2008 4:36 pm
Post subject: Re: SQL 2000 Optimize Maint Step locks up server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
TMurnion (tmurnion@azworld.com) writes:
> We have an sql 2000 sp4 server that locks up whenever we try to run a
> maintenance plan with only the option to Reorganize data and index pages
> option check. There are no event logs or entries in the activity logs for
> what happens. The server is just locks up and has to be powered off to
> restart

Have you checked the SQL Server error log for messages?

You say that the server has to be powered off. Does that mean that
Windows in entirety is not unresponsive?


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
TMurnion

External


Since: Jul 28, 2008
Posts: 5



(Msg. 3) Posted: Wed Jul 23, 2008 5:01 pm
Post subject: Re: SQL 2000 Optimize Maint Step locks up server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I've checked both the Event Logs via Adminstrative Tools and the Activity
Logs within SQL. Is there another place to check.

And yes Windows is not responsive. Whatever is happening does not have the
chance to generate a log.

Thanks.

Tony

"Erland Sommarskog" wrote in message

> TMurnion (tmurnion@azworld.com) writes:
>> We have an sql 2000 sp4 server that locks up whenever we try to run a
>> maintenance plan with only the option to Reorganize data and index pages
>> option check. There are no event logs or entries in the activity logs
>> for
>> what happens. The server is just locks up and has to be powered off to
>> restart
>
> Have you checked the SQL Server error log for messages?
>
> You say that the server has to be powered off. Does that mean that
> Windows in entirety is not unresponsive?
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 4) Posted: Wed Jul 23, 2008 8:13 pm
Post subject: Re: SQL 2000 Optimize Maint Step locks up server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
It sounds like you may be doing too much I/O that your system can't keep up
with it. If the disks are pegged the system will seem unresponsive. How
large is your db?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"TMurnion" wrote in message

> We have an sql 2000 sp4 server that locks up whenever we try to run a
> maintenance plan with only the option to Reorganize data and index pages
> option check. There are no event logs or entries in the activity logs for
> what happens. The server is just locks up and has to be powered off to
> restart
>
> Any assistance is greatly appreciated.
> Tony
>
 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 1649



(Msg. 5) Posted: Thu Jul 24, 2008 2:13 am
Post subject: Re: SQL 2000 Optimize Maint Step locks up server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
TMurnion (tmurnion@azworld.com) writes:
> I've checked both the Event Logs via Adminstrative Tools and the Activity
> Logs within SQL. Is there another place to check.

C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
ERRORLOG.6, given that you have SQL Server installed in the default
location. I don't if this what you refer to as the "Activity logs",
but these are the files I'm curious about.



--
Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
TMurnion

External


Since: Jul 28, 2008
Posts: 5



(Msg. 6) Posted: Thu Jul 24, 2008 2:30 pm
Post subject: Re: SQL 2000 Optimize Maint Step locks up server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
The database is about 5.8GB including transaction log. I don't think it is
an IO thing. I set this to go a 4am and it was unresponsive still at
7:55am. The tran log had not grown during that time so I don't think it got
past starting up.

Thanks

Tony

"Andrew J. Kelly" wrote in message

> It sounds like you may be doing too much I/O that your system can't keep
> up with it. If the disks are pegged the system will seem unresponsive. How
> large is your db?
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "TMurnion" wrote in message
>
>> We have an sql 2000 sp4 server that locks up whenever we try to run a
>> maintenance plan with only the option to Reorganize data and index pages
>> option check. There are no event logs or entries in the activity logs
>> for what happens. The server is just locks up and has to be powered off
>> to restart
>>
>> Any assistance is greatly appreciated.
>> Tony
>>
>
 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
TMurnion

External


Since: Jul 28, 2008
Posts: 5



(Msg. 7) Posted: Thu Jul 24, 2008 2:33 pm
Post subject: Re: SQL 2000 Optimize Maint Step locks up server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Same thing, different way to access. I went in through Enterprise
Managerunder the SQL Server Logs. I misnamed it "Activity log". sorry
about that. That's what I get for writing the email from memory. Wink

Thanks

Tony


"Erland Sommarskog" wrote in message

> TMurnion (tmurnion@azworld.com) writes:
>> I've checked both the Event Logs via Adminstrative Tools and the Activity
>> Logs within SQL. Is there another place to check.
>
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
> ERRORLOG.6, given that you have SQL Server installed in the default
> location. I don't if this what you refer to as the "Activity logs",
> but these are the files I'm curious about.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: SQL 2000 Optimize Maint Step locks up server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Maint. Plan - I need to set up a Maintenance Plan on a 6.5 DB. I know the version is old but the customer cannot upgrade at this time. When I try and run the wizard to set it up I get a warning about running a plan on a DB that is larger that 400MB. What the deal?....

Tools for optimize table index - What the tool that you are use for optimize table index ? Thanks

Manage SQL Server 2005 while keeping SQL Server 2000 - I've got SQL Server 2000 running on my PC, and I want to continue doing so. But now I also need to manage a remote SQL Server 2005 database. I think that I need to install SQL Server Management Studio to do so. (Please correct me if that's wrong.) Can...

Any better monitoring for locks and blocking in SQL2005? - Are the facilities for monitoring locks and blocking in SQL2005 better than 2000? I found that in SQL2000 Enterprise Manager by the time you waited for "current activity" to refresh, the information could have been and gone. I'd be interested...

Adding new step to SQL Agent Job - I am attempting to add a new step to an existing sql server 2000 job. The existing job starts upon SQL Server Agent startup. The steps consist of running a stored procedure on several databases. The last step (4) is simply a 'wait delay', then th...
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]