MS SQL Server Alert: How to Configure Data File Full Alerts
Vložit
- čas přidán 6. 09. 2024
- Join this channel to get access to perks:
/ @mssqldbatechsupport
Join the Telegram Group for the scripts and assistance:
t.me/+sDwstoLc...
You Can Also Download the scripts from below folder
drive.google.c...
We strongly believe there is always chance of betterment, so suggestions are most welcome.
Happy learning, and All the Best in your professional journey!
The journey of improvement is ongoing and never be an end.
Connect With me,
LinkedIn Page --- / mssqldbatechteam
Facebook Page --- www.facebook.c...
Twitter --- / mssqldbasupport
Instagram --- / mssqldbatechsupport
Email --- mssqldbatechteam@gmail.com
Telegram --- t.me/mssqldbaw...
#azuresql #azure #sqldba #sqlserverdba #sql #sqlserver #sqlserverdeveloper #performance #performancetuning #performanceoptimization #mssql #mssqlserver #mssqlserverdba
Thank you!
MS SQL DBA Tech Support
mssqldbatechteam@gmail.com
create database test
GO
USE [master]
GO
ALTER DATABASE [test] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [test] MODIFY FILE ( NAME = N'test', FILEGROWTH = 0)
GO
BACKUP DATABASE [test] TO DISK = N'C:\test.bak'
WITH NOFORMAT, NOINIT, NAME = N'test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
use test
GO
create table test(id int,name varchar(100),location varchar(100))
insert into test values(1,'harsha','india')
GO 50000
SELECT COUNT(*) FROM test
-- Query to get detailed information about database files
SELECT
db.name AS [Database Name],
mf.name AS [File Name],
mf.physical_name AS [Physical File Name],
mf.type_desc AS [File Type],
mf.state_desc AS [File State],
CAST(mf.size AS BIGINT) * 8 / 1024 AS [Size (MB)],
CASE
WHEN mf.is_percent_growth = 1 THEN CAST(mf.growth AS NVARCHAR(20)) + ' %'
ELSE CAST(mf.growth * 8 / 1024 AS NVARCHAR(20)) + ' MB'
END AS [Autogrowth],
mf.max_size AS [Max Size]
FROM
sys.master_files mf
JOIN
sys.databases db ON mf.database_id = db.database_id
WHERE db.name = 'TEST'
ORDER BY
db.name, mf.type_desc;
DECLARE
@dbname VARCHAR(100) = NULL,
@SpaceUsed FLOAT = NULL
DECLARE @LOGSPACE TABLE(
dbName VARCHAR(100),
LogSizeMB FLOAT,
[LogSpaceUsed%] FLOAT,
[Status] INT
)
INSERT @LOGSPACE EXEC ('DBCC SQLPERF(''logspace'')')
SELECT dbName, LogSizeMB, [LogSpaceUsed%], [Status] FROM @LOGSPACE where [dbName] = 'TEST'
select * from sys.sysmessages where msglangid = 1033 and severity = 17
Thanks for sharing such a nice way to make our job easier,
I Agree, some of the small companies can't afford money for the monitoring, You are helping them , Such a great idea. Keep rocking.
So true!
Thanks for sharing your knowledge🙏
So nice of you
Thanks for sharing
Thanks for watching!
Hi sir will i get cluster configuration docs..
I have done home lab videos,in that i have shown you how to configure
cluster configuration as well.