I saw a tweet today from respected blogger john sansom asking how a SQL DBA should attempt to performance tune SSAS. I've been through a similar scenario - and one of the tools I developed as part of my troubleshooting was my own 'SSAS version' of sp_who. I've written a stored procedure...