|Hi all, i cant think about an appropriated subject for the topic.|
Here is the thing.
We have a Server with this specs
Windows Server 2008
8 x Intel Xeon L7555
32 GB Ram
RAID 5 with SAS disks. poweredge storage-
In the server we have
SQL Server 2008
15 GB for windows only.
Our company system hosted (app based on Visual fox pro 9)
When we test the storage via Performance Monitor and HDTach, we have 22 MB MB/s for average read (disk) (hdtack)
I think this is ridiculous becouse the hardware we have (i must say i'm not a
I ask here because we are encharged of sql server, no the hardware of the server, and i'm not a specialist hardware guy, but you dont have to be an especialist when see something like this.
I investigated performance monitor, with some Windows Server counters and I reach to the conclusion that we have a serious bottleneck problem.
Sorry for my out of practice english.. and what do you think about this (if the server is affected by disk performance)
The problems we have.. for example.
We copy a backup of SQL Server (80GB) from the main server to other server.. and literaly noone can use the system and the net colapse.
Yes, the other day we made the test, 1 minute to access the system (variable but a long time)
When the transfer finish, everything comes to normal.
Other important point, every transfer we made between servers is about 15-30Mb/s. I think this is too slow but.
I think this is one big problem that affects performance in many ways, but I need your opinions with experience