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-19 : 01:12:26
|
Hi All! We have pinned a table in the memory though there is a bit decrease in the logical reads but the time(response time) it's taking earlier for the same query is still the same -------- Any reasons for that How can we optimize the query and minimize the response time usin the PINTABLEThnakscan u help pls. |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-19 : 01:44:08
|
quote:
Hi All!We have pinned a table in the memory though there is a bit decrease in the logical reads but the time(response time) it's taking earlier for the same query is still the same -------- Any reasons for that How can we optimize the query and minimize the response time usin the PINTABLEThnakscan u help pls.
can you post the query and how big is the table which you have pinned?Expect the UnExpected |
 |
|
|
ereader
Yak Posting Veteran
50 Posts |
Posted - 2002-12-19 : 02:05:58
|
quote:
Hi Harshal!
It's not too big just about 10 MBWe people are using the table which has 1,00,000 rows with 150 columnsthe query can be vary from situation to situationIs it possible to decrease the response time using DBCC PINTABLEThanks |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-19 : 04:39:32
|
| Assuming you have sufficent memory and this table is queried a lot then it is likely its pages would remain in the buffer cache anyway without the need to pin the table. Thus you are unlikely to see much benefit. Have a look at the indexes on the table, could they be improved. You can use Profiler to capture a workload file of common queries that reference the table and feed it through the Index Tuning Wizard and see if it has any suggestions for indexes that will improve your query performance.HTHJasper Smith |
|
|
|
|
|
|
Tables in memory