SQL Server Performance Forum – Threads Archive

Server Machine for SQL Server

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

---

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.

---

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.

---

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.

---

]]>