SQL Server Performance

instances

Discussion in 'General DBA Questions' started by shashank sharma, Jul 17, 2006.

  1. shashank sharma New Member

    hi all
    I might be askin simple questions to you all, but plz bare with as iam much juniour to all people out there
    wat is an instance in sql server if any link which says clearly about it ill be happy
    thanks in advance
    trne DBA
    shashank sharma

    failure is elder brother of sucess
  2. dineshasanka Moderator

    First you can ask any questions here. We all went this stage. we all were juniors at times.

    SQL Server you can have two or more sql servers in one Pc. that is called an instance. Say you PC name is A, then you can have default instance as A. if you want to have another instance for testing purposes that SQL server can be ATEST.

    These instances need not to be in same version of SQL Server. one can SQL Server 2000 one can be sql server 5 and one can be 2005.

    Read BOL for more configurations details

    ----------------------------------------

  3. dineshasanka Moderator

  4. satya Moderator

    Shashank
    Few replies to your question may sound harsh, but we don't mean to ... hurt.

    IMHO it is better for you as well to refer to the books online and search thru the similar posts in the forum as well, that way the time is saved and you will learn more.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page