Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a new local server that processes data using sql server 2008 and ssis. in this server i have dedicated drive to do different things. the c drive is for the os and software. the d drive is for db storage , and the ssis . The e drive is a ssd drive that we restore each database that is being used by the ssis.

our idea was that we process allot of data and since the ssd drive is only 500gb( because of the cost) we would have everything on a regular drive and transfer the databases in use to the ssd drive to have the process run faster.

when i run the ssis without the ssd drive it takes about 8 hrs and when i run the process restoring the databases on the ssd drive the process takes about the same amount of time to process( in fact if i include the restoring of the data bases the process takes longer) As of right now i cannot move the os and software to the ssd drive to test to see if that would help the process.

is there a way to utilize the ssd drive to process the data and to speed up the process.

share|improve this question
Are you sure that storage is the bottleneck in your processing??? – Chris S Jan 7 '14 at 15:07
up vote 0 down vote accepted

is there a way to utilize the ssd drive to process the data and to speed up the process.

If storage speed ain't the problem, faster storage ain't the solution.

Use perfmon, SQL Server Profiler, or similar tools to figure out what the bottleneck actually is, then throw resources at that. If you're doing a lot of intensive computation, generally RAM and CPU will be the bottleneck - the solution is most commonly cleaning up the SQL, then throwing more CPU/RAM at the problem if the code is already reasonably efficient.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.