Simple & important Q

[farrokhp]

What is the most important thing you look at on a production database? Most important thing in your real life exoerience.

[davey23uk]

performance and stability

[slimdave]

A solid and tested backup and recovery plan.

[farrokhp]

And if you think Performance and Stability then what's the most important elements you will look for this objective? How do you implement the perfomance and stabilty mesures?

[SANJAY_G]

Originally posted by slimdave
A solid and tested backup and recovery plan.

Yes !!

[abhaysk]

How abt a solid backup/recovery & optimal performance..

[farrokhp]

General answers!! Let's say I am your tough boss and you claim that Prod DB is in optimal performance and rock solid. Then I ask you please proof me? What is the measures and benchmark you have? And the boss also told you that "But we still get complain from clients"
How do you hard convince him?

[marist89]

Originally posted by farrokhp
General answers!! Let's say I am your tough boss and you claim that Prod DB is in optimal performance and rock solid. Then I ask you please proof me? What is the measures and benchmark you have?

This depends on your SLA and what response times you establish. If you establish that screen X has to come up in sub-second time, then use screen X. If report Y has to be done in N minutes, time report Y.

And the boss also told you that "But we still get complain from clients"
How do you hard convince him?

Obviously you're not meeting your SLA requirements. How can you convice someone that your database is performing fine if your users complain?

[SANJAY_G]

Originally posted by farrokhp
"But we still get complain from clients"

Instead of trying to find out a general answer, work on spceific complaints first.