?
Solved

SQL Server Disk Peformance

Posted on 2010-01-11
6
Medium Priority
?
172 Views
Last Modified: 2012-05-08
I'm setting up a new SQL Server 2008 database and have heard that 50-100X IO gains can be attain in high load environments by using separate disks for log and data files.  Thus allowing sequential log writes to not interfere with randomized inserts and updates.  Is my logic here correct?
0
Comment
Question by:Phil5780
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 26288147
seperating disks for data and log file and also for the temp files should increase the disk io performance but not as much as you indicated... I never heard or seen such that percentage. But your logic is currect and doing so is advised.
0
 

Author Comment

by:Phil5780
ID: 26288260
What kind of gains would be expected in a high load SQL Server?  We have 200+ connections per second and that figure is growing.
0
 
LVL 26

Expert Comment

by:tigin44
ID: 26288303
of course the outcoming performance increase will be the disk IO as you may know which is primary concern on heavy load servers.
0
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 

Author Comment

by:Phil5780
ID: 26288385
So the setup I've described above is optimal for a scale-out SQL Server database?
0
 
LVL 26

Accepted Solution

by:
tigin44 earned 2000 total points
ID: 26288401
sure that is...
0
 

Author Closing Comment

by:Phil5780
ID: 31675784
Great information.  I wanted to confirm my setup completely before committing.  Thanks alot:)
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question