Troubleshoot SDDDSM error messages

10 September,2014 by Jack Vamvas

Question: What is SDDDSM ? Often I see Event Log entries referencing SDDDSM , but can’t relate it back to SQL Server. How can I troubleshoot?

Answer: SDDDSM is the Subsystem Device Driver Device Specific Module. The purpose is to support IBM storage devices . It’s a multipath IO system based on the Microsoft MPIO concepts. SDDDSM and MPIO work in conjunction supporting the multipath configurations.

The general advice from IBM is to is to maintain a balanced use of all the paths and keep them active

Use the datapath query adaptstats  to view the number of reads and writes on each adapter. The aim is to maintain a balance of read and writes across the adapters. If you have problems speak to your SAN Storage expert

Sdddsm

Typical advice for reducing pressure on IO path pressure includes:

a)      Increase RAM – to increase the cache size and potentially decrease the amount of disk requests

b)      Distribute processing across a number of systems

Read More

SQL Server Storage and IO performance - SQL Server DBA

SQL Disk storage performance overview - SQL Server DBA

SQL Server - Disk IO performance and SQLIO - SQL Server DBA

Calculate disk IO throughput and MB per second - SQL Server DBA

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Troubleshoot SDDDSM error messages


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer