DBA Repository – Gather Database Connection Information

How to poll connections to specific databases to determine how busy individual databases are. Continue reading

DBA Repository – Database Size Statistics UDF

How to find database size trending statistics based on the database size data gathered in the DBA Repository. Continue reading

DBA Repository – Gather Database Size Info

How to gather database size information for all SQL Server databases across an enterpsise for growth trend analysis Continue reading

DBA Repository – Find the Databases, Part 2

In a previous entry I demonstrated how to find all the databases on all the SQL Server instances on the network, update the repository with some properties of the databases and notify the DBA team when a new database is found.  The last … Continue reading

DBA Repository – Find the Databases, Part 1

In a previous entry I demonstrated how I created a server list and gathered information about those servers.  Now the DBA Repository needs to maintain a list of databases and some information about those databases. Creating the dbo.Databases table My intention … Continue reading