Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluation/features/choosing.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> > Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> > protocols by using the Virtual Interface Architecture (VIA), but it
> doesn't
> > say explicitly : whether SQL Server 2000 Standard Edition also supports
> VIA.
> > So I don't know do I have to buy the Enterprise Edition if I want to use
> SAN
> > as the storage area for my SQL 2000 application.
> > Can anybody help me on it because the Enterprise Edition is much
expensive
> > than the Standard Edition.
> >
> >
>
Showing posts with label san. Show all posts
Showing posts with label san. Show all posts
Tuesday, March 27, 2012
Does SQL Server 2000 Standard Edition does not support SAN ?
Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.
No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluat.../choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different[vbcol=seagreen]
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive
>
sql
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.
No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluat.../choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different[vbcol=seagreen]
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive
>
sql
Does SQL Server 2000 Standard Edition does not support SAN ?
Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evalua...s/choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive[vbcol=seagreen]
>
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evalua...s/choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive[vbcol=seagreen]
>
Monday, March 19, 2012
Does MS SQL 2000 support multiple processors?
We are in the process of moving our SQL servers to a SAN
environment and decided to upgrade our servers to 4
processors. Therefore, does anyone know if MS SQL 2000
supports multiple processors?Depends on the edition. See BOL: Maximum Capacity Specifications for the
complete OS\Edition matrix. For four processors, you can use any of the
Windows Server OS editions and Standard or Enterprise Edition SQL Server
2000.
From the performance side, SQL does very well with multiple processors.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Cory" <crubicco@.yahoo.com> wrote in message
news:04ae01c3883d$882e63b0$a301280a@.phx.gbl...
> We are in the process of moving our SQL servers to a SAN
> environment and decided to upgrade our servers to 4
> processors. Therefore, does anyone know if MS SQL 2000
> supports multiple processors?
environment and decided to upgrade our servers to 4
processors. Therefore, does anyone know if MS SQL 2000
supports multiple processors?Depends on the edition. See BOL: Maximum Capacity Specifications for the
complete OS\Edition matrix. For four processors, you can use any of the
Windows Server OS editions and Standard or Enterprise Edition SQL Server
2000.
From the performance side, SQL does very well with multiple processors.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Cory" <crubicco@.yahoo.com> wrote in message
news:04ae01c3883d$882e63b0$a301280a@.phx.gbl...
> We are in the process of moving our SQL servers to a SAN
> environment and decided to upgrade our servers to 4
> processors. Therefore, does anyone know if MS SQL 2000
> supports multiple processors?
Friday, February 17, 2012
docs for 2003 enterprise cluster
Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
http://www.sage-eshop.com
Installing SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> http://www.sage-eshop.com
>
>
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
http://www.sage-eshop.com
Installing SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> http://www.sage-eshop.com
>
>
docs for 2003 enterprise cluster
Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL200
0
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL200
0
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>
docs for 2003 enterprise cluster
Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>
Subscribe to:
Posts (Atom)