SQL Server Performance

Server Machine for SQL Server

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by cosmic, Apr 25, 2007.

  1. cosmic New Member

    Hi,
    I have many SQL server Databases of about 10-20GB with many developers executing scripts and backing up and restoring the databases concurrently. This grinds the server to a halt and no one is able to work. Working this way is vital because we support many clients with large SQL DBs of different versions that need to be running on our systems.

    I currently have an HP Server (4GB of RAM, I TeraByte, 3.2 Ghz Dual Core Xeon Processor ) it has been very disappointing. I have other lower spec'ed servers and they are - of course a lot worse.

    Is there a way I can optimize my current servers, or do I need to buy a new server altogether, and if so, what would you recommend?

    Thanks,

    Mtandao
  2. satya Moderator

    I believe you need the statistics to collect during the busy times and quieter times. I suggest to take help of thishttp://www.sql-server-performance.com/sql_server_performance_audit.asp in order to collect the audit of your system to assess further.

    There is no straight way to say switch this or disable this would get you the performance, it depens how the database has been normalized and optimized for better performance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. cosmic New Member

    quote:Originally posted by satya

    I believe you need the statistics to collect during the busy times and quieter times. I suggest to take help of thishttp://www.sql-server-performance.com/sql_server_performance_audit.asp in order to collect the audit of your system to assess further.

    There is no straight way to say switch this or disable this would get you the performance, it depens how the database has been normalized and optimized for better performance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

    Thanks Satya,
    I will collect statistics on my systems so that I can get a better understanding of the problem thanks for the link. A consultant I hired to help me sort out these issues claimed that it is not possible to run all these operations at the same time on one server without resulting in serious performance issues especially backup and restoration tasks, which are the most expensive operations to run at the moment. I am forced to limit the number of people backing up or restoring to only one at a time and even then the performance is far from commendable.
  4. satya Moderator

    HOw many times the backup and restore operations are occuring in a span of 5 minutes/15 minutes/30 minutes?

    If this is failing due to the backup/restore then get the Hardware vendor to check & certify the hardware?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. cosmic New Member

    The backups/restores are not failing. They are just taking up a lot of the resources. Therefore when doing a restore the sql server's performance degrades drastically. A restore generally would take an hour or two to do.

Share This Page