As a DBA it’s handy to have a script to PING all the Link servers and get a report to examine the connectivity. Following T-SQL script will ping all the preconfigured linked servers and get the packets sent, received and...
Read MoreIf you are suffering from poorly performing linked server queries, you may wants to investigate the Linked Server CPU utilisation statistics. Following T-SQL script retrieves information such as SQL Process utilisation, System Idle time and Other Process utilization for a preconfigured MS SQL...
Read MoreIt’s handy to have a script to find failed SQL Server Agent Jobs. Most of the organizations execute resource intensive SQL process such as backup, heavy ETL process at night and it is essential to validate those import process daily...
Read MoreBelow script can be used to retrieve latest backup file datetime and physical location for all the Databases in preconfigured Linked...
Read MoreSometimes you may wants to retrieve a linked server configuration details. Following T-SQL statement retrieves information such as Hostname, SQL Instance name, Server Edition (32 bit or 64 bit), IP address, Port , ServicePack and cluster configuration for a preconfigured...
Read More