As per the excerpt in the link below:
Professional Advisory Services is an hourly, fee-based, consultative support option that provides proactive support beyond break-fix product support needs. Typical Advisory Services cases involve providing recommendations or best practices to solve problems leveraging Microsoft Products and Technologies. These scenarios include topics such as migration, product customization, performance degradation analysis, deployment training, scaling infrastructure, server recovery, optimization, supportability, risk analysis, root cause analysis, extensibility, architecture, and knowledge transfer.
If you are a Developer/Administrator and looking for consulting/advisory services from Microsoft here is the link you can follow and see what all products/technologies are covered and other details.