Importing data from excel is very easy and you have several options to get you started… Continue reading “Importing data from Excel”
See your servers’ performance real-time
I have posted an article to enable you to compare your servers’ performance in real time. It’s one of my favorites. It won’t run on systems older than 2005. You’ll find it here.
Why can’t I see more job history?
I’ve been a DBA for a long time… and it still takes me a minute of thinking before I remember how to see more job history. Furthermore, it takes a second try before I remember that the “Maximum job history rows per job” is the number of steps * the number of job runs. So, if each job run has 100 steps, and your setting (as below) is “200” for the “Max rows per job”, then you’re only going to see 2 job runs in history. Continue reading “Why can’t I see more job history?”
Reboot–the last resort
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.
Multiple SQL Server Error log search
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”
Determine Backup schedules across multiple SQL Servers
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”
LinkedServer Failure — SPN not set
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”