2 comments to Performance tuning in a secure shared SQL Server environment

  • Edward Joell

    Regarding your proposed solutions:
    Number 1. Ain’t going to happen.
    Number 2. Ain’t going to happen.
    Number 4. Working on a SQL Server 2005 instance so there are no Extended Events.

    We are already exploring the idea of using the Perm Mon alternatives. It would require that we be added to the Performance Monitor Users group on the server, but it may be easier to get that rather than View Server State permissions, provided we can justify why we need to see stats on the entire instance rather than just our databases.

    The query you demonstrated requires View Server State permissions to run so we would not be able to use it.