Sorry if this is a dumb question...
Our application is installed on several customers, some of which have performance problems.
Is it possible to "record" the SQL Server workload on the customer, probably with SQL Server Profiler?!, get a database backup from the customer, restore the database backup on our servers and run that workload?
I need to analyse performance issues and apply tuning operations on the database and the best way to do so is to do it on premises.
Only after measuring the tuning operations can I apply them on the customer's database.
If you need to work better, try working less...