Skip to content

SQL Server Faq

  • Home
  • About
  • Archives
  • Contact
SQL Server Faq

monitor

SQL Maintenance

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

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

© 2023 SQL Server Faq

  • Home
  • About
  • Archives
  • Contact