Activity overview
Latest activity by DanAppleyard
This resolved my issue. / comments
This resolved my issue.
I also am experiencing this. / comments
I also am experiencing this.
Re-Import Backup Information
I have a situation where the msdb.dbo.backupset table had a typo in the database_name field for some of the records. This caused SQL Monitor to display backup information incorrectly. After corre...
I also am experiencing this with my install of the same release. / comments
I also am experiencing this with my install of the same release.
I am updating this forum post to explain the discovered reason. It has nothing to do with SQL Monitor directly. As stated earlier, it seemed to correspond with the creation of backup-related alerts. SQL Monitor appears to use the database_name field from msdb.dbo.backupset table. I had some entries that had the name in uppercase, so SQL Monitor read that and ended up creating new database entries for the given server. / comments
I am updating this forum post to explain the discovered reason. It has nothing to do with SQL Monitor directly. As stated earlier, it seemed to correspond with the creation of backup-related aler...
No, we only have the single monitor. The alerts that came up that correlate with the duplicates showing (not returning, I just want to make that clear - they were not there initially) seemed to be backup related. / comments
No, we only have the single monitor. The alerts that came up that correlate with the duplicates showing (not returning, I just want to make that clear - they were not there initially) seemed to be...
Alex, It appears these duplications are only happening for those databases that are in PascalCase (MyDatabase). We do have some databases that are in uppercase (MYOTHERDATABASE) and those never get duplicated. Does SQL Monitor do something when it performs metrics that get the database name from the monitored server and just uppercases it and if that uppercase version of the database is not in the system, it creates a new database entry (or something like that)??? / comments
Alex,It appears these duplications are only happening for those databases that are in PascalCase (MyDatabase). We do have some databases that are in uppercase (MYOTHERDATABASE) and those never get...
Alex, These servers NEVER had an uppercase version of the databases in question. One such of these databases is master (FYI). I deleted this server (including purging all the data) from monitor, and re-added it. Initially the listed databases were correct (no duplicates). It wasn't until the first set of alerts were generated for this server did database duplicates show. I am running version 8.0.19.16748 (the version installed from the 14 day trial). / comments
Alex,These servers NEVER had an uppercase version of the databases in question. One such of these databases is master (FYI). I deleted this server (including purging all the data) from monitor, a...