|
|
Posted by Zamdrist on 03/29/07 18:48
Thank you all for the advice and suggestions!
I did run Profiler and found that my suspicious are correct, all
queries are being ran via in-line text statements, no application
procedures exist much less being used.
Quite a bit usage of sp_cursorprepare, exceute, close, etc. also.
Don't know if this is normal or not.
So yeah, basically I'm up a river with no paddle. We have no access to
the application code or the programmer, nor do we even have a support
license agreement anymore with the company who wrote the application.
I did end up archiving off most of the data from the tables in
question and wrote a custom interface to that using ASP.Net. Works
like a charm, no indexes whatsoever. Archiving and subsequently
deleting the data from the production tables, and rebuilding existing
indexes had little to no effect on performance unfortunately.
Again...up a river with no paddle, lol.
Thanks
Navigation:
[Reply to this message]
|