Grant Fritchey (7/12/2011)

---

With an OLTP system, it's very easy to get an estimated cost on queries that exceeds a value of 5. That means that query is a candidate for...

Ninja's_RGR'us (7/12/2011)

---

It's not basic at all actually.

I'm no expert in waits but I'll hang around if I can help more.

What's the normal use of the system? OLTP, OLAP, both?

What's...

Actually there's one more thing I'd like to pick your brains with. On the post that started this thread I mentioned that I looked at waits and wait types on...

Thanks for your help guys.

I will try to dig deeper into this, but I will also try to find a DBA to help me.

Regards,

jm

Ninja's_RGR'us (7/12/2011)

---

Ignore the Good Enough Plan Found comment, Gail had more info than me on that topic. Bottom line is that this is not an issue.

I've read a really...

Ninja's_RGR'us (7/12/2011)

---

Cursor query :

Good Enough Plan Found (not awefull but better if you don't have this warning)

estimate 4 vs 354 found (can be a real big problem if you...

jmaia (7/11/2011)

---

Ninja's_RGR'us (7/11/2011)

---

I'm not on the client's building anymore and I can't access the database from where I am now, but I'll try and follow your articles for posting data...

Hi,

I'm...

Hi Graeme,

We did some load tests on the application in a lab environment with the same architecture as the production environment, but with less resources and could not find any...

Thanks GilaMonster, I'll look into those links... 🙂

Regards,

Joao Maia

Hi,

Thanks for your quick reply. I will try to answer your questions as best as I can:

Is the database being updated or is it read only ??

[jmaia] It is being...