February 12, 2008 at 10:18 am
Hi,
There's a developer in my team that wants to access the Performance Dashboard reports, but I'm not sure what permissions I need to give him, and I certainly don't want to raise him to sysadmin (which is what will probably happen if I don't find another way to do this soon)
Does anyone know? I can't see anything on the web that helps.
btw, for those who don't know about them, you can get them here
and here's a quick explanation
http://blogs.msdn.com/psssql/archive/2007/03/30/sql-server-2005-performance-dashboard-reports.aspx
February 12, 2008 at 10:31 am
would you look at that, I post and within minutes have the answer! 🙂
Basically, you have to grant permissions on ALTER TRACE and VIEW SERVER STATE. These can be accessed through the advanced properties on the instance - or you can use good old GRANT VIEW SERVER STATE TO YourLogin.
Thanks for taking the time to give this a look, if you did.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply