SQL Server with Mr. Denny

Nov 25 2010   11:00AM GMT

What are the best counters or KPIs to identify what dirves woudl benefit from EFD’s and can be used to reflect before and after performance metrics?



Posted by: Denny Cherry
Tags:
SQL Server
Storage

EFDs (Enterprise Flash Disks) or SSDs (Solid State Disks) are all the rage today for systems which have very high IO load requirements.  But knowing if your disks would benefit from this technology can be a bit of a problem if you don’t know where to look.  After all these disks are not cheap.

Some perfmon settings that you’ll want to look at include the seconds per operation, operations per second, disk queue.  Now if you are in a SAN environment you will also want to look at the metrics which the array presents to confirm that the problem is actually on the array side and not just a problem of the server.

However if the server has its own disks on the storage array, and the array numbers match what the server is seeing then it may be time to look at EFDs or SSDs for your disk solution.

Denny

 Comment on this Post

 
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 other members comment.

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

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: