|
|
Posted by Ed Murphy on 01/12/08 22:44
A couple users at one client are complaining of early morning
slowness in their OLTP system. The first thing that came to
mind is that the nightly backup might be using close to 100% of
the memory cache. (IIRC, they have 16 GB of RAM, 12 of which
is reserved for MSSQL, while the DB is roughly 30 GB.)
Is there a way to limit how much memory cache the backup uses? (It
only takes about 15 minutes now, so we can afford to slow it down
in order to speed user operations up.)
Are there other worthwhile tricks in this area? (I suppose they
could set up replication and then only back up the replicated DB,
but I'm sure that would be overkill. They do some moderately heavy
reporting, but not nearly /that/ heavy.)
Navigation:
[Reply to this message]
|