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

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » Administering » Is it possible to keep my database in RAM????...

Add to briefcase

20 posts, Page 1 of 2

1 2 »»

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

Expand / Collapse

Author

Message

Posted Monday, January 18, 2010 4:58 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:54 AM
Points: 493, Visits: 653

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

Regards,
Saravanan

Post #849086

Dave Ballantyne

Posted Monday, January 18, 2010 5:41 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

Yes , have a database thats total size less than available ram on the machine.

Can you clarify your question further ?

Clear Sky SQL
My Blog
Kent user group

Post #849102

Posted Monday, January 18, 2010 7:10 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 6:41 PM
Points: 2,554, Visits: 7,213

Like pin a database ??

Post #849144

Posted Monday, January 18, 2010 7:17 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 5,618, Visits: 10,990

Saravanan T (1/18/2010)

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

Having performance issues, Saravan? Can you go into some more detail please?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps

Post #849149

muthukkumaran Kaliyamoorthy

Posted Monday, January 18, 2010 7:46 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:22 AM
Points: 1,123, Visits: 4,423

Saravanan T (1/18/2010)

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

I agree with Chris Morris.You need to give more info.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum

Post #849167

Posted Tuesday, January 19, 2010 12:21 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:54 AM
Points: 493, Visits: 653

I have a RAM of 32 GB. We are maintaining around 80 databases. But the priority is for only 3 databases. I want all the pages in RAM for those 3 databases instead of all the 80 databases.
The database size is just 3 GB. Hope u got my question??? I feel its possible to keep all the pages of a particular database in a RAM!!

Regards,
Saravanan

Post #849534

Posted Tuesday, January 19, 2010 1:55 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 37,741, Visits: 30,020

If those databases are used frequently then the data pages that are often used will be in cache.

There's no way to prioritise memory usage between databases on the same instance. Only way to do that is to split the databases over two instances and configure the memory so that the one that has the priority databases has more memory.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #849560

Posted Wednesday, January 20, 2010 5:42 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 1,048, Visits: 2,217

Couldn't one just 'pin' the tables in the specific database and that would hold them in memory? I have never done this but I have heard of it.

Post #850390

Posted Wednesday, January 20, 2010 5:49 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 37,741, Visits: 30,020

Markus (1/20/2010)

Couldn't one just 'pin' the tables in the specific database and that would hold them in memory? I have never done this but I have heard of it.

No. DBCC PinTable is a No-operation in SQL 2005/2008. The command's there, it does nothing.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #850396

Posted Wednesday, January 20, 2010 6:21 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 1,048, Visits: 2,217

OK, thanks. I did not know that it was depreciated in 2005/08.

Post #850420

« Prev Topic | Next Topic »

Add to briefcase

20 posts, Page 1 of 2

1 2 »»

Permissions

Expand / Collapse