sql中查询 tempdb的空闲容量
SELECT
SUM(unallocated_extent_page_count) AS [free pages]
, (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]
FROM
sys.dm_db_file_space_usage;
查询sqlserver的tempdb的数据文件和日志文件的信息
SELECT
*
FROM
sys.database_files
查询所有数据库的日志信息
DBCC SQLPERF(LOGSPACE)
修改某个数据库的size大小
ALTER
DATABASE tempdb
MODIFY
FILE
(NAME = tempdev,SIZE = ???MB)