Raid Rebuilding

Hi,
We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
was replaced with new one and the New disk
was rebuilding its raid on it , my question is when we had a disk failure in
it the server was running very slow disk I/O
was very bad ad after replacing the disk even then for abot 8 hrs the server
was runnin the same, is this bcoz of the raid rebuilding on the disk does the
raid rebuilding does hurt the performance of the server
thanks
It looks like you answered your own question. Yes, RAID rebuilding slows
IO. That is one reason the RAID container is marked 'DEGRADED'. You can
adjust how much of its resources the PERC card devotes to rebuilding, but be
aware that lowering the impact will make the rabuild take longer. Read the
PERC card instructions or the Dell OpenManage instructions for exactly how
to adjust the RAID rebuild rate
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dines" <dines@.discussions.microsoft.com> wrote in message
news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> Hi,
> We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
> was replaced with new one and the New disk
> was rebuilding its raid on it , my question is when we had a disk failure
in
> it the server was running very slow disk I/O
> was very bad ad after replacing the disk even then for abot 8 hrs the
server
> was runnin the same, is this bcoz of the raid rebuilding on the disk does
the
> raid rebuilding does hurt the performance of the server
> thanks
|||Thanks For the info on how to adjust perc card but i have another doubt
the rebuilding started at around 12:30 pm and till 8 :30 pm the server was
very slow though the same amount of load was on the server as it usually has
on it but at 8:30 pm the server was breathing free even though the rebuilding
was not yet competed 30% was completed then my question--is there a limit
until which the rebuilding raid hurts ur server performance only for an
intial period or it goes in the same manner until it rebuilds completely.
thanks
"Geoff N. Hiten" wrote:

> It looks like you answered your own question. Yes, RAID rebuilding slows
> IO. That is one reason the RAID container is marked 'DEGRADED'. You can
> adjust how much of its resources the PERC card devotes to rebuilding, but be
> aware that lowering the impact will make the rabuild take longer. Read the
> PERC card instructions or the Dell OpenManage instructions for exactly how
> to adjust the RAID rebuild rate
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "dines" <dines@.discussions.microsoft.com> wrote in message
> news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> in
> server
> the
>
>
|||It depends. Are you sure you were not running a backup or maintenance task
during the overnight hours? Those are very IO intense and will slow a
server down if the IO system is not running as expected. The impact can
also depend on what part of the disks are being rebuilt. Hotspot contention
could have been part of the problem. This is one of many reasons I don't
use RAID-5 on a production system.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dines" <dines@.discussions.microsoft.com> wrote in message
news:96F4C225-5BE3-4FE7-8364-76EE8ED3072C@.microsoft.com...
> Thanks For the info on how to adjust perc card but i have another doubt
> the rebuilding started at around 12:30 pm and till 8 :30 pm the server was
> very slow though the same amount of load was on the server as it usually
has
> on it but at 8:30 pm the server was breathing free even though the
rebuilding[vbcol=seagreen]
> was not yet competed 30% was completed then my question--is there a limit
> until which the rebuilding raid hurts ur server performance only for an
> intial period or it goes in the same manner until it rebuilds completely.
> thanks
>
> "Geoff N. Hiten" wrote:
slows[vbcol=seagreen]
can[vbcol=seagreen]
but be[vbcol=seagreen]
the[vbcol=seagreen]
how[vbcol=seagreen]
and[vbcol=seagreen]
failure[vbcol=seagreen]
does[vbcol=seagreen]

Raid Rebuilding

Hi,
We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
was replaced with new one and the New disk
was rebuilding its raid on it , my question is when we had a disk failure in
it the server was running very slow disk I/O
was very bad ad after replacing the disk even then for abot 8 hrs the server
was runnin the same, is this bcoz of the raid rebuilding on the disk does the
raid rebuilding does hurt the performance of the server
thanksIt looks like you answered your own question. Yes, RAID rebuilding slows
IO. That is one reason the RAID container is marked 'DEGRADED'. You can
adjust how much of its resources the PERC card devotes to rebuilding, but be
aware that lowering the impact will make the rabuild take longer. Read the
PERC card instructions or the Dell OpenManage instructions for exactly how
to adjust the RAID rebuild rate
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dines" <dines@.discussions.microsoft.com> wrote in message
news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> Hi,
> We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
> was replaced with new one and the New disk
> was rebuilding its raid on it , my question is when we had a disk failure
in
> it the server was running very slow disk I/O
> was very bad ad after replacing the disk even then for abot 8 hrs the
server
> was runnin the same, is this bcoz of the raid rebuilding on the disk does
the
> raid rebuilding does hurt the performance of the server
> thanks|||Thanks For the info on how to adjust perc card but i have another doubt
the rebuilding started at around 12:30 pm and till 8 :30 pm the server was
very slow though the same amount of load was on the server as it usually has
on it but at 8:30 pm the server was breathing free even though the rebuilding
was not yet competed 30% was completed then my question--is there a limit
until which the rebuilding raid hurts ur server performance only for an
intial period or it goes in the same manner until it rebuilds completely.
thanks
"Geoff N. Hiten" wrote:
> It looks like you answered your own question. Yes, RAID rebuilding slows
> IO. That is one reason the RAID container is marked 'DEGRADED'. You can
> adjust how much of its resources the PERC card devotes to rebuilding, but be
> aware that lowering the impact will make the rabuild take longer. Read the
> PERC card instructions or the Dell OpenManage instructions for exactly how
> to adjust the RAID rebuild rate
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "dines" <dines@.discussions.microsoft.com> wrote in message
> news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> > Hi,
> >
> > We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
> > was replaced with new one and the New disk
> > was rebuilding its raid on it , my question is when we had a disk failure
> in
> > it the server was running very slow disk I/O
> > was very bad ad after replacing the disk even then for abot 8 hrs the
> server
> > was runnin the same, is this bcoz of the raid rebuilding on the disk does
> the
> > raid rebuilding does hurt the performance of the server
> >
> > thanks
>
>|||It depends. Are you sure you were not running a backup or maintenance task
during the overnight hours? Those are very IO intense and will slow a
server down if the IO system is not running as expected. The impact can
also depend on what part of the disks are being rebuilt. Hotspot contention
could have been part of the problem. This is one of many reasons I don't
use RAID-5 on a production system.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dines" <dines@.discussions.microsoft.com> wrote in message
news:96F4C225-5BE3-4FE7-8364-76EE8ED3072C@.microsoft.com...
> Thanks For the info on how to adjust perc card but i have another doubt
> the rebuilding started at around 12:30 pm and till 8 :30 pm the server was
> very slow though the same amount of load was on the server as it usually
has
> on it but at 8:30 pm the server was breathing free even though the
rebuilding
> was not yet competed 30% was completed then my question--is there a limit
> until which the rebuilding raid hurts ur server performance only for an
> intial period or it goes in the same manner until it rebuilds completely.
> thanks
>
> "Geoff N. Hiten" wrote:
> > It looks like you answered your own question. Yes, RAID rebuilding
slows
> > IO. That is one reason the RAID container is marked 'DEGRADED'. You
can
> > adjust how much of its resources the PERC card devotes to rebuilding,
but be
> > aware that lowering the impact will make the rabuild take longer. Read
the
> > PERC card instructions or the Dell OpenManage instructions for exactly
how
> > to adjust the RAID rebuild rate
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "dines" <dines@.discussions.microsoft.com> wrote in message
> > news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> > > Hi,
> > >
> > > We have a Dell 2650 with raid 5 on it one of the disk had disk Failure
and
> > > was replaced with new one and the New disk
> > > was rebuilding its raid on it , my question is when we had a disk
failure
> > in
> > > it the server was running very slow disk I/O
> > > was very bad ad after replacing the disk even then for abot 8 hrs the
> > server
> > > was runnin the same, is this bcoz of the raid rebuilding on the disk
does
> > the
> > > raid rebuilding does hurt the performance of the server
> > >
> > > thanks
> >
> >
> >

Raid Rebuilding

Hi,
We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
was replaced with new one and the New disk
was rebuilding its raid on it , my question is when we had a disk failure in
it the server was running very slow disk I/O
was very bad ad after replacing the disk even then for abot 8 hrs the server
was runnin the same, is this bcoz of the raid rebuilding on the disk does th
e
raid rebuilding does hurt the performance of the server
thanksIt looks like you answered your own question. Yes, RAID rebuilding slows
IO. That is one reason the RAID container is marked 'DEGRADED'. You can
adjust how much of its resources the PERC card devotes to rebuilding, but be
aware that lowering the impact will make the rabuild take longer. Read the
PERC card instructions or the Dell OpenManage instructions for exactly how
to adjust the RAID rebuild rate
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dines" <dines@.discussions.microsoft.com> wrote in message
news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> Hi,
> We have a Dell 2650 with raid 5 on it one of the disk had disk Failure and
> was replaced with new one and the New disk
> was rebuilding its raid on it , my question is when we had a disk failure
in
> it the server was running very slow disk I/O
> was very bad ad after replacing the disk even then for abot 8 hrs the
server
> was runnin the same, is this bcoz of the raid rebuilding on the disk does
the
> raid rebuilding does hurt the performance of the server
> thanks|||Thanks For the info on how to adjust perc card but i have another doubt
the rebuilding started at around 12:30 pm and till 8 :30 pm the server was
very slow though the same amount of load was on the server as it usually has
on it but at 8:30 pm the server was breathing free even though the rebuildin
g
was not yet competed 30% was completed then my question--is there a limit
until which the rebuilding raid hurts ur server performance only for an
intial period or it goes in the same manner until it rebuilds completely.
thanks
"Geoff N. Hiten" wrote:

> It looks like you answered your own question. Yes, RAID rebuilding slows
> IO. That is one reason the RAID container is marked 'DEGRADED'. You can
> adjust how much of its resources the PERC card devotes to rebuilding, but
be
> aware that lowering the impact will make the rabuild take longer. Read th
e
> PERC card instructions or the Dell OpenManage instructions for exactly how
> to adjust the RAID rebuild rate
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "dines" <dines@.discussions.microsoft.com> wrote in message
> news:26610ED8-AC00-4AC3-975B-EC44272148DA@.microsoft.com...
> in
> server
> the
>
>|||It depends. Are you sure you were not running a backup or maintenance task
during the overnight hours? Those are very IO intense and will slow a
server down if the IO system is not running as expected. The impact can
also depend on what part of the disks are being rebuilt. Hotspot contention
could have been part of the problem. This is one of many reasons I don't
use RAID-5 on a production system.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dines" <dines@.discussions.microsoft.com> wrote in message
news:96F4C225-5BE3-4FE7-8364-76EE8ED3072C@.microsoft.com...
> Thanks For the info on how to adjust perc card but i have another doubt
> the rebuilding started at around 12:30 pm and till 8 :30 pm the server was
> very slow though the same amount of load was on the server as it usually
has
> on it but at 8:30 pm the server was breathing free even though the
rebuilding[vbcol=seagreen]
> was not yet competed 30% was completed then my question--is there a limit
> until which the rebuilding raid hurts ur server performance only for an
> intial period or it goes in the same manner until it rebuilds completely.
> thanks
>
> "Geoff N. Hiten" wrote:
>
slows[vbcol=seagreen]
can[vbcol=seagreen]
but be[vbcol=seagreen]
the[vbcol=seagreen]
how[vbcol=seagreen]
and[vbcol=seagreen]
failure[vbcol=seagreen]
does[vbcol=seagreen]

Raid Array Failure/Rebuild SQL won''t run

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.

I've tried to manually start service but receive the following message

The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.

Here's all I have in the error logs

2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:\MSSQL\log\ERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.

Is sql server running under a service account and did you change the pwd ? is there any specific info in the event viewer ?

|||

With some assistance I ran rebuildm.exe and was able to get sql up and running.

I have been able to go through the steps to create a new database of same name then copy originals, restart SQL and bring the databases back in suspect mode.

I'm trying to read up on how to set the databases to emergency mode, check for errors and hopefully bring back to working, normal state....

Raid Array Failure/Rebuild SQL won''t run

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.

I've tried to manually start service but receive the following message

The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.

Here's all I have in the error logs

2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:\MSSQL\log\ERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.

Is sql server running under a service account and did you change the pwd ? is there any specific info in the event viewer ?

|||

With some assistance I ran rebuildm.exe and was able to get sql up and running.

I have been able to go through the steps to create a new database of same name then copy originals, restart SQL and bring the databases back in suspect mode.

I'm trying to read up on how to set the databases to emergency mode, check for errors and hopefully bring back to working, normal state....

Raid Array Failure/Rebuild SQL won''t run

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.

I've tried to manually start service but receive the following message

The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.

Here's all I have in the error logs

2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:\MSSQL\log\ERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.

Is sql server running under a service account and did you change the pwd ? is there any specific info in the event viewer ?

|||

With some assistance I ran rebuildm.exe and was able to get sql up and running.

I have been able to go through the steps to create a new database of same name then copy originals, restart SQL and bring the databases back in suspect mode.

I'm trying to read up on how to set the databases to emergency mode, check for errors and hopefully bring back to working, normal state....

RAID - Failure -- SQL Server Won't Start

Running a Dell 2400 dual CPU - 4 drive in a RAID-5
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =the files will still be there but you will need to re-attach them.
More intersting is why will SQl Server not start - can you post the =contents of the error log file. There should be no need to re-install - =but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...
> Running a Dell 2400 dual CPU - 4 drive in a RAID-5 > configuration. System was telling me I lost 2 drives > of the four - Forced restore (twice) after changing > different pices of hardware and everything seems to be > fine except SQL Server WON'T start --
> > reloaded - on top - SQL Developer Edition and SP 3a -- > still no help -- > > 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
> > jed@.experiencedtechnology.com

RAID - Failure -- SQL Server Won't Start

Running a Dell 2400 dual CPU - 4 drive in a RAID-5
configuration. System was telling me I lost 2 drives
of the four - Forced restore (twice) after changing
different pices of hardware and everything seems to be
fine except SQL Server WON'T start --
reloaded - on top - SQL Developer Edition and SP 3a --
still no help --
1. If I remove SQL - what happens to my DBs?
2. Any other ideas would be great?
jed@.experiencedtechnology.comYour databses are unaffected by uninstalling and relaoding SQL Server - =
the files will still be there but you will need to re-attach them.=20
More intersting is why will SQl Server not start - can you post the =
contents of the error log file. There should be no need to re-install - =
but any messages in the SQL Server error log will give us a clue.
Mike John
"Jim D" <anonymous@.discussions.microsoft.com> wrote in message =
news:06ec01c3d78f$8e85bb90$a501280a@.phx.gbl...

quote:

---

> Running a Dell 2400 dual CPU - 4 drive in a RAID-5=20
> configuration. System was telling me I lost 2 drives=20
> of the four - Forced restore (twice) after changing=20
> different pices of hardware and everything seems to be=20
> fine except SQL Server WON'T start --
>=20
> reloaded - on top - SQL Developer Edition and SP 3a -- =20
> still no help --=20
>=20
> 1. If I remove SQL - what happens to my DBs?
> 2. Any other ideas would be great?
>=20
> jed@.experiencedtechnology.com

---

Queue Reader Agent will not start after network failure

Senario
I have a SQL Server 2000 SP4 that is Publisher and distributor plus a SQL
Server 2000 SP3a that is a Publisher.
There replicates to 2 SQL Server 2000 SP4 over the company WAN.
After a roughly 10 min long network failure the queue reader agent will not
start.
Any ideas?
Thanks.
Jonas
Can you enable logging and post the message you get back here?
http://support.microsoft.com/kb/312292
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:7F7768C5-1FF1-4947-8318-9F9A3581A9A3@.microsoft.com...
> Senario
> I have a SQL Server 2000 SP4 that is Publisher and distributor plus a SQL
> Server 2000 SP3a that is a Publisher.
> There replicates to 2 SQL Server 2000 SP4 over the company WAN.
> After a roughly 10 min long network failure the queue reader agent will
> not
> start.
> Any ideas?
> Thanks.
> Jonas