Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Automated Monitoring Database Size Using sp_spaceused Expand / Collapse
Author
Message
Posted Tuesday, May 8, 2012 8:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 11:47 AM
Points: 52, Visits: 199
The line:
MIN(row_count) AS Rows,

Returns incorrect results for partitioned tables.

It shoudl read:
SUM(row_count) as Rows,

to correctly sum the rowcount across all partitions.

As for the exclusion of XML data, does the subquery (LOBDATA) against sys.dm_partition_stats joined to sys.internal_tables not return this metric?

Just curious...



Post #1296495
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse