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


 

Content with tags Administration, Storage, sys.allocation_units, Maintenance and Management Rss

   Items 1 to 4 of 4   
 

The Automated DBA: Batch Database File Grower - SQL 2005 Version

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,086 reads

The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...
By Jesse Roberge 2009/06/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 965 reads

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.  Read more...
By Jesse Roberge 2009/06/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,842 reads

The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.  Read more...
By Jesse Roberge 2009/06/15 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,138 reads
   Items 1 to 4 of 4   
 
Tags
automated dba (4)    
maintenance (4)    
sql server 2005 (4)    
t-sql (4)    
utility (4)    
auto-growth (2)    
buffer cache (2)    
data file management (2)    
routine database growth (2)    
routine growth (2)    
space usage (2)    
sys.dm_db_partition_stats (2)    
sys.dm_os_buffer_descriptors (2)    
sys.partitions (2)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.