Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU time etc, this really helps us to know the status of the server immediately.
Tag Archives: Administration - Page 3
Systray Utility to check SQL Server Service
Posted by Vidhya Sagar
on July 4, 2009
1 comment
I have developed this utility to monitor the instances of SQL Server running in a machine (i.e only standalone and not remote machines) and to send failure mail alerts upon service status. When I tried this type of systray utility in internet I could find only utilities that are monitoring the service and not sending any alerts on failures, so I’ve decided to add this feature in this. I hope this small utility could help you a lot.
Connection to the target machine could not be made in a timely fashion – SSCM
Posted by Vidhya Sagar
on June 24, 2009
6 comments
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.
Installing MSDTC as Cluster Aware Service
Posted by Vidhya Sagar
on May 16, 2009
No comments
This is my first podcast for sql-articles.com. In this article we are going to discuss on Installing MSDTC as cluster aware service on Windows server 2008. We need this service as cluster aware because this is the perquisite when configuring SQL Server 2008. Watch the video and post your feed back in our discussion board. Read more »
Configuring Failover Clustering in Windows Server 2008
Posted by Vidhya Sagar
on May 11, 2009
3 comments
I have planned to configure SQL Server 2008 clustering on Windows Server 2008 Clustering. To do this, first I need to configure Windows Server Clustering. Now a days DBA’s are not only working on RBMS platform, they should also have sufficient knowledge in their operating system on which their RDBMS is running. As a DBA we shouldn’t look into SQL Server cluster alone, we should also take part in windows clustering too. In this article I’m going to configure failover clustering in Windows server 2008.