The table in question has 30million rows and is almost 500GB in size (compressed). It has constant UPDATEs and DELETEs. Having performed other due dilligence it's worth removing the compression...
Glenn's code worked well in determining the uncompressed size. We have plenty of disk space so I'm going to remove the compression and see if it does improve CPU usage....