How to monitor MS SQL server


and what role and permision the user should have for the user credintials?