SQL Server Disk Space || How to maintain disk Space in SQL Server || Disk Space Threshold | Capacity

SQL Server Disk Space || How to maintain disk Space in SQL Server || Disk Space Threshold | Capacity
QUERY:-
sp_configure 'show advanced options', 1
GO

Reconfigure with override
GO

sp_configure 'xp_cmdshell', 1
GO

Reconfigure with override
GO

-----------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------
--------------------------------------------- DF TYPE SIZE SUM --------------------------------------------------
-----------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------

declare @svrName varchar(255)
declare @sql varchar(400)
--by default it will take the current server name, we can the set the server name as well

Print @sql
--creating a temporary table
CREATE TABLE #output
(line varchar(255))
--inserting disk name, total space and free space value in to temporary table
insert #output
EXEC xp_cmdshell @sql

--script to retrieve the values in GB from PS Script output
,round(cast(rtrim(ltrim(SUBSTRING(line,CHARINDEX('|',line)+1,
(CHARINDEX('%',line) -1)-CHARINDEX('|',line)) )) as Float)/1024,0) as 'capacityGB'
,round(cast(rtrim(ltrim(SUBSTRING(line,CHARINDEX('%',line)+1,
(CHARINDEX('*',line) -1)-CHARINDEX('%',line)) )) as Float) /1024 ,0)as 'freespaceGB',
round(100 * (round(cast(rtrim(ltrim(SUBSTRING(line,CHARINDEX('%',line)+1,
(CHARINDEX('*',line) -1)-CHARINDEX('%',line)) )) as Float) /1024 ,0))/
(round(cast(rtrim(ltrim(SUBSTRING(line,CHARINDEX('|',line)+1,
(CHARINDEX('%',line) -1)-CHARINDEX('|',line)) )) as Float)/1024,0)),0) as percentfree

from #output
--select * from #output
where line like '[A-Z][:]%'
order by drivename
--script to drop the temporary table
drop table #output
GO

sp_configure 'xp_cmdshell', 0
GO

Reconfigure with override
GO

sp_configure 'show advanced options', 0
GO

Reconfigure with override
GO

**********************************************************
Hi Mate,
Welcome to my channel Tech & Art.

**STAY HEALTHY AND KEEP LEARNING***
***ALWAYS HAPPY AND CONNECTED ***

N/B:-- Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion.

In this session we are going to discuss about SQL Server Disk Space || How to maintain disk Space in SQL Server || Disk Space Threshold | Capacity
Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏
***********************************************************

SQL ARCHITECTURE:-

SQL SELECT STATEMENT:-

SQL DML STATEMENTS PROCESSING:-

SQL AAG

Linked server

SQL MIRRORING

SQL REPLICATION

SQL LOGSHIPING

ORACLE INSTANCE AND DATABASE:-

ORACLE INSTANCE STARTUP SEQUENCE

ORACLE INSTANCE SHUTDOWN SEQUENCE:-

SQL SERVER BACKUP/RESTORE:-

SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED,

#sqlserver #sqlserverdba #techandart