I am working on an application with a sql server backend. the sql
performance always begins great, but decays quickly over time. if i
restart the sql service the performance shoots back up. The
degredation is gradual and slows to a crawl after about 8 days. During
this time I monitor several values from the sysperfinfo table and see
some interesting results. for example, i see the page splits/sec rise
from single digits to ~8000 after 6 days. i have tried rebuilding
indexes to reduce this number but it does not go down--ever. i have
tried dozens of solutions (including new hardware) none of which seem
to fix the problem.
i can provide more details if anyone is willing to help
thx.
Noah Peters