Monitor space used for disks, DBs, tables and filegroups

I pieced this script together from solutions I found on this and from Brian Knight's excellent book. It creates 3 tables: - tblDriveLogs. Collects free drivespace info for each drive for each time the script is run. - tblIndexLogs. Collects info on spaceused for each index and table. Please note that when only af single […]

1 (1)

2003-11-26

888 reads

Blogs

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

Replication reinitialize error

By kcsujith

I am getting an error 'Cannot reinitialize subscriptions of non-immediate_sync publications; Microsoft SQL server...

Migrate or upgrade SSIS to another sever

By sqlfriend

What is the best way to move all SSIS  projects  in SSIS catalog to...

target database participating in availability group error

By noobdba

Sharepoint connects to the database using the cluster through an alias defined in cliconfig....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers