Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Is it possible to keep my database in RAM???? Expand / Collapse
Author
Message
Posted Monday, January 18, 2010 4:58 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:56 PM
Points: 500, Visits: 728
Is it possible to keep my database in RAM????

Regards,
Saravanan
Post #849086
Posted Monday, January 18, 2010 5:41 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:57 AM
Points: 1,949, Visits: 8,304
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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, July 26, 2014 8:10 PM
Points: 2,826, Visits: 8,463
Like pin a database ??


Post #849144
Posted Monday, January 18, 2010 7:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:33 AM
Points: 7,130, Visits: 13,514
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
Posted Monday, January 18, 2010 7:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:10 AM
Points: 1,155, Visits: 4,624
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:56 PM
Points: 500, Visits: 728
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-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:11 PM
Points: 42,470, Visits: 35,541
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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:42 AM
Points: 1,242, Visits: 2,743
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-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:11 PM
Points: 42,470, Visits: 35,541
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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:42 AM
Points: 1,242, Visits: 2,743
OK, thanks. I did not know that it was depreciated in 2005/08.


Post #850420
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse