How can we help you today? How can we help you today?

Data compression of SQL Monitor database

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?
dewet
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello,

    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.