Hi How could i make something like a report of my sql server instance to analyse its condition like.. how much memory is being used?,how much cpu is being used?, how is the overall performance of the server? Are there any queries to help this, Do i have to use any tools?
Start with the Server Dashboard report that is available in Management Studio. Right Click the instance, drill down to Reports/Standard Reports and then select the Server Dashboard Report. It has various information like what you requested. If you are curious about the queries for that, then you can trace the Dashboard report and discover what is being run.