Optimizing SQL Server Database Performance

Idea created by kenrolfsmeyer on Feb 10, 2014
    Not planned
    Score6
    • kenrolfsmeyer
    • nick.selvaggio
    • jeff.koehler
    • bekmark
    • Kyle_R
    • mauro-heine

    The current environment for CA SDM uses OLE DB set at 4k to read/write from SQL Server.  Microsoft states best practice for SQL Server 2008+ is to use 64k disk block sizes for the best I/O performance.  See the following articles:

     

    http://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx

    http://msdn.microsoft.com/en-us/library/ee377059.aspx

     

    The current OLE-DB used to communicate to SQL Server is hard coded to 4k and is not configurable by the customer.  A configuration that can be changed and extended so the OLE-DB bandwidth is equal to the block size on the SQL Server is the best configuration for optimal performance.  In order to optimize performance of SQL Server 2008, a method to allow 64k disk blocks to be used with CA SDM is desired.