SQL Server Performance

View server state permissions

Discussion in 'SQL Server 2005 General DBA Questions' started by viksar, Nov 7, 2007.

  1. viksar New Member

    Whats actually the difference between "View server state" and sysadmin permissions. I know what sysadmin oermissions are, however since View server state permission are equivalent , so whats the diffference??
    • Please let me know, if there are any performance impact if user are granted "view server state" permissions and they keep querieng database.
    • Is is OK to give this permission to developers?? are there any security issues??
    • Does View server state permission only relates to viewwing and not updating any changes???
  2. techbabu303 New Member

  3. satya Moderator

    I recommend to go through the updated books online for VIEW ANY DATABASE permission topic, that explains the reasons.

Share This Page