Simple, weird problem, long research, short answer. The other evening, “something strange” happened to one of my clustered (active-active) boxes. When i arrived in the morning, the linked servers from each of the nodes to the other node was failing with the message: “Unable to complete login process due to delay in login response”. (Microsoft SQL Server, Error: 258)” Linked servers to and from all other Sql boxes were functioning. After much research, at the end of the day i had each node rebooted. Following the reboot process, the linked servers worked again. Done.
In Yesterday’s post I mentioned creating “registered servers” in groups in your “Registered Servers” Window. Today, i present a short script, which, if applied to the SQL 2005 (and up) groups will allow you to in real-time query all the SQL servers error logs…searching for suspicious things of your choice… just change the ‘where’ clause below… Continue reading “Multiple SQL Server Error log search”
Today some architecture changes were scheduled to occur in the evening. I wanted to adjust or disable backup jobs that could be affected. I have some 50 SQL servers. I needed to know when the backups were to start on each server. I found a nice script at http://www.mssqltips.com/tip.asp?tip=1622to do that for a single server. Continue reading “Determine Backup schedules across multiple SQL Servers”
Recently, I tested a LinkedSErver and received the error: “The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)”
What does this mean? Continue reading “LinkedServer Failure — SPN not set”
Learning about Performance Counters
How do you interpret the value you get back for any particular performance counter?
Continue reading “Performance counter types”
May 11, 12, 13. Steve is presenting on performance tuning in Orlando.
Today, I want to show how to be alerted any time one of your clustered SQL 2000 server fails over. This will work whether some admin fails it over on purpose, or accidentally. Continue reading “Get Alerted when your 2000 SQL cluster fails over”
Today, I want to show how to be alerted any time one of your clustered SQL 2005 server fails over. This will work whether some admin fails it over on purpose, or accidentally.
Continue reading “» Get Alerted when your 2005 SQL cluster fails over”