question

There is no way to track this historically within SQL Server by default. You'll have to set up either [extended events][1] or a [server-side trace][2] to capture the events you're interested in. This will work for connections open & closed. For data inserts, you need to define more closely what you're looking for. Literally the number of rows? In that case, get the current counts for all your tables and then capture that value daily. You can then look at the differences. Same thing if we're just talking data size. But if you want to know specifically when particular queries were run, you're back to setting up extended events or server-side trace. If you're on 2008 or better, I strongly recommend using the extended events. Trace events are deprecated in 2012 and won't be around for too many more versions. [1]: http://msdn.microsoft.com/en-us/library/bb630354(v=SQL.105).aspx [2]: http://msdn.microsoft.com/en-us/library/ms191006(v=SQL.105).aspx