Mysql show databases with size9/16/2023 ![]() , RowNum = ROW_NUMBER() OVER (PARTITION BY s.database_name, s. , log_size = MAX(CASE WHEN = 'L' THEN backup_size END)ĬAST(CASE WHEN s.backup_size = s.compressed_backup_size , log_last_date = MAX(CASE WHEN = 'L' THEN backup_finish_date END) , full_size = MAX(CASE WHEN = 'D' THEN backup_size END) , full_last_date = MAX(CASE WHEN = 'D' THEN backup_finish_date END) LEFT JOIN #space s ON d.database_id = s.database_id JOIN sys.databases d ON d.database_id = t.database_id , data_size = CAST(SUM(CASE WHEN = 0 THEN size END) * 8. , log_size = CAST(SUM(CASE WHEN = 1 THEN size END) * 8. SELECT s., space_used = SUM(FILEPROPERTY(s.name, ''SpaceUsed'') * 8. INSERT INTO #space (database_id, data_used_size, log_used_size) Show information about size, free space, last database backups IF OBJECT_ID('tempdb.dbo.#space') IS NOT NULL ![]() Name log_size_mb row_size_mb total_size_mbĭatabase_name database_size unallocated space WHERE database_id = DB_ID() - for current db , row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |