Home > IT Answers > Storage > Database Log File sql server 2005
Rick Martinez
585 pts.
 Database Log File sql server 2005
RAID, SQL Server 2005, SQL Server 2005 performance, SQL Server logs, SQL Server performance
We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the application are we storing sql data files correctly on the SAN?

Drives on SQL Server:

C = OS X = SQL Database Files (MDF) Y = File Storage F = SQL Backups D = 500GB Database, SQL Server System Databases I = 500GB DB Indexes L = SQL Log Files T = SQL Log Files



Software/Hardware used:
SQL Server 2005
ASKED: August 5, 2010  4:35 PM
UPDATED: August 10, 2010  2:48 PM
RELATED QUESTIONS
Answer Wiki:
Well your problem is that you have all the data stored on the same physical disks so you are causing all sorts of contention on the disks. If you are using 8 drives in a RAID 10, then you actually only get to use 4 as the other 4 are a mirror of the first 4. What are you using to mirror from the first 8 disks to the second 8 disks? Are you doing a clone within the array? What kind of array is it? What kind of disks are in it? How fast are they? You should break up the LUNs so that they are on their own disks instead of a single RAID 10. Do you actually need RAID 10? What is the data change rate within the database? What percentage of calls to the database are reads and what percentage of calls are writes?
Last Wiki Answer Submitted:  August 5, 2010  7:12 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hello Mr. Denny thank you for your reply. Here are the answers to your questions. Sorry about the answers if they are not clear but that is all i got from the network team.

1. We are not using any kind of software for mirroring, we are just using RAID 10 (16 hard drives 7 for data 7 for mirroring and 2 hot swap)

2. We are not doing a clone within the array.

3. We are using RAID 1 + 0

4. The disks are fujitsu.

5. The disks are 15000 RPM.

Rick Martinez
 585 pts.
 

I forgot one thing our array is XIOTECH 7000.

Rick Martinez
 585 pts.