As a proactive DBA its one of responsibility to keep an eye on database’s growth and other file system changes for the databases hosted on SQL instance. However being busy on daily DBA tasks, its not always possible to prepare scripts or manually extract data from system for documentations & trend reporting purposes. I faced [...]
Posts Tagged ‘space’
SQL Server Query for Capacity Planning – SQL 2005 & 2008
Posted: 26th December 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: capacity planning, database, database details, database information, database planning, database size, db structure, growth, space, sql build, trend
8
Setup a low disk space alert for SQL Server drives
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: disk alert, disk space, low disk space, space, sp_OACreate, sp_OADestroy, sql drives
This is the pretty easy and clean script that you may use to check periodically your database server drive space. You can create a job to run on hourly basis to execute this code, along with a database mail code to send you alert if any of drive has less than 15% or 20% threshold [...]
Script to find used and free space in Database files
Posted: 2nd August 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: database, db size, dbcc, dbcc showfilestats, dbcc sqlperf, disk, logspace, shrink, shrinkfile, space, sql server
In an Enterprise world, you may be responsible to monitor 1000+ databases hosted on hundreds of SQL Server instances. On a lazy afternoon, suddenly low disk space alarm hit your inbox. What will you do, storage can not be added or expended on the fly. Here is the tested script to find used and free [...]
