You can use Microsoft performance monitoring and tuning tools, you can also use the SQL Server Profiler by the using of this tool you can create and manage traces, analyze and replay trace results.
For performance monitoring and tuning tools: https://msdn.microsoft.com/en-us/library/ms179428.aspx
For profiler you need to follow this link: https://msdn.microsoft.com/en-us/library/ms181091.aspx