NetApp filers with SQL

I wanted to pose the question out there, are NetApp filers, connected via
iSCSI, supported as a storage device for a SQL 2000 database?
If yes/no, does someone have recent supporting documentation, within the
last year?
If not, I'd like to find some things to identify (via perfmon/elsewhere), to
backup this information, if possible.
Thank you!See the article
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261&Product=sql2k
then check the WHCL/WHQL to see if the specific NetApps device is on it. If
so, you are good to go.
--
Hal Berenson
VP, Yukon Readiness
Scalability Experts, Inc.
"Pete" <pbmain@.wideopenwest.com> wrote in message
news:eE4MGuXVEHA.2988@.TK2MSFTNGP10.phx.gbl...
> I wanted to pose the question out there, are NetApp filers, connected via
> iSCSI, supported as a storage device for a SQL 2000 database?
> If yes/no, does someone have recent supporting documentation, within the
> last year?
> If not, I'd like to find some things to identify (via perfmon/elsewhere),
to
> backup this information, if possible.
> Thank you!
>

NetApp Filers - Does MS support them, and do they work?

I've posed this before, but never seem to get a concrete answer:
1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
running iSCSI supported by MS for SQL 2000 implementations?
2) Does anyone run a similar configuration and run into problems?
Thanks everyone
1) A snip from the KB below
Windows Hardware Quality Lab (WHQL) Qualified Devices
Microsoft Windows servers and networked servers or NAS storage servers that
are Windows Hardware Quality Lab (WHQL) certified automatically meet the
data write ordering and write-through guarantees required to support a SQL
Server storage device. Microsoft supports both application and
storage-related issues in these configurations.
Other Devices
If you use a non-WHQL qualified storage device with SQL Server that supports
the I/O guarantees for transactional database use described in this article,
Microsoft will provide full support for SQL Server and SQL Server-based
applications.
INF: Support for Network Database Files
http://support.microsoft.com/?kbid=304261
You can check the status of the exact model here
http://www.microsoft.com/windows/catalog/server/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gary Klohouse" <fastman@.earthlink.net> wrote in message
news:OfDHJUjfEHA.2812@.tk2msftngp13.phx.gbl...
> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>
|||they are not great with Sequential Reads.
We use a NetApp filer and are not totally satisfied.
we are moving off to a Hitachi SAN.
Cheers,
Greg Jackson
PDX, Oregon
|||What is happen?
"Gary Klohouse" wrote:

> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>
>

NetApp Filers - Does MS support them, and do they work?

I've posed this before, but never seem to get a concrete answer:
1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
running iSCSI supported by MS for SQL 2000 implementations?
2) Does anyone run a similar configuration and run into problems?
Thanks everyone1) A snip from the KB below
Windows hardware Quality Lab (WHQL) Qualified Devices
Microsoft Windows servers and networked servers or NAS storage servers that
are Windows hardware Quality Lab (WHQL) certified automatically meet the
data write ordering and write-through guarantees required to support a SQL
Server storage device. Microsoft supports both application and
storage-related issues in these configurations.
Other Devices
If you use a non-WHQL qualified storage device with SQL Server that supports
the I/O guarantees for transactional database use described in this article,
Microsoft will provide full support for SQL Server and SQL Server-based
applications.
INF: Support for Network Database Files
http://support.microsoft.com/?kbid=304261
You can check the status of the exact model here
http://www.microsoft.com/windows/catalog/server/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gary Klohouse" <fastman@.earthlink.net> wrote in message
news:OfDHJUjfEHA.2812@.tk2msftngp13.phx.gbl...
> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>|||they are not great with Sequential Reads.
We use a NetApp filer and are not totally satisfied.
we are moving off to a Hitachi SAN.
Cheers,
Greg Jackson
PDX, Oregon|||What is happen?
"Gary Klohouse" wrote:

> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>
>

NetApp Filers - Does MS support them, and do they work?

I've posed this before, but never seem to get a concrete answer:
1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
running iSCSI supported by MS for SQL 2000 implementations?
2) Does anyone run a similar configuration and run into problems?
Thanks everyone1) A snip from the KB below
Windows Hardware Quality Lab (WHQL) Qualified Devices
Microsoft Windows servers and networked servers or NAS storage servers that
are Windows Hardware Quality Lab (WHQL) certified automatically meet the
data write ordering and write-through guarantees required to support a SQL
Server storage device. Microsoft supports both application and
storage-related issues in these configurations.
Other Devices
If you use a non-WHQL qualified storage device with SQL Server that supports
the I/O guarantees for transactional database use described in this article,
Microsoft will provide full support for SQL Server and SQL Server-based
applications.
INF: Support for Network Database Files
http://support.microsoft.com/?kbid=304261
You can check the status of the exact model here
http://www.microsoft.com/windows/catalog/server/
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gary Klohouse" <fastman@.earthlink.net> wrote in message
news:OfDHJUjfEHA.2812@.tk2msftngp13.phx.gbl...
> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>|||they are not great with Sequential Reads.
We use a NetApp filer and are not totally satisfied.
we are moving off to a Hitachi SAN.
Cheers,
Greg Jackson
PDX, Oregon

net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgs
First of all, make sure you can do that net send outside of SQL. Test at cmd
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs
|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs
sql

net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgsFirst of all, make sure you can do that net send outside of SQL. Test at cm
d
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQ
L
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operato
r
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQ
L
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operato
r
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs

net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgsFirst of all, make sure you can do that net send outside of SQL. Test at cmd
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:
> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:
> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs