I'm having a perfomance issue with an application I more or less
inherited. The strange thing is that a query on the production DB takes
about twice as long as when I run it on a Db copy from last week on the
same server (12 s vs 6 s).
So far I can see that that the query and the indexes could be improved
a lot, and in fact I managed to write and alternative query which
executes in 200 ms, but the app guys keep asking me, why does
perfomance decrease so fast.
And to be honest I have no idea. The amount of data increased by about
1 %, so even with worthless indexing and poorly written queries I
wouldn't expect such an impact. PerfMonitor shows no problems and the
server (SQL2K Ent. SP3, 4 XEON 2,8Ghz, 16Gb RAM) should cope with the
Any ideas what is causing this decrease ?