November 18, 2009 at 8:33 am
Hi every one I am new to this blog and and want to become a dba. My question is that what are the tasks to be taken care when there is low system performance. As a dba what are all the tasks he should check to make the system run in high performance..:w00t: Can any one reply to this please..........?
November 18, 2009 at 8:58 am
That is a mighty big request, and there really isn't enough room here to fully answer what you have asked. One of the best things I could recommend is start lurking here and read through the numerous threads. You will find all sorts of problems/issues and evem more suggestions on how to fix/prevent/mitigate them.
As you read them and have questions, be sure to do some research and the ask for clarification. We are more than willing to help you learn, but show us you are willing to do some research as well.
November 18, 2009 at 9:02 am
The first thing you need to ask is whether the poor performance is normal or abnormal. Is the system always slow or is it usually fast, but has been slow for the last x hours. Once you know that, then you can start looking for the causes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 18, 2009 at 10:11 am
90% of the time I find that poor performance is directly related to poor design of the database, data structures and business logic (stored procedures and application code). The other 10% of the time it is the hardware (insufficient disks, memory etc.)
From that you can see that the biggest bang for the buck can be gotten by doing everything possible to insure that the application is designed by someone sufficiently competent to do so, and trying to change their design at least.
Good luck.
The probability of survival is inversely proportional to the angle of arrival.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply