RAID and Cluster!

Hi All, Want to seek advice and experience from all of you. What is the
recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or RAID-5?
We just upgraded from RAID 1+0 to RAID 5 and since then we are getting
hiccups on the Cluster. If there is any connectivity failures on the Drives
(which are recovered after few mins) the Cluster goes haywire and becomes
unavailable (for e.g. it fails to read off the Quorum Log etc...)
Thanks in adv.
Env:
Win2000 Adv Server SP4
SQL2000 SP4
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23Lb1UxbIGHA.524@.TK2MSFTNGP09.phx.gbl...
> Hi All, Want to seek advice and experience from all of you. What is the
> recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or
RAID-5?
> We just upgraded from RAID 1+0 to RAID 5 and since then we are getting
> hiccups on the Cluster. If there is any connectivity failures on the
Drives
> (which are recovered after few mins) the Cluster goes haywire and becomes
> unavailable (for e.g. it fails to read off the Quorum Log etc...)
>
> Thanks in adv.
>
|||First, you need to fix you SAN issues, with or without clustering SQL really
likes to have its disks online at all times.
Have you separated your Databases and Transaction Log files? RAID 1 or 10
for the Logs. Raid 5 or 10 for the Databases. Quorum & MSDTC (if required)
on its own disk subsystems of 1 GB in size.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23Lb1UxbIGHA.524@.TK2MSFTNGP09.phx.gbl...
> Hi All, Want to seek advice and experience from all of you. What is the
> recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or
> RAID-5?
> We just upgraded from RAID 1+0 to RAID 5 and since then we are getting
> hiccups on the Cluster. If there is any connectivity failures on the
> Drives
> (which are recovered after few mins) the Cluster goes haywire and becomes
> unavailable (for e.g. it fails to read off the Quorum Log etc...)
>
> Thanks in adv.
>
|||That's not an upgrade, it is a reconfiguration. They do completely
different things. By RAID 1+0 do you mean a stripe of mirrors or a mirror
of stripes?
In either case, the answer is, I don't know. RAID5 gives particular levels
of redundancy while incurring a performance impact for certain types of I/O
patterns. A mirror of stripes gives equivalent redundancy to RAID5 without
having quite a much of a performance impact on certain types of I/O
patterns. A stripe of mirrors gives much greater redundancy than the other
two and generally better performance as well. But, if you are saturating
the I/O channel or stuffing all of your data on a tiny subset of the drives
in the SAN, it really isn't going to matter very much. The recommendations
also vary depending upon whether you have an access pattern that looks like
"tradional OLTP", "traditional DW", or a mix of the two.
Regardless of the performance characteristics, neither one is going to be
more stable than the other in your case. If the SAN drives disconnect, it
doesn't matter if it is a cluster or a standalone SQL Server, it isn't going
to like it. You have to fix the errors on your SAN that are causing the
disconnects first. If those aren't fixed, there isn't anything you are
going to be able to do to make the system stable.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23Lb1UxbIGHA.524@.TK2MSFTNGP09.phx.gbl...
> Hi All, Want to seek advice and experience from all of you. What is the
> recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or
> RAID-5?
> We just upgraded from RAID 1+0 to RAID 5 and since then we are getting
> hiccups on the Cluster. If there is any connectivity failures on the
> Drives
> (which are recovered after few mins) the Cluster goes haywire and becomes
> unavailable (for e.g. it fails to read off the Quorum Log etc...)
>
> Thanks in adv.
>
|||Not to mention that unless you have proper host isolation in the SAN, you
are going to run into severe spindle contention, even if this particular
host's channels are not saturated.
Anthony Thomas

"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%234b0uwdIGHA.676@.TK2MSFTNGP10.phx.gbl...
> That's not an upgrade, it is a reconfiguration. They do completely
> different things. By RAID 1+0 do you mean a stripe of mirrors or a mirror
> of stripes?
> In either case, the answer is, I don't know. RAID5 gives particular
levels
> of redundancy while incurring a performance impact for certain types of
I/O
> patterns. A mirror of stripes gives equivalent redundancy to RAID5
without
> having quite a much of a performance impact on certain types of I/O
> patterns. A stripe of mirrors gives much greater redundancy than the
other
> two and generally better performance as well. But, if you are saturating
> the I/O channel or stuffing all of your data on a tiny subset of the
drives
> in the SAN, it really isn't going to matter very much. The
recommendations
> also vary depending upon whether you have an access pattern that looks
like
> "tradional OLTP", "traditional DW", or a mix of the two.
> Regardless of the performance characteristics, neither one is going to be
> more stable than the other in your case. If the SAN drives disconnect, it
> doesn't matter if it is a cluster or a standalone SQL Server, it isn't
going[vbcol=seagreen]
> to like it. You have to fix the errors on your SAN that are causing the
> disconnects first. If those aren't fixed, there isn't anything you are
> going to be able to do to make the system stable.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Vai2000" <nospam@.microsoft.com> wrote in message
> news:%23Lb1UxbIGHA.524@.TK2MSFTNGP09.phx.gbl...
becomes
>
sql

Quick Question - Need some advice on troubleshooting SSIS Errors

Hi Everyone:

I have a SSIS Package which in brief moves data from one SQL data store to another. On my local machine, the package executes fines, and does what it is supposed to do, by moving data from Point A to Point B. I have both Point A(DB) and Point B(DB) on my local machine. But when I deploy this package over to ASSEMBLY which is basically another environment, I get weird intermittent errors. What should I do? Can someone give me some tips on how to do good error logging in SSIS? I am currently writing to Windows Event Log, and I seem to look at some errors that are coming thru. What else can I do on SSIS Package side, to improve error reporting and handling, so troubleshooting is faster and more effective. I just need some stable advice on how to setup my package to do error logging where troubleshooting issues in different environments is more effective. Also I need to know, what could be causing these issues? Thanks.

MA

Try turning on package logging. Set it to log to SQL Server. It will then be in the chosen databases' sysdtslog90 table.

Right click on the control flow background to get at package logging.|||

There are plenty of resources out there....

SSIS Logging

http://www.databasejournal.com/features/mssql/article.php/3562406

http://msdn2.microsoft.com/en-us/library/ms167456.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c-13ffcd114a73&DisplayLang=en

Custom Logging:

http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

|||

Do i have to specify this table in the configuration column when setting up the log provider to write to SQL Server tables? Where do i find sysdtslog90 table? Thanks.

|||

MA2005 wrote:

Do i have to specify this table in the configuration column when setting up the log provider to write to SQL Server tables? Where do i find sysdtslog90 table? Thanks.

When you set up logging, you have to chose a database/connection. In that database you'll find the sysdtslog90 table.|||

Here is the error I keep getting, which I am not getting in my Local Machine Environment. Hmmmm... any ideas?

Executing the query "exec dbo.uspSaveMain_CEAImport ?, ?, ? OUTPUT" failed with the following error: "Grantor does not have GRANT permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set

correctly, or connection not established correctly.

|||It looks like your user lacks some DB permission in the env where you are pointing to.