I will try to dig a little deeper but the problem is that I don't have anybody to talk to yet about what procedure it's calling and when it happens?
All I was told that this is working slow, customer is complaining, can I fix it?:unsure:
Is Server side trace the best option I have to find out what's going on with the performance. I don't think it's acting up like this because of the Hardware since I already mentioned that it's got 6GB memory and the DB is very small in size. And I also mentioned that we are shrinking the DB every week, so you guys don't think that's what's causing the problem right?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]