Red Gate forums: SQL Monitor 3

RE: sql monitor alert level not changing down a level

stevenhoban — Fri, 24 May 2013 13:45:09 GMT

ive got all the screen shots exce[t the 'frgmented indexe' tab - there isnt one !

RE: sql monitor alert level not changing down a level

priyasinha — Fri, 24 May 2013 13:28:55 GMT

Hi Steven,

Could you please email screen shot of the following at priya.sinha@red-gate.com:
- Details tab for the alert.
- Fragmented indexes tab for the alert.
- Alert history tab for the alert.
- Click on 'configure alert' link on the alert details page and then send screen shot of the Alert settings page.

Thanks,
Priya

sql monitor alert level not changing down a level

stevenhoban — Fri, 24 May 2013 13:01:16 GMT

I have the alert "Increased % of fragmented indexes" set up on sql monitor. The medium level alert is set when the value reaches 25 and the alert was fired at value 29. I last night ran some index maintenance jobs to rebuild if over 30% fragmentation and reorganise if over 5%.
The alert collects the data once a day @ 13:35 and i can see the alert has now been 'downgraded' from medium to Low when i click on the 'alert history'
How is it then, that the actual alert on the inbox is still showing as 'Medium' - should this not have changed to a blue 'low'.?
Also if i set to re-organise my indexes with 5% or above fragmentation level, howcome this is still showing as a downgraded leve. Shouldnt it be set to 'ended'
Thanks
Steven

RE: Windows authentication in IIS 7

mortenn@hapro.no — Fri, 24 May 2013 11:23:15 GMT

I am trying to use windows authentication between my browser and the web site.

RE: Exporting SQL Monitor 2.3 alert data

chriskelly — Fri, 24 May 2013 09:24:54 GMT

Unfortunately, this is difficult. The data for any alert is not stored in one particular table within the data repository. Also the development team have not been able to provide documentation to help.

I would recommend that you post a suggestion on the SQL Monitor UserVoice Forum. This is used by the development team to gather suggestions and gauge interest in those ideas. At the very least you should get a better response direct from the development team.

https://sqlmonitor.uservoice.com/forums/91743-suggestions

RE: Maintenance Window

Luis Martin — Thu, 23 May 2013 19:20:22 GMT

Thanks.!

RE: Windows authentication in IIS 7

chriskelly — Thu, 23 May 2013 16:45:32 GMT

Thank you for your post.

Where are you trying to use Windows Authentication? It isn't entirely clear in your post.

The tool login has three user rules which do not support Windows Authentication in any way. But windows user accounts can be used for the actual monitoring.

But if you can clarify what you are trying to do, then I might be able to give a more specific answer.

RE: Maintenance Window

Brian Donahue — Thu, 23 May 2013 12:53:31 GMT

You may want to visit the SQL Monitor user sugegstion forum:
http://sqlmonitor.uservoice.com/forums/91743-suggestions

This way the popularity of product suggestions is monitored so the most popular suggestions will be considered.

SQL Monitor currently allows only one time setting for the maintenance window that can be applied to the chosen days of the week.

Exporting SQL Monitor 2.3 alert data

webrunner — Wed, 22 May 2013 16:16:28 GMT

Hello,

Is there any way to export data (Excel or CSV) from the list of uncleared alerts that show when one clicks Overview?

I have a list of Deadlock alerts and would like not to have to go through them one by one. I know this data is in the RedGateMonitor database somewhere but -- if there is no easy way to export from the Admin site -- I don't know the exact tables and queries to use to extract the data.

Thanks for any help. Let me know if you need any more information.

Windows authentication in IIS 7

mortenn@hapro.no — Wed, 22 May 2013 14:17:37 GMT

Hello,

I am having some trouble getting SQL Monitor to use Windows authentication through IIS.

If I enable windows authentication and disable forms authentication in IIS, I get prompted for a username and password.
Entering credentials in this prompt does not work.
Aborting it, I this;

HTTP Error 401.2 - Unauthorized
You are not authorized to view this page due to invalid authentication headers.

lookint at http headers in firebug, I send NTLM Authorization header to the server, but the response only has a WWW-Authenticate Negotiate NTLM header in it.

NTLM authentication is working fine against other sites hosted on a different IIS server.

I have tried this a few times now, with no success.

Any pointers would be greatly appreciated.

// Cheers, Morten

Maintenance Window

Luis Martin — Wed, 22 May 2013 00:49:51 GMT

This is a suggestion.

Actually we can set maintenance window i.e from 11pm, 5 hours.
May be is more useful working time:
From Monday to Friday, 6am to 10pm and nothing on weekends or Monday to Friday, 6am to 10pm and Saturday from 6am to 1pm and nothing on Sunday.

Just a thought.

SQL Monitor v3.4 has been released.

priyasinha — Tue, 21 May 2013 12:44:54 GMT

SQL Monitor v3.4 is now available to download from http://www.red-gate.com/products/dba/sql-monitor/

What�s new in this release?

� Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
� There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel (not available in IE7 and IE8).
� Log files can be retrieved from the �Configuration -> About� page.

For more information, see the release notes.

Find out more or contact us:

Read more about SQL Monitor 3 and its key features.
Report any issues and raise questions on the support forum or email us at support@red-gate.com.

SQL Monitor - Base Monitor Fault

Lynchie435 — Mon, 20 May 2013 08:56:08 GMT

Morning All,

Have put this to Redgate Support but have heard nothing back as of Friday afternoon and see no harm in seeking alternative advice.

We have purchased the DBA Bundle because we are using the SQL Prompt and Backup Pro and for the money it was well worth the punt.

I used SQL Monitor previously at another business and was impressed with it that I have attempted to set it up in-house here.

I didn't have a problem previously although this time around I seem to be getting a problem with the Base Monitor when starting SQL Monitor.

All my credentials are correct at the service has started successfully however I am getting this error everytime I access the webpage:

I have tried re-installation and I have also deleted the *.pfx file to no effect.

Anybody else have any other suggestions?

Regards,

James

RE: no values for database

priyasinha — Wed, 15 May 2013 13:13:28 GMT

Hi Brian,

Could you please get in touch with support at support@red-gate.com? Also, please include log files in the email.

Thanks,
Priya

RE: Clock skew alert

priyasinha — Wed, 15 May 2013 13:12:03 GMT

Hi Ian,

No, it is not currently supported.

Thanks,
Priya