Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Настройки БД РАЗМЕР свободное место
- -- РАЗМЕР БД - СВОБОДНОЕ МЕСТО В БД
- -- https://coderoad.ru/866139/Лучший-способ-найти-свободное-место-в-базах-данных-sql-server
- select
- name
- , filename
- , convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB
- , convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)) as SpaceUsedMB
- , convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as FreeSpaceMB
- from dbo.sysfiles a
- -- Настройки БД
- exec sp_helpdb
- go
- --
- declare @DatabaseName nvarchar(128)
- set @DatabaseName = (SELECT DB_NAME() )
- SELECT @DatabaseName as DatabaseName
- -- Status = ONLINE
- SELECT 'Status', DATABASEPROPERTYEX( @DatabaseName, 'Status');
- -- IsAutoShrink = 0
- SELECT 'IsAutoShrink', DATABASEPROPERTYEX( @DatabaseName, 'IsAutoShrink');
- -- IsAutoCreateStatistics = 1
- SELECT 'IsAutoCreateStatistics', DATABASEPROPERTYEX( @DatabaseName , 'IsAutoCreateStatistics');
- -- IsAutoUpdateStatistics = 1
- SELECT 'IsAutoUpdateStatistics', DATABASEPROPERTYEX( @DatabaseName , 'IsAutoUpdateStatistics');
- -- свободное место
- -- exec sp_spaceused -- EXEC sp_spaceused @updateusage = N'TRUE'; -- EXEC sp_spaceused @oneresultset = 1
- EXEC sp_spaceused @oneresultset = 1 , @updateusage = N'TRUE';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement