I've been a little quiet on this blog for awhile.  My apologies, but my latest project has kept me pretty busy.  One of my clients is a CA Allfusion Gen  user, and they had the encyclopedia on an Oracle server.  The Oracle licenses were becoming expensive and the strategic direction was to move away from Oracle to SQL Server, so I was asked to help them setup the SQL Server system and migrate the data.  CA said it couldn't be done, and no one had done it to their knowledge, but we pulled it off.  DTS moved the data beautifully (About 30GB of data altogether), and we moved to a new server over a weekend.  There were a few performance issues out of the gate, but we added some indexes to the database and remove Parallelism, and now the users are very happy, claiming better performance than on the Oracle system!  That's what we like to hear.  Good ol' SQL Server drubs the competition again!!!

As a side note, I've never seen an application push data like this one.  It was so bad (before tuning), we were making the SAN guys complain about performance.  It was hurrendous.  AVG Disk Queue lengths of 149 - after adjusting for the number of spindles!  We're still looking at further tuning, but response time is good, now! :)

Jon