Dear Friends,
Use of DMVs instead of SSMS GUI is always good sign of DBAs i understood and also trying to remove my bad habits by remembering all DMVs,Sys Table,sys Functions & sys procedure etc..
On my daily activity every morning i check all database,there status and physical location using below TSQL/DMV.
use master
SELECT db.name AS 'DB_NAME', mf.name AS 'FILE_NAME', mf.type_desc AS 'FILE_TYPE', mf.physical_name AS 'FILE_PATH', db.state_desc,
db.recovery_model_desc, mf.size, mf.growth
FROM sys.databases AS db INNER JOIN
sys.master_files AS mf ON db.database_id = mf.database_id
Use of DMVs instead of SSMS GUI is always good sign of DBAs i understood and also trying to remove my bad habits by remembering all DMVs,Sys Table,sys Functions & sys procedure etc..
On my daily activity every morning i check all database,there status and physical location using below TSQL/DMV.
use master
SELECT db.name AS 'DB_NAME', mf.name AS 'FILE_NAME', mf.type_desc AS 'FILE_TYPE', mf.physical_name AS 'FILE_PATH', db.state_desc,
db.recovery_model_desc, mf.size, mf.growth
FROM sys.databases AS db INNER JOIN
sys.master_files AS mf ON db.database_id = mf.database_id
Happy Reading
SumanJha_Accidental_Dba
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757