Saturday, August 29, 2015

How to check table size from SQL server

We often require to check size of the table to moniter database performance, specially working with files and storing it in database. AX does store files in database which can be setup under Document types in Document Management module.

We can use following sql command to get table size;

sp_spaceused docuValue