Databases Duplicated Under Monitored Server
DanAppleyard
Posts: 9 New member
Can anyone tell me why I would see some of my databases on a single instance MSSQL server duplicated in the list of databases on a monitored server? It does not happen for ALL of the databases, just some (no noticeable reason). For those that are duplicated, there is one in PascalCase (MyDatabase) and one in all uppercase (MYDATABASE). The one in PascalCase perform correctly (shows data, etc.). The uppercase one does not have any data. Only the PascalCase one has an availability of ONLINE.
Tagged:
Best Answer
-
DanAppleyard Posts: 9 New memberI 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.
Answers
Is you SQL Server instance case sensitive? If so, is it possible that someone could have created an UPPERCASE version of the same database and then deleted it?
If these are possible SQL Monitor would likely have captured information about that database when it existed and it will be displayed until the historical data related to it has been purged.
You may be able to confirm this by checking for historical data for the UPPERCASE database using the back in time mode on the server overview or the analysis graph.
If none of those seem to be the case, please let me know!
Kind regards,
Alex
Have you visited our Help Center?
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).
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)???
Thanks @DanAppleyard!
How odd, can I check-- do you by any chance have two base monitors using the same repository, and the server is added to both?
What type of alerts had come in that made the duplicates return?
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
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.
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?