469,317 Members | 1,701 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Clustering, Security, Performance, Load Balance

I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.

Perhaps this group can help me fill in ms-sqlserver related following
questions.

1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.
2. Do these dB have Security features?
2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?
3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?

I want to thank everyone for taking your time to read this
correspondence. I will also greatly appreciate your efforts in sharing
your thoughts.

Regards,
Manish
Nov 27 '07 #1
3 3088
Manish (ma****@gmail.com) writes:
I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.

Perhaps this group can help me fill in ms-sqlserver related following
questions.

1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.
What sort of clustering do you have in mind? Clustering in MS SQL
Server is all about high availablility. That is two or more machines
that share disk. If one machine dies, another in the machine in the
cluster can take over very quickly.

I know that in other products, clustering is about scalinng out, but
MS SQL Server does not offering anything like that.
2. Do these dB have Security features?
Yes, there are security features in MS SQL Server. :-)
2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?
You can encrypt data in SQL 2005, and you can also use SSL for
encrypting the connection.
3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?
I'm not sure that I understand these questions. But if they were asked
with a scale-out solution like Oracle's RAC in mind, they are not
applicable to SQL Server.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 27 '07 #2
On Nov 27, 5:38 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
Manish (mar...@gmail.com) writes:
I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.
Perhaps this group can help me fill in ms-sqlserver related following
questions.
1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.

What sort of clustering do you have in mind? Clustering in MS SQL
Server is all about high availablility. That is two or more machines
that share disk. If one machine dies, another in the machine in the
cluster can take over very quickly.

I know that in other products, clustering is about scalinng out, but
MS SQL Server does not offering anything like that.
2. Do these dB have Security features?

Yes, there are security features in MS SQL Server. :-)
2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?

You can encrypt data in SQL 2005, and you can also use SSL for
encrypting the connection.
3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?

I'm not sure that I understand these questions. But if they were asked
with a scale-out solution like Oracle's RAC in mind, they are not
applicable to SQL Server.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
How does the database perform and what is the criteria for the
performance matrix? To clarify, how will one collect performance data
related to MS-SQLserver? What is the criteria for collecting such
data?
Nov 28 '07 #3
Manish (ma****@gmail.com) writes:
How does the database perform and what is the criteria for the
performance matrix? To clarify, how will one collect performance data
related to MS-SQLserver?
You can use performance counters, Profiler, query dynamic management views.
What is the criteria for collecting such data?
I'm afraid that I can't answer why you would like to collect some data.
Or I am not understanding your question.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 28 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jeff | last post: by
1 post views Thread by Nico de Groot | last post: by
2 posts views Thread by Tim Morrison | last post: by
3 posts views Thread by Shabam | last post: by
1 post views Thread by billym | last post: by
3 posts views Thread by Mike Logan | last post: by
2 posts views Thread by Mehmet Baserdem | last post: by
3 posts views Thread by dejavue82 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.