June 21, 2010 at 12:21 pm
Hi all,
what are things that we need to check first when somebody all of the sudden says we have an issue with your sql server or in the situation when sql server is down,
can anyone tell me complete things step by step
thanks in advance
rajesh
June 21, 2010 at 1:06 pm
While those on this board could give you a general idea of what you should look for you need an understanding of SQL server to take it to a practical application. There is also no magic bullet when you say what to look for when some one calls or the server goes down. Why is the person calling? what is there problem? what is going on in the server? what are they doing? what applications are connected? what does the CPU stauts look like? What does procedure cache look like?
these are just some of the question you would ask and each may lead to another question to another path.
If you have a particular problem now you might try to post a specific question but otherwise I would recommend researching common performance problems and there cuase and cures.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 21, 2010 at 3:35 pm
thnks dan
but see today all of the sudden some guy from other team came and was telling the issue is with your sql server and asking me to check slove but everything was fine from my side.. but i was in confusion whether i have checked correctly or not ...so i just want to know..
what are all the things that we need to check first and make sure that everything is fine from ourside and tell them confidently...
please revet bakme...
June 21, 2010 at 4:55 pm
Ask yourself these questions:
- Is the system up?
- Is the system available?
- Can users connect?
- Is workload consistent with baseline for this day at this time of the day?
- Are there any blocking locks?
- Are there any critical errors on the logs?
- Is wait events footprint consistent with baseline for this day at this time of the day?
- Are CPU, IO and Network critical metrics consistent with baseline for this day at this time of the day?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 22, 2010 at 10:08 am
thanks paul,
that helped me lot...
thanks thsnks
have a nice day boss
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply