Hi Team,

My manager wants to databases behavior document. Kindly suggest me what are things i have to cover in this documents.

as per my understanding the below things i have pre-pared.

1.Server name, Database name, Any locks and Deadlocks on this database 

2.How my mdf and ldf files on these databases auto growth

3.Database backup details. Anything i have missed please correct me any thoughts and suggestion please reply this thread.

Many thanks to your valuable suggestions.

You should say database properties mainly. And what do you mean by locks and deadlocks ? You cannot document locks and deadlocks

you can run below and get lot of information

use database_name
go
select * from sys.database_files
go
select * from sys.sysdatabases where name='db_name'
go
select @@Version

Take a look at those sites

http://blog.sqlauthority.com/2014/09/23/sql-server-ssms-performance-dashboard-reports-home-page-details/

http://blog.sqlauthority.com/2014/09/22/sql-server-ssms-performance-dashboard-installation-and-configur

I'm not sure what your manager needs, but consider adding security information. Things like a list of who can connect to SQL Server (logins) and who can connect to the database (users).

Of course there are many other security things you can make note of. See Database Engine Security Checklist: Database Engine Security Configuration http://social.technet.microsoft.com/wiki/contents/articles/1256.database-engine-security-checklist-database-engine-security-configuration.aspx and the other three checklists linked under Other Security Checklists at the bottom.

Hi Team,

Thank you so much for your suggestion.

Asking only Database behavior document. Any more suggestions kindly suggest me 

1.How can find out Every day how many backups are running and its (Full,T-log) backups?

2. At what time databases are busy? On what time database slow or any performance issues How can we find out all these t

Hi Team,

Thank you so much for your suggestion.

Asking only Database behavior document. Any more suggestions kindly suggest me 

1.How can find out Every day how many backups are running and its (Full,T-log) backups?

2. At what time databases are busy? On what time database slow or any performance issues How can we find out all these t