August 25, 2006 at 8:11 am
We currently have two similar database servers, both have RAID 5 installed. SQL Server 2005 is the db engine and both servers have exactly the same databases running (in terms of schema and data). We have several stored procedures, when we execute it on the database server, we notice that one of the servers completes the proc in 2 seconds and the other one processes it in 15 sec. Also the restore on the second server is much slower. On server 1 it takes around 40 min to perform a restore and on server 2 it takes 5 hours. We were restoring the same backup file, and in both cases we were pulling it locally from the disk drive. The recovery model on both DBs is set to simple.
Controllers:
Perc 4/DC - faster server
Perc 5/i - slower server
Comments, ideas would be much appreciated.
Thanks,
Luke
August 25, 2006 at 11:11 am
Luke,
check also how much memory and what are the CPUs, how many threads. The easy way to check is Task manager that will show you all CPU threads and memory usage when you execute your stored procedure on both servers. If it does not help, run basic counters with Performance tool.
Follow the link to New England SQL User Group:
http://www.nesql.org/Files.aspx
and download presentation:
| Practical Performance Monitoring with 2005 by Andrew Kelly |
Regards,Yelena Varsha
August 25, 2006 at 2:27 pm
Thanks for the tip, but we already checked memory and cpu utilization. The cpu and memory is hardly used. It's very idle... We have SQL server setup to use min. 1GB of RAM and run on all 4 cpus. The memory usage goes up slightly during query execution, the max for sql server is 8gb. CPU utilization stays at around 2%-3%
Thanks
August 25, 2006 at 4:17 pm
What happens when you copy the same file on both machines? Does it take the same time or one server is faster? Check performanc counters for Physical Disk and for Logical Disk.
Regards,Yelena Varsha
August 28, 2006 at 7:17 am
One of the servers is much faster, the one where queries run for about a second. The file copy on that one takes couple of minutes vs. about 30 min on server #2. I looked at the performance counters, strange thing -- writes/sec and reads/sec barely move.
I looked at the event viewer but there are no errors of any kind.
August 28, 2006 at 10:03 am
Not sure, but have you checked to see if you have a failed drive on the raid 5 on the slower system?
September 15, 2006 at 12:34 pm
Turns out it was a problem with the controller.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply