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

Content with tag Table Size Rss

   Items 1 to 7 of 7   
 

SQL Monitor Custom Metric: Table size (MB)

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.  Read more...
By Press Release 2014/04/15 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,387 reads

Calculate Table Size and row count

This script calculates table row count and size(MB), as well as the used space and free space.  Read more...
Rating: |  Discuss |   Briefcase | 1,656 reads

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.  Read more...
By Dan Moran-347932 2012/10/09 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 2,953 reads

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.  Read more...
By Dan Moran-347932 2012/10/09 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 2,953 reads

Monitoring Table Size Growth in SQL Server

This article demonstrates how to monitor table size growth in SQL Server.  Read more...
By Additional Articles 2010/12/21 | Source: SQL Server Performance | Category: administration
Rating:  Rate this |   Briefcase | 4,092 reads

Easily calculate the size of your tables

This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)  Read more...
By Sylvia Moestl Vasilik 2009/05/04 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 1,576 reads

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.  Read more...
By Dan Moran-347932 2012/10/09 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 2,953 reads
   Items 1 to 7 of 7   
 
Tags
administration (1)    
custom metrics (1)    
estimating size (1)    
indexing (1)    
row count (1)    
service broker (1)    
sql monitor (1)