Steve Jones - SSC Editor - Thursday, February 22, 2018 9:51 AM

For Perf counters, there are ways to let non-admins get them: https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc771692(v=ws.10)
For attach/detach, just SQL permissions are needed, though the admin might need access to the folders to move files in/out.

For install, I think you'd need admin permissions. At least temporarily.  You have to set permissions and create service accounts. This won't be something you can easily do by proxy. Of course, you could move to Chef/Puppet/DevOps style installs, which might alleviate some issues.

Stop/start services,  you can use sc (https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc742037(v=ws.10)), and assign some rights, but this wouldn't be as easy as using SSMS.