June 20, 2008 at 4:30 pm
Hello Guys,
I am working as a DBA in a MNC. Currently i need some help ....
I have very large production environment database so my server response is very slow i want to divide this database into 4-5 server. Can any body tell me how do this job..
Tell me if there is any other way that will give me give me good solution.
Its very urgent .......
Thanks and Regards,
Sunil Kumar
June 20, 2008 at 9:14 pm
Sunil (6/20/2008)
Hello Guys,I am working as a DBA in a MNC. Currently i need some help ....
I have very large production environment database so my server response is very slow i want to divide this database into 4-5 server. Can any body tell me how do this job..
Tell me if there is any other way that will give me give me good solution.
Its very urgent .......
Thanks and Regards,
Sunil Kumar
First, let's define what large is and also what very slow means. A very large database would be in the terabyte range - but if you have several hundred gigabytes then there are some things you should be doing to improve performance.
Generally, I would have to say most performance issues are related to improper indexing and usually there are opportunities for improving performance by tuning the queries.
Until you get into the terabyte range - there really is no reason to start looking at moving to multiple servers/databases for performance reasons.
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2008 at 2:22 pm
Also, dividing the database among servers might not work. It depends on your application.
You probably should hire a consultant to evaluate performance and help you improve the speed at which things work.
June 21, 2008 at 10:43 pm
some good resources here for large databases:
---------------------------------------
elsasoft.org
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply