Stick your Fusions in the right slot!

Selecting the correct PCI slot for FusionIO card installation

Finally got some breathing space for my first post of the year! In order to get a major client through Christmas which is traditionally their busiest period of the year (where load normally goes up five-fold), we embarked on a major platform refresh where both the back end SQL Server DBMS was upgraded from SQL […]

Impact of Fusion-io based tempdb on reindex duration

Tuning tempdb performance with FusionIO cards is a given but you may not be taking full advantage if reindexing is left on default settings.

Do you have tempdb on Fusion-io (or equivalent) technology? Is your reindexing job left on default settings (re-orgs at 5-15% and full rebuilds at @ 30%)? If so, then you might be interested in the findings in this post. The benefits of flash memory as a replacement for spinning drives in order to boost SQL […]