SQL 2000 Optimize Maint Step locks up server

#41

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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" <tmurnion (AT) azworld (DOT) com> wrote in message
news:uuQo5SR7IHA.5440 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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

#42

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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" <tmurnion (AT) azworld (DOT) com> wrote in message
news:uuQo5SR7IHA.5440 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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

#43

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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" <tmurnion (AT) azworld (DOT) com> wrote in message
news:uuQo5SR7IHA.5440 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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

#44

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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" <tmurnion (AT) azworld (DOT) com> wrote in message
news:uuQo5SR7IHA.5440 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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

#45

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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" <tmurnion (AT) azworld (DOT) com> wrote in message
news:uuQo5SR7IHA.5440 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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

#46

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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" <tmurnion (AT) azworld (DOT) com> wrote in message
news:uuQo5SR7IHA.5440 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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

#47

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. ;-)

Thanks

Tony

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:

TMurnion (tmurnion (AT) azworld (DOT) 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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#48

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. ;-)

Thanks

Tony

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:

TMurnion (tmurnion (AT) azworld (DOT) 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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#49

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. ;-)

Thanks

Tony

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:

TMurnion (tmurnion (AT) azworld (DOT) 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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#50

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. ;-)

Thanks

Tony

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:

TMurnion (tmurnion (AT) azworld (DOT) 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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx