Category Archives: Performance

SSIS Tuning–Packet Size

Tuning the packet size property in connection managers can often yield significant performance improvement.  By default the packet size is 0 for OLE DB connections which defaults to the instance packet size.  In most cases the default value is 4096.  … Continue reading

Posted in Performance, SQL Server Integration Services | Leave a comment

SQL Myth – Indexes and small tables

I have often heard people say that indexes or primary keys (and their associated clustered indexes) are not needed on small tables.  I just had a performance issue with a query and found the culprit to be a relatively small … Continue reading

Posted in Database Administration, Performance | Tagged , , | Leave a comment