Database Log File sql server 2005

585 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rick Martinez
    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.
    585 pointsBadges:
    report
  • Rick Martinez
    I forgot one thing our array is XIOTECH 7000.
    585 pointsBadges:
    report
  • Rick Martinez
    [...] 7. RickMartinez seeks help with his database log file SQL Server 2005 and wonders if improper storage of SQL data files on the SAN is th.... [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following