470,624 Members | 2,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,624 developers. It's quick & easy.

time based performance decay

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

Noah Peters

Jul 20 '05 #1
0 1256

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by boyopeg | last post: by
77 posts views Thread by Charles Law | last post: by
43 posts views Thread by Mike MacSween | last post: by
5 posts views Thread by pandapower | last post: by
3 posts views Thread by Lilith | last post: by
31 posts views Thread by Ioannis Vranos | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.