I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the data differ quite a lot from database to database.
What would be the best way to auto-index/profile/tune this large amount of databases?
As there are at least 600 or more catalogs I cant have someone manually profile, and index as required by each databases usage patterns.
I'm currently running SQL 2005 but will be moving to 2008, so solutions that work with either are fine.