We've just 'upgraded' one of our 3rd party apps which required a new version of the vendors database (Using SQL 2008 R2 SP1 Standard Edition running on Windows Server 2008 R2 Enterprise edition).
Upon familiarising myself with the new database (no they didn't bring me in on the initial testing and implementation!) I discovered that the collation is set to 'Latin1_General_100_CI_AI' which is different to the instances TempDB collation of 'SQL_Latin1_General_CP1_CI_AS'.
The app is running into performance problems (speed issues mostly when logging in and with certain transactions), my question is two-fold:
1. Could this be related to the difference in collations if the app uses the TempDB?
2. Should I recommend that the collation on the app db be amended by the vendor to reflect that of TempDB?
Thanks for any suggestions.