Re: Clustering, Security, Performance, Load Balance

On Nov 27, 5:38 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
Manish (mar...@xxxxxxxxx) 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...@xxxxxxxxxxxxx

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

Relevant Pages

  • Re: Clustering, Security, Performance, Load Balance
    ... Do this database have data Clustering capabilities? ... MS SQL Server does not offering anything like that. ... support encryption or SSL connection? ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Indexes Confuses me!!
    ... Kalen Delaney has a column called Inside SQL Server in SQLMag ... and performs a bookmark lookup. ... reading the actual data row costs a single logical page read. ... >>>>>performing a bookmark lookup using clustering keys (i.e., ...
    (microsoft.public.sqlserver.programming)
  • Re: Quorum Disk or Majority Node?
    ... SQL Server does not NATIVELY support MNS clustering. ... >> The chapter "Three-Site Majority Node Set Quorum in Geographically ...
    (microsoft.public.sqlserver.clustering)
  • RE: Views
    ... you must understand that SQL Server 2000 does not support ... database data encryption as such. ... following method in the KB below to enhance the security. ... Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.sqlserver.programming)