SQL Server数据库表空间

SQL Server 一般都是跟磁盘空间可用率挂钩 数据文件也都是自增长 所以不用管；

如下SQL语句可以查询SQL Server数据库当前登录用户数据的表空间，但是没什么意义 因为SQL Server是72M自增长，只能看出当前块的自增长离下次自增长还有多少空间：

SELECT

    DB_NAME(database_id) AS DatabaseName,

    CAST(ROUND(SUM(size) * 8 / 1024.0, 2) AS NUMERIC(36, 2)) AS TotalSizeMB,

    CAST(ROUND(SUM(CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)) * 8 / 1024.0, 2) AS NUMERIC(36, 2)) AS UsedSizeMB,

    CAST(ROUND((SUM(size) - SUM(CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT))) * 8 / 1024.0, 2) AS NUMERIC(36, 2)) AS FreeSizeMB

FROM

    sys.master_files

WHERE

    type_desc = 'ROWS'

GROUP BY

    database_id;

设置快照隔离级别的：

ALTER DATABASE STARBUCKSDB SET READ_COMMITTED_SNAPSHOT ON;

 2.    查看sqlserver的license是否正常激活:

SELECT SERVERPROPERTY('LicenseType') as Licensetype, 
       SERVERPROPERTY('NumLicenses') as LicenseNumber,
       SERVERPROPERTY('productversion') as Productverion, 
       SERVERPROPERTY ('productlevel')as ProductLevel, 
       SERVERPROPERTY ('edition') as SQLEdition,@@VERSION as SQLversion;