Script to gather informations on databases

By ADMPVI, 2013/06/19

The script is design to gather informations on the growth of the databases per server (except the system ones).
It is collecting in the 'databases' table of the master database for current information and in 'histodatabases' for old ones.
It is possible to schedule the stored procedure.
The column Serveur is only for gathering information on one server
The 'pourcentlibre' column provide information on the free pourcentage of the database

Total article views: 280 | Views in the last 30 days: 3

SCRIPT

Find information about all databases

ALL database information

FORUM

Copy a Database with out information

ARTICLE

INFORMATION_SCHEMA.101

Get information about the objects in your database using these ANSI standard, multi-platform views.

FORUM

daily CPU / IO possibly RAM information per DATABASE

ARTICLE

Total Database Information At Your Fingertips Part I

This article will help to get some basic information from your databases that may help you in differ...

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com