SalesBuy

1-855-856-7678
Technical SupportSupport
Sign in

Free Trial *Internet Service Required

Windows Azure

SQL Database

Transact-SQL Reference

System Views

sys.bandwidth_usage

sys.database_connection_stats

sys.database_usage

sys.databases

sys.dm_database_copies

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

sys.dm_db_index_usage_stats

sys.dm_db_missing_index_columns

sys.dm_db_missing_index_details

sys.dm_db_missing_index_groups

sys.dm_db_missing_index_group_stats

sys.dm_db_objects_impacted_on_version_change

sys.dm_db_partition_stats

sys.dm_db_wait_stats

sys.dm_exec_cached_plans

sys.dm_exec_connections

sys.dm_exec_describe_first_result_set

sys.dm_exec_describe_first_result_set_for_object

sys.dm_exec_procedure_stats

sys.dm_exec_query_memory_grants

sys.dm_exec_query_plan

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_exec_sessions

sys.dm_exec_sql_text

sys.dm_exec_text_query_plan

sys.dm_exec_trigger_stats

sys.dm_operation_status

sys.dm_tran_active_transactions

sys.dm_tran_database_transactions

sys.dm_tran_locks

sys.dm_tran_session_transactions

sys.dm_federation_operations

sys.dm_federation_operation_members

sys.dm_federation_operation_errors

sys.dm_federation_operation_error_members

sys.event_log

sys.federations

sys.federation_distributions

sys.federation_members

sys.federation_member_distributions

sys.federation_history

sys.federation_distribution_history

sys.federation_member_history

sys.federation_member_distribution_history

sys.federated_table_columns

sys.firewall_rules

sys.database_firewall_rules

sys.resource_usage

sys.resource_stats

Minimize

1 out of 1 rated this helpful - Rate this topic

sys.database_usage (Windows Azure SQL Database)

Lists the number, type, and duration of databases on the Microsoft SQL Database server. The sys.database_usage view is specific to Windows Azure SQL Database and is not supported in on-premise SQL Server.

The sys.database_usage view contains the following fields:

Column Name	Description
time	The date when the usage events occurred.
sku	The type of database, either Business for the Business Edition or Web for the Web Edition.
quantity	The maximum number of databases of an SKU type that existed during that day.

Read-only access to this view is available to all users with permissions to connect to the master database.

The sys.database_usage view returns one row for each day of your subscription.

Concepts

Accounts and Billing in Windows Azure SQL Database
System Views (Windows Azure SQL Database)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.

facebook page visit twitter rss feed newsletter