anyone with any ideas on this?

we just implemented AWE here and used /3GB /PAE  We have 8gb of ram quad processors.  Before adding this we were using around 2.8 and it jumped up to 7.6gb ...

oh just for the record the logical fragmentation for ttbl_PROPOSAL is sitting at: 99.810249328613281

select db_name()

go

DBCC SHOWCONTIG ('tbl_Proposal')

  WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS

go

SELECT * FROM sysindexes where name = 'ttbl_PROPOSAL'

go

DBCC INDEXDEFRAG (broadway,tbl_proposal,ttbl_PROPOSAL)

go

Results

broadway

go

ObjectName   ObjectId    IndexName  IndexId Level Pages Rows

tbl_PROPOSAL 813245952 pk_PROPOSAL 1 0 902 NULL 

tbl_PROPOSAL 813245952 idxProposalADV_ID 2 0 61 NULL 

tbl_PROPOSAL 813245952 idxProposalCOMP_ID 3 0 77 NULL 

tbl_PROPOSAL 813245952 idxProposalCT_ID 4 0 77 NULL

tbl_PROPOSAL 813245952 idxProposalRATE_ID 6 0 67 NULL 

tbl_PROPOSAL...

actually looking a bit farther the index doesn't show up in the sysindexes table.

Any ideas or suggestions?

I'm having similar problem.  It may not be a phantom but why doesn't it get optimized with the other indexes?