Tuning Advisor on CS2007 database-Collection of common programming errors
.png)
msdn HelloMy host wants to run the SQL Server tuning advisor tool (TA) on a commerce server database. As a result, the TA will generate new indexes on tables, or modify existing indexes on the CS databaseAny recommandations ? I don’t like the idea od modifying the CS database, as some tables columns are created, modified, etc by CS on runtime.Olivier
msdn1 Performance tuning is routine activity in post production environment and I personally feel nothing harm in adding new/ modifying indexes but make sure you don’t manipulate data or data structure. Hope this helps. Regards,-Ravi Kanth Koppala