Is it possible to keep my database in RAM????

Question

Is it possible to keep my database in RAM????

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 1

Rebuild your indexes on a somewhat regular basis, defrag the hard drive if possible, look for tuning indexes and keep stats up-to-date. Those things will help out performance as well by themselves.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

In addition to query tuning, and Index maintenance - I suggest proper indexing.

Another expensive option is to replace your disks with solid state disks or flash drives - very very fast.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

gaojia2004 SSC-Addicted Points: 409 More actions · Answer 3

Maybe you can try to use a virtual machine to run the three database, and use another vm to run the others database, and allot appropriate memory to each VM

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

That's a lot more complex than just adding a second instance and moving the 3 DBs there, as has been earlier recommended.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1003869 More actions · Answer 5

Heh... with so many folks talking about separate servers, now I know the real reason why MS deprecated such a useful tool as being able to pin certain tables. $$$

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)