[已解决]如何通过MS SQL Server的架构获得总存储空间？ [英] [Solved] How do I get total storage space using by an MS SQL Server's schema?

问题描述

Hello All，



我正在尝试查找MS Sql Server的数据库实例使用了多少存储空间以及每天增加多少存储空间。



以下是用于获取Oracle数据库实例的查询：

Hello All,

I am trying to find how much storage space is used by my MS Sql Server's database instance and how much increasing day-by-day.

Below is the query used to get for Oracle DB instance:

SELECT SUM(bytes)/1024/1024/1024 SCHEMA_SIZE_GB FROM USER_SEGMENTS; 

如何为MS Sql Server找到相同的内容。任何有关这方面的帮助将不胜感激。谢谢。

How can I find the same for MS Sql Server. Any help on this would be appreciated. Thanks.

推荐答案

这要求通过查询来完成吗？

It is a requirement that this be done via a query?

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'AdventureWorks'
GO

通过管理工作室很容易找到这些信息：

https://www.simple-talk.com/sql/database-行政/ SQL服务器数据库增长和-A utogrowth-settings / [ ^ ]



希望有所帮助^ _ ^

It is very easy to find this info via the management studio:
https://www.simple-talk.com/sql/database-administration/sql-server-database-growth-and-autogrowth-settings/[^]

Hope that helps ^_^

这篇关于[已解决]如何通过MS SQL Server的架构获得总存储空间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！