[Webinar] Streamline your web hosting managementRegister Today


Tempdb performance on Fibre Channel vs EFD

Posted on 2010-04-07
Medium Priority
Last Modified: 2012-06-27
How do you rate tempdb performance on Fibre Channel over EFD drives.?
Right now I am seeing slow performance when placed on Fibre channel..
Would it be better putting them over EFD's?
Question by:venk_r

Accepted Solution

ProjectChampion earned 1500 total points
ID: 30059009
Depends really on what is actually at the end of the fibre channel. If you have a neatly configured array of decent disks, you might not get much ROI. If you're a perfectionist when it comes to performance, I'd recommend RAM disk! That would surely make a DIFFERENCE in the performance.
In the meantime you might want to have a closer look at the underlying causes of your performance issue. All my DBs including the TEmpDB are on a couple if RAID10 array of SAS drives which are connected to the blades via FC and I don't have any performance issues with the temp DBs at all. But if you decide to go ahead with EFD plan, please do let me know about the result. ; )  

Author Closing Comment

ID: 32666790

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

590 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