Hello,
Is there a way to load either INDEX or the whole table into RAM in SQL
Server 2000 Enterprise?
Thanks,
Arsen
by Arsen Vladimirski » Sun, 13 Jan 2002 05:23:47
Is there a way to load either INDEX or the whole table into RAM in SQL
Server 2000 Enterprise?
Thanks,
Arsen
by Paul » Sun, 13 Jan 2002 05:34:15
See DBCC PINTABLE in SQL2k BOL.
Paul
> Hello,
> Is there a way to load either INDEX or the whole table into RAM in SQL
> Server 2000 Enterprise?
> Thanks,
> Arsen
by Arsen Vladimirski » Sun, 13 Jan 2002 05:37:16
I read about it... But it looks like it simply does NOT flash the cache, but
it does not really load the data into RAM. Did you ever use it?
Thanks,
Arsen
> See DBCC PINTABLE in SQL2k BOL.
> Paul
> > Hello,
> > Is there a way to load either INDEX or the whole table into RAM in SQL
> > Server 2000 Enterprise?
> > Thanks,
> > Arsen
by Dinesh T » Sun, 13 Jan 2002 06:01:49
Its isnt practical to load the entire data into RAM.Just as the pages make a
visit to the cache they are just "pinned" in it instead of flushing it out.
Pinning can be beneficial if the table is a small one and also frequently
accessed.
What exactly are you trying to achieve ?
Dinesh.
> I read about it... But it looks like it simply does NOT flash the cache,
but
> it does not really load the data into RAM. Did you ever use it?
> Thanks,
> Arsen
> > Arsen,
> > See DBCC PINTABLE in SQL2k BOL.
> > Paul
> > > Hello,
> > > Is there a way to load either INDEX or the whole table into RAM in SQL
> > > Server 2000 Enterprise?
> > > Thanks,
> > > Arsen
by Paul » Sun, 13 Jan 2002 06:06:34
My (admitedly limited) understanding of 'not flushed from cache'
is that these data pages remain in the SQL Server cache (memory),
and there is therefore no need to read them from disk.
Perhaps one of the gurus can enlighten us?
Paul
> Hi Paul,
> I read about it... But it looks like it simply does NOT flash the cache, but
> it does not really load the data into RAM. Did you ever use it?
> Thanks,
> Arsen
> > Arsen,
> > See DBCC PINTABLE in SQL2k BOL.
> > Paul
> > > Hello,
> > > Is there a way to load either INDEX or the whole table into RAM in SQL
> > > Server 2000 Enterprise?
> > > Thanks,
> > > Arsen
by Umachandar Jayachandra » Sun, 13 Jan 2002 10:21:17
dbcc pintable( 'tbl' )
datalength( t.col3 )
from tbl as t
The dummy query will load the data pages into memory & keep them there
till you unpin the table.
--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )
by Andrew J. Kell » Mon, 14 Jan 2002 05:47:40
--
Andrew J. Kelly, SQL Server MVP
> I read about it... But it looks like it simply does NOT flash the cache,
but
> it does not really load the data into RAM. Did you ever use it?
> Thanks,
> Arsen
> > Arsen,
> > See DBCC PINTABLE in SQL2k BOL.
> > Paul
> > > Hello,
> > > Is there a way to load either INDEX or the whole table into RAM in SQL
> > > Server 2000 Enterprise?
> > > Thanks,
> > > Arsen
1. How do I put INDEXES on RAM based TEMP_DB?
Gang
I posted a question the other day to the news groups about how to put a
SQL index on a different device. I was given the following sequence
and it worked very nicely.
use master
GO
alter database userdb on INDEXDEV = 100
GO
use userdb
GO
sp_addsegment indexes, INDEXDEV
GO
create index table1IDX on table1 (col1) on indexes
GO
However, although the INDEXDEV is on some fast SCSI-3 drives, I want even
more index building speed. So now I want to put the indexes on a device
that lives in RAM. I assumed I could do something like change INDEXDEV to
TEMP_DB (coz I have a 120mb RAM based TEMP_DB) but it didnt work.
Am I crazy or is this not possible? I am looking for blistering speed in
building these indexes (the data that the indexes are derived from is
static and the
indexes will be read only).
Can anyone help?
Bob
6. Importing Access 7 in Delphi 1.0?
8. how to release server memory ?
10. TempDB in RAM
11. Tempdb in RAM
12. Database servers with 1 gb or more ram...
13. WARNING:MS-SQL does NOT support 2 gigs of RAM