I have Sql sever 2012. In production I am seeing slowness in database.
How do I find slow running queries.
How do we check the CPU usage.
How do I see any deadlock.
Do we have queries to check this?
Any other metrics to check?
Also we have few SSIS packages. They load lot of new data from the files. The DB size is 1.5 TB.