You’ve been given a new server and need to diagnose it quickly.
You’ve just been given a server and you either need to fix a problem or just want to make sure that it’s set up correctly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems. We will walk through scripts that will help you pin point various issues quickly and efficiently. This session will help you diagnose the following concerns;
- Settings – is your server set up correctly from the beginning?
- Hardware – Check your basic hardware specifications and whether it’s going to meet your needs
- Bottlenecks – We’ll see if there are any areas of the system that are throttling us.
By the end of this session you should have the knowledge of what you need to do in order to start on your own kit.
All code we’ll go through is either provided as part of this presentation or are open source/community tools.
Why I Want to Present This Session:
I’m a performance tuning DBA that loves optimisation. I regularly have to jump on (customer) servers I’ve never seen before and fix them. I’ve built my own toolkit over time to make this process quicker and would like to share this information with the community.
I’ve contacted all authors of open source/community tools that I’ll use in this presentation to obtain permission to include them here. I’ll also publish all scripts, links and the slide deck on my blog.