The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

If I have a scale-out configuration with a ready-only copy is it possible to run this instance as an in-memory db to improve performance for queries run against that read-only server?

asked 17 Jan '11, 16:34

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%


Currently you cannot use an in-memory mode on a server that is participating in a High Availability (aka HA or Mirroring) or a Scale Out configuration. The reason is that for both of these configurations the database must be actively using (writing / reading / transfering-to-remote server) a transaction log and the in-memory modes turn off these operations by design.

See the -im switch in the 12.0.x docs for more information on what the in-memory modes are and what they do.

We have discussed within SA engineering the possibility of using an in-memory mode in an HA or Scale Out configuration and will consider supporting this in some future release.

permanent link

answered 18 Jan '11, 02:55

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×238
×3
×3

question asked: 17 Jan '11, 16:34

question was seen: 642 times

last updated: 18 Jan '11, 02:55