|
|
Posted by Manish on 11/28/07 12:54
On Nov 27, 5:38 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> 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?
Navigation:
[Reply to this message]
|