Allowing non-sysadmin users to see SQL Server execution plans
Community Wiki answer generated from question comments



Yes this is possible. See:


Syntax for Granting, Denying, and Revoking the SHOWPLAN Permission1 2
Showplan Security2
SHOWPLAN Permission and Transact-SQL Batches2


1 Contributed by Mark Sinkinson
2 Contributed by Aaron Bertrand♦