kevinsql7 (2/27/2009)

---

Are you saying that the "move pages to the front" option would fragment your database and also shrink your log? Or the "truncateonly" option would fragment your database and...

We are thinking of using SRDF as a DR process for our Non-clustered consolidated SQL servers. My question is how you apply SQL patches\upgrades when the local drives (ie C...

the disaster recovery forum is obviously hardly visited, so I am bumping this thread..................

any takers?

the command you have written would be correct except the % sign is not required.

move pages to the front is the default action, you have to tell it NOT to...

did you resolve this?

If not I would look for jobs backing up or truncating your logs outside of your log shipping process. Such actions would be reported in the errorlog...

I've seen the figure of 1000 pages quoted because even then the table would only be 8MB big, which is pretty small.

I suggest you find some small tables and...

see edit. Your just jealous.

No, that would be a GigaMember

you are theoretically correct but its my thread and I get to name it. 🙂

465789psw (2/24/2009)

---

wish I could George, that would most likely solve my problem.....but you can not lock pages in memory on standard edition......only enterprise....microsoft is looking at this issues know....who knows...

its all yours then Gus.

Ninja, you might want to edit that last post..................

I knew someone would jump on this.............but too late, shirt offered and accepted 🙂

It was the 1,024 that jumped out at me:

how many bytes in a KB - 1,024

how many...

I...

Grant here confirming he is a man of true taste...

have you given the account that runs SQL the 'lock pages in memory' right. This will prevent SQL working set bring trimmed.

And AWE is usable with standard edition in SQL...

If this is 200 there is column rowmodctr in sysindexes which tells you the no. of updates , inserts, deletes since last stats update.

Of course that leaves selects!

Otherwise a server...