Activity overview
Latest activity by joffwilliams
I had the opposite issue - all instances within a cluster were reporting metrics, but I had nothing for one of the cluster nodes (the other was fine). Restarting the base monitor fixed it. Thanks! / comments
I had the opposite issue - all instances within a cluster were reporting metrics, but I had nothing for one of the cluster nodes (the other was fine). Restarting the base monitor fixed it. Thanks!
SQL Monitor April Fool
Should have posted this a couple of days ago but just getting around to it.
Some of our analysts receive notifications from SQL Monitor when it affects their databases. This April Fools Day, I came...
chriskelly wrote:
What kind of entries are being logged? Are they login failures?
Login successes - hence the frequency of them. / comments
chriskelly wrote:
What kind of entries are being logged? Are they login failures?
Login successes - hence the frequency of them.
SQL Monitor account in Windows Security Log
When browsing the Security Log of the Windows Event log, there are a lot of entries referencing the domain service account used by SQL Monitor. To be more objective - it's not unusual to see ten to...
Brian,
HKLM\Cluster\Quorum has an ID in the "Resource" entry.
HKLM\Cluster\Resources\<quorum resource ID>\Parameters has no DiskUniqueIds entries. There is a DiskIdGuid but it is blank.
HKLM\Cluster\ClusterInstanceID has an entry. / comments
Brian,
HKLM\Cluster\Quorum has an ID in the "Resource" entry.
HKLM\Cluster\Resources\<quorum resource ID>\Parameters has no DiskUniqueIds entries. There is a DiskIdGuid but it is blank.
HKLM\Cluste...
Brian,
I can run that query against node 1 from node 1 and against node 2 from node 2, but not from node 1 against node 2 and vice-versa. The results I did receive indicated each returned result had an ID property with a numeric value. / comments
Brian,
I can run that query against node 1 from node 1 and against node 2 from node 2, but not from node 1 against node 2 and vice-versa. The results I did receive indicated each returned result ha...
Brian,
The base monitor computer is the second node of the cluster.
Node 1: SQL Server Instance (capable of failover to other node if necessary) with data repository, installed as Base Monitor user during installation.
Node 2: SQL Monitor Base Monitor and IIS
Hope that makes sense. / comments
Brian,
The base monitor computer is the second node of the cluster.
Node 1: SQL Server Instance (capable of failover to other node if necessary) with data repository, installed as Base Monitor user...
Same results for both nodes of the cluster. That is, the node the SQL Server instance is on and the node SQL Monitor is running from. / comments
Same results for both nodes of the cluster. That is, the node the SQL Server instance is on and the node SQL Monitor is running from.
Brian,
Every result contained a VolumeSerialNumber property.
Perhaps I should note that there are no SQL Servers being monitored yet. I am unable to access the web UI to even begin using the software. Finishing installation is as far as I have got. I did have SQL Monitor running on a workstation, as a preliminary environment, but it died so I'm now performing a fresh installation on a proper server. / comments
Brian,
Every result contained a VolumeSerialNumber property.
Perhaps I should note that there are no SQL Servers being monitored yet. I am unable to access the web UI to even begin using the softwa...
Found the Base Deployment log file. This error keeps repeating:
2012-06-05 15:28:03,510 [ 7] WARN NHibernate.Type.CustomType - custom type is not Serializable: RedGate.Response.Common.Persistence.NHibernate.UserTypes.CredentialsUserType
2012-06-05 15:28:03,510 [ 7] WARN NHibernate.Type.CustomType - custom type is not Serializable: RedGate.Response.Common.Persistence.NHibernate.UserTypes.CredentialsUserType
2012-06-05 15:28:03,510 [ 7] WARN NHibernate.Type.CustomType - custom type is not Serializable: RedGate.Response.Common.Persistence.NHibernate.UserTypes.CredentialsUserType
2012-06-05 15:28:03,542 [ 7] ERROR RedGate.Response.Engine.Alerting.Base.Service.MonitoringAndStorageService - Unhandled exception in delayed start.
System.ArgumentNullException: Value cannot be null.
Parameter name: value
at System.BitConverter.ToString(Byte[] value)
at #RVG.#esG.#tQb()
at #Wze.#euG.#gOb(Int32 , String , Int32 , Int32 , String )
at #RVG.#mNH.#0IH()
at #RVG.#kNH.#3IH(Boolean )
at #eLv.#qNV..ctor(#nNV , RepositorySettingsSection , CollectionSettingsSection , AlertSettingsSection , FeatureUsageSettingsSection , #ffZ )
at #eLv.#dLv.#ANV() / comments
Found the Base Deployment log file. This error keeps repeating:
2012-06-05 15:28:03,510 [ 7] WARN NHibernate.Type.CustomType - custom type is not Serializable: RedGate.Response.Co...