Data compression of SQL Monitor database
dewet
Posts: 7
Our RedGateMonitor database is pretty big (~200GB). We are considering using data compression on certain tables. Is there any general recommendation what tables could potentially be good candidates for enabling row or page compression on it?
Comments
This is not something I have any experience with, but you may want to get a listing of the table usage from SQL Server. Here is one description of a query you can use to do that.
http://www.mssqltips.com/sqlservertip/1 ... -database/
Usually anything with "UnstableSamples" in the table name is going to be a big one.
Hopefully this helps.