SQL Server Performance

better way to improve sql performance

Discussion in 'Performance Tuning for DBAs' started by johnnywhale, Oct 4, 2007.

  1. johnnywhale New Member

    The SQL server is running very slow and it's improved a bit after I upgraded the server hardware. The database is growing quickly and same to the usage.
    I am thinking to do replication (seperate update and select) or seperate database tables into 2 physical servers. Any recommendations?
    Thank you.
  2. ndinakar Member

    How frequently do you do your maintenance?
  3. johnnywhale New Member

    What kind of mantenance? I only backup and shrink the log file.
  4. satya Moderator

    SQL Server is self managed in terms of choosing better plan for performance, but if you have missed the database maintenance tasks then it is very hard to expect or keep up the optimum performance.
    Maintenance tasks include REINDEXING & CHECKING consistency of database, a good SQL Server maintenance plan can do wonders if planned correctly, implemented successfully and managed appropriately and properly.
    SQL Server provides a maintenance plan that help to implement appropriate measures to ensure that your database is safe and properly maintained. So what is a database maintenance plan and how can you configure a good SQL Server maintenance plan? This article http://www.mssqltips.com/tip.asp?tip=1013 will help you through.
    Moreover going these links will get you overall tasks involved in keeping up the performance:
    http://www.sql-server-performance.com/articles/per/main.aspx, http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
    and http://www.sql-server-performance.com/software/monitor_reviews.aspx
    So in a nutshell replication is only for scalability and firstly you need to address the fragmentation issues on the indexes for the performance then think about replicaiton.
    Hope this helps.
  5. johnnywhale New Member

    Thanks a lot!
    I will look into that.

Share This Page