User profile for chriskelly

I'm sorry for the delay in replying to your post. I believe that you have encountered a bug with SQL Monitor. This is a use case that the development team never considered and so it is only recently that we started looking at it. Unfortunately, it does mean that I cannot give you any timescales on when we might be able to address it and release any fixes (if appropriate). / comments

I'm sorry for the delay in replying to your post. I believe that you have encountered a bug with SQL Monitor. This is a use case that the development team never considered and so it is only recent...

0 votes

Thank you for your post. There is currently a bug in the tool which I think that you have encountered. This is logged in our system as SRP-9426. I have been working with the development team and we believe that we have a viable fix for it, but we have not been able to implement this fix as yet. Unfortunately, I cannot give any timescales for when this work can happen either as the development team are not able to give me this information at the moment. It is high on the list of work though. In the meantime there is a workaround that a number of other users have been able to implement. For scheduled or anticipated events then also schedule a restart of the SQL Monitor Base Monitor service for immediately afterwards. Unfortunately, this isn't the prettiest of workarounds and isn't much help for unscheduled events, but does work. If you have any questions then please let me know. / comments

Thank you for your post. There is currently a bug in the tool which I think that you have encountered. This is logged in our system as SRP-9426. I have been working with the development team and ...

0 votes

I'm sorry for the delay in replying to your post. When you reinstalled did you uninstall the old version? Is the new install monitoring too? / comments

I'm sorry for the delay in replying to your post. When you reinstalled did you uninstall the old version? Is the new install monitoring too?

0 votes

Thank you for your post and I am sorry for the delay in my reply. It currently is not possible to customise the Global Overview or any of the other webpages in the tool. This is something that has been requested before, and we have some suggestions on the SQL Monitor UserVoice forum which you are very welcome to comment on. https://sqlmonitor.uservoice.com/forums ... uggestions / comments

Thank you for your post and I am sorry for the delay in my reply. It currently is not possible to customise the Global Overview or any of the other webpages in the tool. This is something that has...

0 votes

Is there any further information logged in the SQL Server error log? / comments

Is there any further information logged in the SQL Server error log?

0 votes

SQL Monitor uses a complex data collection schedule to gather information about the entities it is monitoring. This has been designed to gain the best information at the most efficient rate, and tends to have less 'expensive' data being collected more often and more 'expensive' data collected less often. |This means that SQL Monitor will have the absolute minimal performance impact on the entities being monitored. For example, simple machine pings occur every 10 seconds, but the check for the fragmented indexes only occurs once a week (by default). This unfortunately does mean that some things are missed because the tool is unable to monitor every detail all the time. Especially for points 1 and 2 I would think that the databases alerted on the databases that were in the appropriate state at the time that the relevant detail was checked. For example, when the database state was checked, 9 databases were in a state other than Online and the others managed to slip between the gaps because the change happened between the two consecutive collections. Some further points to think about: 1. The Page Verification alert should fire when PAGE_VERIFY = NONE (or TORN_PAGE_DETECTION = FALSE for SQL 2000). Can you confirm whether this is true for all the databases? 2. For the 9 databases that were alerted on, are all the alerts now marked as Ended to reflect the Online status? 3. Has the database recently been renamed? 4. In the Configure Alert page you can select databases from the tree on the left hand side and disable alerts for them. However, some of the alerts work at the SQL Server instance level and so disabling these will disable them for the whole instance. This is why some of the alerts in the refreshed list for the database do not appear. https://documentation.red-gate.com/disp ... ing+alerts I hope this makes sense. / comments

SQL Monitor uses a complex data collection schedule to gather information about the entities it is monitoring. This has been designed to gain the best information at the most efficient rate, and t...

0 votes

My guess is that the regular expression you are specifying is not matching the BACKUP LOG in the SQL Process fragment. Possibly consider using: BACKUP/sLOG (assuming that the SQL Process will always be in capitals and it is all backup log jobs you want to ignore). (/s is the escaped character for 'space') It may take some trial and error to get exactly the behaviour you are looking for. RegExLib.com may also help: http://regexlib.com/CheatSheet.aspx / comments

My guess is that the regular expression you are specifying is not matching the BACKUP LOG in the SQL Process fragment. Possibly consider using: BACKUP/sLOG (assuming that the SQL Process will alway...

0 votes

Thank you for your post. SQL Monitor uses a SQL Server table valued function called sys.dm_exec_sql_text (based upon a sql_handle found using the view sys.dm_exec_query_stats) to gather information about queries which are run. These are used in a number of places including the long-running query alert. sys.dm_exec_sql_text (Transact-SQL) http://msdn.microsoft.com/en-gb/library/ms181929.aspx sys.dm_exec_query_stats (Transact-SQL) http://msdn.microsoft.com/en-us/library/ms189741.aspx The tool uses a complex query to get this information, and unfortunately neither of these hold the parameters specified when running stored procedures. To the best of my knowledge there is no way to retrospectively find these out either. I'm sorry that I don't have a better answer for you. But feel free to add any additional questions. / comments

Thank you for your post. SQL Monitor uses a SQL Server table valued function called sys.dm_exec_sql_text (based upon a sql_handle found using the view sys.dm_exec_query_stats) to gather information...

0 votes

Is it possible that the user account you are using for monitoring the SQL Server instance only has permissions to view the system databases? Or some variation of permissions which does not give it full access? This forum post suggests a query that you can use to see what permissions a user account has on each database. It should help you see whether this is the problem http://stackoverflow.com/questions/7048 ... a-database / comments

Is it possible that the user account you are using for monitoring the SQL Server instance only has permissions to view the system databases? Or some variation of permissions which does not give it...

0 votes

A windows admin account doesn't necessarily have full permissions on a SQL Server instance, so it is still worth double checking. / comments

A windows admin account doesn't necessarily have full permissions on a SQL Server instance, so it is still worth double checking.

0 votes

How can we help you today?

chriskelly

Comments