Connection to the target machine could not be made in a timely fashion – SSCM
Problem:
In our cluster environment I was testing SQL failover, when I failed over to passive node I can no longer launch SQL Server configuration manager (SSCM). When I tried to open SSCM, MMC has waited for 30 seconds and gave me the error below.
“Connection to target machine could not be made in a timely fashion”
Resolution:
Upon researching on this I found that WMI Service (Windows Management Instrumentation Service) is in hanged state. After restarting the service on passive node, it worked for me. Steps to restart the service is below.
- Go to Run –> type services.msc and press enter
- Right click on the service “Windows Management Instrumentation” and click on restart option in the menu
- Now launch SQL Server configuration manager, it should work fine now.
Script to get row count for all the tables in all the databases
I've written this script to get details of row count in all the tables in all the database including the system database. You can modify the script to exclude system database if you don't need details for that. You can see that I haven't use COUNT() function to get these values, If I run using this function for all the db then it will take more time and resource.