Database Technologies‎ > ‎MSSQL‎ > ‎

Administration and Monitoring SQL Databases

 
Monitoring SQL Database.
Monitoring , Reporting, Management of  sql databases otherwise  a cumbersome process we could easily
mange these through excel
 
Reporting DB Sizes, Disk Space,DR status,backup status, all these could be reported direcly
into excel through this procedure, follow the below mentioned steps.
 
1) Data Menu ,go to Import External  Data
 
 
 
 
2)  Click On New Source
 
 
 
3) Choose Microsoft SQL Server
 
 
 
4) Specify the Required SQL Server and the Authentication
 
 
 
 
5) Select tempdb, and uncheck the box 'connect to specific table'
 
 
6) If you want save password in file
 
 
7) Go to Edit Query
 
 
8) Here is our dialog box, set command type to sql and here you could specify our various command
 
1) For database sizes sp_helpdb                      
2) For Disk Space      master..xp_fixeddrives
...etc 
 





Would like to thank  Dnyaneshwar Pasange for  the Idea.


Comments