Not every one possesses the tuning skills.Typically in a large shop, there should be some in-house tuning guy(s).Otherwise, you have to seek outside resources.I do manage 1000+ databases by myself, and regularly collect necessary performance dataIn y...
显示全部Not every one possesses the tuning skills.
Typically in a large shop, there should be some in-house tuning guy(s).
Otherwise, you have to seek outside resources.
I do manage 1000+ databases by myself, and regularly collect necessary performance data
In your case, if he does not have much tuning experiences, but he can
1) make sure no CPU/Memory/Disk IO starvation
2) make sure no heavy duty/long running SQL(s) hitting the database,
he can pretty much rule out db issue.
收起