none
What do these views do? RRS feed

Answers

  • Jamie,

    You should be able to select from these views when connected to master (use "sys."):

    select * from sys.sql_logins
    select * from sys.sds_database_metrics
    select * from sys.sds_server_metrics

    sql_logins is the same as sys.sql_logins in on-premise sql.
    sds_database_matrics and sds_server_metrics will provide metrics information, but are currently empty.  By the way, the last two views will be renamed for v1.

    Stan
    Program Manager, SQL Azure
    • Marked as answer by Jamie Thomson Monday, August 31, 2009 10:06 PM
    Monday, August 31, 2009 9:47 PM

All replies

  • Jamie,

    You should be able to select from these views when connected to master (use "sys."):

    select * from sys.sql_logins
    select * from sys.sds_database_metrics
    select * from sys.sds_server_metrics

    sql_logins is the same as sys.sql_logins in on-premise sql.
    sds_database_matrics and sds_server_metrics will provide metrics information, but are currently empty.  By the way, the last two views will be renamed for v1.

    Stan
    Program Manager, SQL Azure
    • Marked as answer by Jamie Thomson Monday, August 31, 2009 10:06 PM
    Monday, August 31, 2009 9:47 PM
  • Jamie,

    You should be able to select from these views when connected to master (use "sys."):

    select * from sys.sql_logins
    select * from sys.sds_database_metrics
    select * from sys.sds_server_metrics

    sql_logins is the same as sys.sql_logins in on-premise sql.
    sds_database_matrics and sds_server_metrics will provide metrics information, but are currently empty.  By the way, the last two views will be renamed for v1.

    Stan
    Program Manager, SQL Azure

    Ah gotcha, thanks Stan.
    http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet
    Monday, August 31, 2009 10:06 PM
  • um...and they are renamed to....?
    Saturday, February 6, 2010 1:03 AM
  • um...and they are renamed to....?
    To:
    sys.bandwidth_usage
    sys.database_usage
    sys.firewall_rules

    I don't think any of these needs an explanation ;)
    But if you need further information on them, go and check out what they mean on MSDN docs:
    http://msdn.microsoft.com/en-us/library/ee621788.aspx
    Sunday, February 7, 2010 2:55 PM