How to Get the Usage Statistics of Your SQL Server Databases
When working in a very large SQL Server environment, it is very common that no one in the organization knows who uses a particular database. This scenario is very common if there are multiple legacy systems. Follow this article to identify how effectively your SQL Server databases are used. Method 1: In this method, we are going to read the output of sp_who2 and capture it in a table. The first step is to create the table using this script. CREATE TABLE T1 ( session_id INT ...
Read more »