上去了server查所有表空间,如何在SQL Server 2008中查找表空间的总使用量？

In SQL-server 2008, How would I find (through an SQL query), the percentage of tablespace usage for a particular instance(or all instances) of a SQL Server(2008 R2)?

Also, what is the best way (query) to get the list of all the Named Instances of a SQL Server?

解决方案

is this what you need:

EXEC sp_spaceused null, false

result:

database_name database_size unallocated space

--------------- ------------------ ------------------

DATABASE_NAME 220.25 MB 69.92 MB

reserved data index_size unused

------------------ ------------------ ------------------ ------------------

110672 KB 80368 KB 26944 KB 3360 KB