Skip to content

SQL Server Faq

  • Home
  • About
  • Archives
  • Contact
  • Privacy Policy
  • Terms & Conditions
  • Disclaimer
SQL Server Faq

script

SQL Maintenance

Script to monitor Free Space of the data file and send alert

February 16, 2012May 20, 2012

Recently I had to create a script which will monitor free space of all the datafiles and send alert if the free space within a datafile falls below 10% of the Total file space. The following script should help to achieve the objective so sharing with the larger audience SET NOCOUNT ON DECLARE @Tbl Table…

Read More Script to monitor Free Space of the data file and send alertContinue

Categories

  • AlwaysON
  • Azure
  • Azure DocumentDB
  • Books
  • cluster
  • Columnstore Index
  • CONNECTIVITY
  • Data Encryption
  • High Availability
  • MDX
  • Microsoft Azure
  • Miscellaneous
  • Performance
  • Power BI
  • Powerpivot
  • Replication
  • SCCM Database
  • SECURITY
  • SQL 2012
  • SQL Maintenance
  • Sql Server 2008 (KATMAI)
  • SQL Server 2016
  • SQL Server 2017
  • SQL SERVER SETUP
  • SQLServerGeeks
  • SSAS
  • SSAS Tabular Model
  • SSIS
  • SSRS
  • TSQL
  • Uncategorized
  • UPGRADATION

© 2023 SQL Server Faq

  • Home
  • About
  • Archives
  • Contact
  • Privacy Policy
  • Terms & Conditions
  • Disclaimer