You say the sp has the following if statement - What's the rest of the sp like?

John Zacharkan

Please stay away from the computer, -- just kidding, unless it's production.

Sounds like you could use a consultant for a couple of weeks or so. I come highly recommended....

Thanks again, I made the change to 85% that seems to have had a positive effect. Here's the results

- Pages Scanned................................: 1815

- Extents Scanned..............................: 227

- Extent Switches..............................: 226

- Avg....

I've added it to my monitor - it's currently running at .434/s with the 0 fill factor. I'll let it run and revisit it in the morning/lunch during our peak...

If you've enabled AWE. There's a hotfix for SQL Server 2K SP2 that might fix this. SQL server may hold a latch while attempting to remove an object from the...

Do you have AWE enabled?

John Zacharkan

Not sure if it helps or if it's related, but have you seen this article

http://support.microsoft.com/default.aspx?scid=KB;en-us;q281346

When a dynamic cursor fetch is run under a profiler this problem usually yields the...

Sorry I don't normally mess with fill factor. I thought the only reason for increasing this above zero is if you know that the data is static. In this case...

🙂 0 (zero)

John Zacharkan

sp_helpindex 'BSKT'

PK__BSKT__52AE4273 clustered, unique, primary key located on PRIMARY BSKT_ID

chg_dt_ndx nonclustered located on PRIMARY CHG_DT

select INDEXPROPERTY (1109578991, 'PK__BSKT__52AE4273', 0)

returns NULL

quote:

---