George Zhou Zhiqing

SQL server mdf file modifed date the modified date of mdf, ndf (sql server database files) only changes when 1. Database turns online(server restart, new db, being restored) 2. file expanded/shrunk 3. DBCC checkdb ---will update if notice further factor to change the modified date of database data file.

My Way to identify SQL AGENT SERVICE is running Collect last date/time SQL agent job is running by using SSIS/SSRS very night to send email report for those date/time is more than 1 days old

LOAD LINUX HPUX disk space info through ORACLE external table into SQL SERVER TABLE I have exported all my Windows Disk info from SQL server views into my Metrics database, so that I can expect the disk growth and check if disk is going to full in how many days. (will introduce next time). But for my 10 oracle physical servers, I manually collect to Excel and import to SQL table, present in SSRS report. This is time consuming. Today I have create on external table in ORACLE and made it happen automatically, same like my other SQL night DBA, ORACLE night DBA (backup alert) etc. my Oracle servers on a few HP UX servers and a few LINUX servers, except some part (I listed two), most are same for both systems. Thanks to  https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5088536900346242095  ----create directory >mkdir -p /home/oracle/diskspace --create run_df.sh      > [9004] $ vi .bashrc      export PATH=$PATH:/home/oracle/diskspace     [9005] $ sou

Developing Nightly DBA PACKAGE for MS SQL SERVER and ORACLE CHECK IF SQL AGENT JOB RUNNING Scenario: 1 DBA, 200+ MSSQL instances (PM, VM), 1700+ MSSQL databases, version 2000-2016  10 Oracle machines(Windows, Linux, HPUX), 30 Oracle Databases. version 10g-12c to be able to manage such big amount of MSSQL and Oracle databases, an automatically monitored system is required to highlight only the instances/database to be checked every morning. Tool to be used: MSSQL, SSIS , SSAS, SSRS CHECK IF SQL AGENT JOB RUNNING it would be easy to check if the sql agent job running when you have very small amount of SQL Servers to monitor, by just check it in SSMS, but it would be difficult or impossible to check when you have 200+ SQL servers as you have many many other important things to check and fix. We used to tool nagios to check if a Windows service is stopped until recently we have a situation as I asked  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7b85edc

random memo one of the many differences between Oracle and SQL, to be continued. Oracle uses REDO log roll forward and uses UNDO tablespace to rollback, though theoretically can use redo(transaction log)  log to rollback but not efficient. SQL server uses transaction log to roll forward androll back. Noticed a good summary of Differences between UNDO and REDO in oracle by Francisco Munoz Alvarez https://oraclenz.wordpress.com/2008/06/22/differences-between-undo-and-redo/ difference of Schema:  Schema is collection of objects, in SQL, create user doesn't create schema, in oracle then it does in oracle a  user and a schema have the same name, but SQL doesn't have to

Scenario: 1 DBA, 200+ MSSQL instances (PM, VM), 1700+ MSSQL databases, version 2000-2016  10 Oracle machines(Windows, Linux, HPUX), 30 Oracle Databases. version 10g-12c to be able to manage such big amount of MSSQL and Oracle databases, an automatically monitored system is required to highlight only the instances/database to be checked every morning. Tool to be used: MSSQL, SSIS , SSAS, SSRS Data to be collected and analyzed Instance and Databases properties, hardware info, CPU, Memory, DiskIO, latency, waits, Part one: Design Database to store metric data