Browse by Tags

Exploring backup read io performance
24 January 2010 14:12

I was recently exploring how to increase the backup read throughput on one of our SQL servers. Below are some interesting facts i found. I would say that one of the most important reminders that came from the exercise is, do not assume that 2 databases being backup up on the same server using an identical backup command means that the processes are identical... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Performance, Database Engine, 2008, Backup

SSAS 2008 - INI Files and in place upgrades
24 September 2009 22:13

Being the suspicious person i am i wondered if there would be any differences in the MSMDSRV.ini of an instance upgraded from 2005 as opposed to a clean install. Now obviously i expect an in place upgrade to preserve my settings and add any new ones because it should not overwrite anything since i might have change from defaults for a good reason……. Below is... Read More...

by ACALVETT | with no comments

Filed under: Tips, SSAS 2005, Analysis Services, SSAS, 2008