Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ereader
Yak Posting Veteran
50 Posts |
 Posted - 2002-12-14 : 09:49:06
|
Hi ALL !!!Hello Jobvolk and merkin (Sql GURU) We have a table with 5,00,000 Rows coming from joining of 8 tables  Is it possible in SQL Server 2000, so that we can store this data in memory and we can perform SELECT operation on the data which is in memory.In aspect of minimizing the I/O Cost and Disk ReadsSo that we can optimize our query and enhance the performance. If you have any stuff, pls. give me the details we're very thankful to you. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-12-14 : 10:08:18
|
| HiYou can't do exactly what you want. But you can use DBCC Pintable (Look it up in books online) to keep the table "pinned" in the cache.However....Unless you really know what you are doing, AND have tested the performance of all possible solutions, I would avoid this technique.In general, SQL Server is smarter than you or I about how to optimise it's queries. To try to force something, you need to really know WHY.Having said that, I think maybe a better solution to your problem may be "Indexed Views" (look that up in books online as well).Hope that helpsDamian |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-14 : 10:10:10
|
| I agree with Merkin, but maybe this Jobvolk guy might have a better idea. Hopefully he'll see this and respond. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-12-14 : 10:13:04
|
And I thought it was "vobrolk"...Actually, jobvolk is kinda funny and appropriate in an inappropriate-but-funny-if-you-know-why kinda way.  Damian |
|
|
|
ereader
Yak Posting Veteran
50 Posts |
Posted - 2002-12-14 : 10:35:52
|
quote:
I am very thankful to you********************************** robvolk and merkin (Sql GURU) **********************************
What the scenario is here is that, we have optimze our query atmost with the proper guidance from u people and from the fabulous stuff u people have on ur site, we have already implemented all the techniques like indexes, indexed view, FTS and bit more in the database structure. What am looking from u people is that can u people can give me some details, stuff or links regarding the details for the memory database b'coz we are going to implent the changes in the couple of days on the production server.And one more think we want to know we are using the profiler for the peak testing where more than 50 user hit the database. So should we have to concern about the size of log files of the database or the profiler(.trc) and what the points we have to consider at that time if we check it for the test runReally thankful to you rob and merkinBye for now have a nice weekend Edited by - ereader on 12/14/2002 10:38:24 |
|
|
|
ereader
Yak Posting Veteran
50 Posts |
Posted - 2002-12-14 : 10:42:59
|
quote:
Hello robvolk
We are really apologize for our typing mistake.We have mis spelt ur name r - jReally sorry for that. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-12-15 : 09:44:25
|
| Having a Profile session open and that too with more then 50 users hitting the DB will definetly affect the performance.AFAIK, there shouldnt be any log problems. if your transaction log is set to appropriate level.-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
|
|
|
|
|
Can we store table in memory