SQL Server Performance

Working with 2 servers SQL

Discussion in 'General DBA Questions' started by jdoleo, Aug 29, 2006.

  1. jdoleo New Member

    Judgments;

    I am beginning the Database Management in SQL. At present I have an application Web in ASP.NET with SQL Server 2000, the same , drive several localities and to enlarge the performace want to having 2 servers SQL. I have sought information on the same one but the only thing that I have found is to do it with Cluster, but this only works with Windows 2003 server or W2000 Advanced Server and what I have is W2000 Server.

    If they may help oneself he would be useful for me plenty of.

    Greetings
  2. ghemant Moderator

    Hi,
    As you ask for Two SQL Server, what would you like to do !? and what is your basic requirement with it ?!
    or would you re-phrase your question!

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
  3. jdoleo New Member

    Hello, Hemantgiri, How Are You?,

    Thanks to respond. Really what I need is to increase my server's performance SQL, ad hoc was wanting to know if I can have 2 parallel servants moving a same database, that he not be for Cluster since the Cluster not support my Operating System. At present my server has CPU Xeon 3,0 GHz, 100GB Hard Disk, 2 GB Memory. Now me this one working perfect, but want to knowing that to do the moment that he reduce performance.

    Thanks,
  4. ghemant Moderator

    Hi,
    you may setup
    Snapshot Replication Or Transactional Replication Or Merge Replication (it depends upon your requirement) or you may setup LogShipping too , kinldy refer Books Online for the same.

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
  5. satya Moderator

    Replication is based on the set of tables to perform such data portability, if you need the load balancing for whole database then I prefer to increase the server physical resources such as Memory, physical disk etc. Also make sure to optimize the database for long running queries and for this you can take help of PROFILER, INdex tuning wizard and PERFMON for resource usage information. By all means take your time to read updated SQL Server books online about performance tuning topis.

    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