Some of the data you want is available through the DMVs, but only for a short time period and it is completely lost after a service restart. To monitor SQL Server and trend it's activity over time you'll need to capture and store that information long term. You can spend lots of time building up scripts to do this manually. Or you could look into the Management Data Warehouse or thrid-party tools like redgate SQL Monitor[/url].