Showing posts with label equal. Show all posts
Showing posts with label equal. Show all posts

Monday, March 26, 2012

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

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