The bufferpool tag has no wiki summary.
3
votes
1answer
73 views
Buffer usage for index with no reads
Using SQL Server 2008 R2, the main transactional table in a vendor database is massive compared to all others and has about 14 indexes. Some of these indexes don't get used in our environment, but we ...
2
votes
1answer
134 views
How to create Buffer Pool in Database dedicated only for ONE BIG table?
I have table TICKET with 400K records in database (DB2).
I wish to create one huge buffer pool which will be dedicated only to this one big table for faster response. What are the steps to do it?
...
2
votes
0answers
104 views
tempdb objects creator wanted, bufferpool issue caused by tempdb objects
I have a number of tables in tempdb named like
#A0030B77
#A01D908C
#A06D1FCB
#A0F72FB0
#A1614404
#A1EB53E9
#A205D8FE
#A255683D
How (if) can I get spid of the process which created them?
These ...
1
vote
1answer
91 views
Should indexes automatically be placed into their own bufferpool?
We work with DB2 LUW (specifically we are currently on 9.7 FP4) running on AIX.
Per best practices from IBM, they recommend that when you build a table, you place the data, the indexes, and LOBs/LONG ...
