Oh, another odd data point for me to consider… I was getting these LooksAlive entries in the event logs for the SQL 2008 instance!įinally, a parting thought. Off hand, I think that both of the other Clusters were running SQL 2012 SP1 already. On Monday (since I’ve worked enough this damned weekend already), I’m going to go through the other two clusters and compare Updates that were installed, and base levels of SQL Server. Here’s the list of Updates applied last night. After the Windows updates were applied, my event logs on ONE server started being spammed with the Agent Alive checks. Last night, the System Administrator applied some Windows Updates (I don’t have a “test” SQL Cluster, but all these updates were applied on our Test SQL Servers prior to last night). Īnyway, so, none of the clusters in my environment have any history of Event ID 53 for SQL Agent. Here’s one connect article that shows some more details and which versions are fixed with what CU’s.
Not a one of them ever had the “dreaded” LooksAlive or CheckServiceAlive entries with Event ID 53 from. They all have (change that to HAD now that I’ve upgraded) SQL 2012 RTM, SQL 2008 R2 SP2, and SQL 2008 SP3. Not sure what to do now.I had read about the issues with the SQL Agent “Is Alive” checks spamming event logs on clustered SQL Server 2012 and SQL Server 2008 R2 SP instances… and since I have three sets of 2 Node clusters running multiple instances including 2012, 2008R, after reading about that a few months back, I checked my servers. All I could do was turn the pc off on the power button and restart it. The taskbar started flashing on and off, icons were missing from the desktop and an error box kept appearing saying windows explorer had to close. I did a system restore yesterday to see if that helped but although it said restore was successful, it still showed the last 3 days of updates in 'view installed updates'? However, as soon as the message saying the restore had been successful appeared, The green bar is moving so its not 'frozen'. 'Installed Updates' it says no updates have been installed on this computer! At the moment, windows update is showing 'downloading updates - 0%' and it has been like this for 6 hours now. Its during this time that I also noticed that 'View installed updates' only shows updates that have installed the last 3 days and when I look in For the past few days the update KB2538243 has tried to download and install several times but keeps failing.
0 kommentar(er)
