Bru Medishetty's SeekWell Blogs
Archive for February, 2010
Finding the nodes in a Failover Cluster
Feb 18th
I was recently asked by a friend, how to find the names of the nodes that are participating in a failover cluster.
The Dynamic Management View sys.dm_os_cluster_nodes will give this information. The following script will return the list of Node names in the cluster.
Note that the query was run on a 3 Node cluster, so the result set displays the 3 Nodes in the cluster.
If the same command is run on a stand alone machine, it would not return any node name indicating it is not a cluster.
– Bru Medishetty
My First Article in MSSQLTips
Feb 11th
Today is a special day for me. An article that I submitted is published in MSSQLTips. The article looks into the Index fill factor settings and what is a good value for a given scenario.
Continue to read the article Understanding SQL Server Index Fill Factor Setting.
– Bru Medishetty
Using the right terminology.
Feb 10th
I am a regular visitor to SQL Server Forums at SQLServerCentral and see some users posting their question, issues and problems. Some of these questions tends to confuse even the seasoned campaigners and at the same time would not give the complete picture of what is being asked. I saw a user posting a question seeking internals of Transactional Replication and in the next sentence asks about Transactional logs. I was not sure what was the area the user was looking for.
Similarly few days back a user was requesting the suggestion of other users in setting up Database Mirroring and was referring one servers as Publisher (A publisher is the source server / system in a Replication setup), where as when questioned by a fellow user, he was referring the Principal Server as publisher and cleared the doubtful minds.
There is nothing wrong in being a learning IT professional, it is OK to make mistakes but it should not be done repeatedly and due consideration needs to be taken with the technical terminology.
– Bru Medishetty
Recent Comments