Are there any significant performance issues between running raid 5 verses
raid 10
with equal hardware configurations?. Thanks for being there to help, you
people have been life-savers.
Hi
Check out SQL Server 2000 Performance Tuning Technical Reference ISBN
0-7356-1270-6
There is a performance gain from Raid 10, this has to be taken into the
context of the system as a whole and what loads it will be under.
John
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
|||Yes for sure..
Only think i can say that cost is high with RAID 10 but for performance it's
great..
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
|||in most cases, yes.
I think I have read articles that suggest anything over 10% Writes you
should get off of RAID 5
Greg Jackson
PDX, Oregon
|||We found that RAID10 was over twice as fast when used for our database dump
volume as compared to RAID5. Not to mention that RAID10 is significantly
more tolerant of disk failures.
Mike Kruchten
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
|||Check out what this site has to say about Raid 5:
http://www.baarf.com/
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
Showing posts with label equal. Show all posts
Showing posts with label equal. Show all posts
Monday, March 26, 2012
Raid 10 and SQL
Labels:
10with,
configurations,
database,
equal,
hardware,
microsoft,
mysql,
oracle,
performance,
raid,
running,
server,
significant,
sql,
versesraid
Raid 10 and SQL
Are there any significant performance issues between running raid 5 verses
raid 10
with equal hardware configurations?. Thanks for being there to help, you
people have been life-savers.Yes for sure..
Only think i can say that cost is high with RAID 10 but for performance it's
great..
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Hi
Check out SQL Server 2000 Performance Tuning Technical Reference ISBN
0-7356-1270-6
There is a performance gain from Raid 10, this has to be taken into the
context of the system as a whole and what loads it will be under.
John
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||in most cases, yes.
I think I have read articles that suggest anything over 10% Writes you
should get off of RAID 5
Greg Jackson
PDX, Oregon|||We found that RAID10 was over twice as fast when used for our database dump
volume as compared to RAID5. Not to mention that RAID10 is significantly
more tolerant of disk failures.
Mike Kruchten
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Check out what this site has to say about Raid 5:
http://www.baarf.com/
--
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
raid 10
with equal hardware configurations?. Thanks for being there to help, you
people have been life-savers.Yes for sure..
Only think i can say that cost is high with RAID 10 but for performance it's
great..
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Hi
Check out SQL Server 2000 Performance Tuning Technical Reference ISBN
0-7356-1270-6
There is a performance gain from Raid 10, this has to be taken into the
context of the system as a whole and what loads it will be under.
John
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||in most cases, yes.
I think I have read articles that suggest anything over 10% Writes you
should get off of RAID 5
Greg Jackson
PDX, Oregon|||We found that RAID10 was over twice as fast when used for our database dump
volume as compared to RAID5. Not to mention that RAID10 is significantly
more tolerant of disk failures.
Mike Kruchten
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Check out what this site has to say about Raid 5:
http://www.baarf.com/
--
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
Labels:
configurations,
database,
equal,
hardware,
microsoft,
mysql,
oracle,
performance,
raid,
running,
server,
significant,
sql,
verses
Raid 10 and SQL
Are there any significant performance issues between running raid 5 verses
raid 10
with equal hardware configurations?. Thanks for being there to help, you
people have been life-savers.Hi
Check out SQL Server 2000 Performance Tuning Technical Reference ISBN
0-7356-1270-6
There is a performance gain from Raid 10, this has to be taken into the
context of the system as a whole and what loads it will be under.
John
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Yes for sure..
Only think i can say that cost is high with RAID 10 but for performance it's
great..
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||in most cases, yes.
I think I have read articles that suggest anything over 10% Writes you
should get off of RAID 5
Greg Jackson
PDX, Oregon|||We found that RAID10 was over twice as fast when used for our database dump
volume as compared to RAID5. Not to mention that RAID10 is significantly
more tolerant of disk failures.
Mike Kruchten
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Check out what this site has to say about Raid 5:
http://www.baarf.com/
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
raid 10
with equal hardware configurations?. Thanks for being there to help, you
people have been life-savers.Hi
Check out SQL Server 2000 Performance Tuning Technical Reference ISBN
0-7356-1270-6
There is a performance gain from Raid 10, this has to be taken into the
context of the system as a whole and what loads it will be under.
John
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Yes for sure..
Only think i can say that cost is high with RAID 10 but for performance it's
great..
"coenzyme" wrote:
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||in most cases, yes.
I think I have read articles that suggest anything over 10% Writes you
should get off of RAID 5
Greg Jackson
PDX, Oregon|||We found that RAID10 was over twice as fast when used for our database dump
volume as compared to RAID5. Not to mention that RAID10 is significantly
more tolerant of disk failures.
Mike Kruchten
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>|||Check out what this site has to say about Raid 5:
http://www.baarf.com/
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
Labels:
10with,
configurations,
database,
equal,
hardware,
microsoft,
mysql,
oracle,
performance,
raid,
running,
server,
significant,
sql,
versesraid
Friday, March 9, 2012
Quick select statement question
hi all
another easy one
how would i write it to where i select a value = 0 where all are equal to 0 rather than one line. when selecting based off a key from another table how would i select the values that all bring back 0 for that key rather than just a line or 2? i hope that makes sense, lol.What have you come up with so far?|||select case when exists(select * from MyTable where MyValue <> 0) then 1 else 0 end|||SELECT dbo.tPA00175.chrJobNumber, dbo.tPA00175.intJobKey, dbo.tPA00125.numQuantityToInv
FROM dbo.tPA00125 INNER JOIN
dbo.tPA00175 ON dbo.tPA00125.intJobKey = dbo.tPA00175.intJobKey
WHERE (dbo.tPA00125.numQuantityToInv = 0)
but this is only selecting the single values...id like to select the ones that have all 0's for the particular jobkey|||How about:
select dbo.tPA00175.chrJobNumber,
dbo.tPA00175.intJobKey,
numQuantityToInv = 0
from dbo.tPA00175 inner join (select intJobKey
from dbo.tPA00125
group by intJobKey
having max(case when numQuantityToInv = 0 then 0 else 1 end) = 0
) as t2 on dbo.tPA00175.intJobKey = t2.intJobKey|||thanks, that works nicely
another easy one
how would i write it to where i select a value = 0 where all are equal to 0 rather than one line. when selecting based off a key from another table how would i select the values that all bring back 0 for that key rather than just a line or 2? i hope that makes sense, lol.What have you come up with so far?|||select case when exists(select * from MyTable where MyValue <> 0) then 1 else 0 end|||SELECT dbo.tPA00175.chrJobNumber, dbo.tPA00175.intJobKey, dbo.tPA00125.numQuantityToInv
FROM dbo.tPA00125 INNER JOIN
dbo.tPA00175 ON dbo.tPA00125.intJobKey = dbo.tPA00175.intJobKey
WHERE (dbo.tPA00125.numQuantityToInv = 0)
but this is only selecting the single values...id like to select the ones that have all 0's for the particular jobkey|||How about:
select dbo.tPA00175.chrJobNumber,
dbo.tPA00175.intJobKey,
numQuantityToInv = 0
from dbo.tPA00175 inner join (select intJobKey
from dbo.tPA00125
group by intJobKey
having max(case when numQuantityToInv = 0 then 0 else 1 end) = 0
) as t2 on dbo.tPA00175.intJobKey = t2.intJobKey|||thanks, that works nicely
Subscribe to:
Posts (Atom)