emile.milne (1/23/2013)
Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.If I want to tweak the index for reports they need to be added to the LIVE db. Very poor oversight.
Always On incorporates mirroring from 2005/2008 and makes the mirror database read only without having to create a database snapshot. Great for high availability and reporting that does not need different indexing than the principal database currently supporting an application.
If you were able to add indexes on one of the "mirrors" (Always On can have up to 4, 2 synchronous and 2 asynchronous) you would be changing the database structure. Not something one would want on a database that could become the principal database for an application if there was a failure of some sort.