Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag size Rss

   Items 1 to 12 of 12   
 

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,687 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,651 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,651 reads

Disk Capacities

Provides information on the total and used space for all drives on an instance.  Read more...
By Nicholas Williams 2013/12/06 | Source: SQLServerCentral.com | Category: disk
Rating: |  Discuss |   Briefcase | 4,488 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,687 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 5,748 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,687 reads

sp_spaceused2

The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...
By Jason S Wong 2012/04/02 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,375 reads

Disk Capacities

Provides information on the total and used space for all drives on an instance.  Read more...
By Nicholas Williams 2013/12/06 | Source: SQLServerCentral.com | Category: disk
Rating: |  Discuss |   Briefcase | 4,488 reads

Table Data Sizes

Script to display how the data is broken up between the tables.  Read more...
By Nick Greene 2010/12/08 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,922 reads

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.   Read more...
By sql frenzy 2009/07/02 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,606 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 5,748 reads
   Items 1 to 12 of 12   
 
Tags
space (2)    
administration (1)    
breakdown (1)    
calculate (1)    
capacity (1)    
clustering (1)    
data storage (1)    
database (1)    
databases (1)    
details (1)    
disk (1)    
drive (1)    
duplicates (1)    
estimate (1)    
free space (1)    
growth (1)    
heap (1)    
index (1)    
monitoring (1)    
non-clustered (1)    
optimize (1)    
percentage (1)    
powershell (1)    
scans (1)    
script (1)    
seeks (1)    
stats (1)    
table (1)    
trending (1)    
troubleshoot (1)    
unused (1)    
usage (1)    
used (1)    
volume (1)    
xp_cmdshell (1)