Comments
Sort by recent activity
We've tried to design SQL Monitor to give users as much flexibility as possible over which credentials they use. So you're free to choose what best suits you.
The base monitor service account needs to be a member of the db_owner database role on the RedGateMonitor database.
The credentials for the monitored servers can be specified as they are being added to the system, or edited later by selecting the relevant line on the Monitored Servers page and selecting Edit Credentials from the drop-down on the right hand side of the page.
More details of the various permissions required can be found on the online help page http://www.red-gate.com/supportcenter/C ... 269935.htm
Hope this helps
Chris / comments
We've tried to design SQL Monitor to give users as much flexibility as possible over which credentials they use. So you're free to choose what best suits you.
The base monitor service account needs...
Changing to using IIS can be done by pointing your IIS website at the C:\Program Files\Red Gate\SQL Monitor 2\Website folder. The built-in web server can then be disabled in services.msc.
In v2.0 we only support the single password log-in but we're planning big improvements to this in future releases. Whether this will include support for Windows Authentication I can't say and will probably depend on the number of requests for this functionality.
Thanks for the feedback
Chris / comments
Changing to using IIS can be done by pointing your IIS website at the C:\Program Files\Red Gate\SQL Monitor 2\Website folder. The built-in web server can then be disabled in services.msc.
In v2.0 w...
Sire wrote:
One could argue it shouldn't be necessary to know what subqueries are run by the sp.
Yes I agree it would be nice to be able to reliably exclude any sp by name. I think we might be limited here by the SQL Server stored procedure we use to get the query fragments.
I'll raise an enhancement request to ensure that this limitation gets investigated at some point.
Thanks
Chris / comments
Sire wrote:
One could argue it shouldn't be necessary to know what subqueries are run by the sp.
Yes I agree it would be nice to be able to reliably exclude any sp by name. I think we might be...
I'm checking the IndexOptimize and DatabaseBackup scripts now. I'm finding that the IndexOptimize query is excluded but excluding the DatabaseBackup one is a bit more of a pain.
On running: EXECUTE [dbo].[DatabaseBackup] @Databases = 'RedGateMonitor', @... = N'E:\Backups', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 336, @CheckSum = 'Y'
I'm seeing a long-running query alert raised with a SQL process fragment like this:
BACKUP DATABASE [RedGateMonitor] TO DISK = N'E:\Backups\CSTEST$SQL2005\RedGateMonitor\FULL\CSTEST$SQL2005_RedGateMonitor_FULL_20101125_155854.bak' WITH CHECKSUM
There's nothing in this fragment that matches the "IndexOptimize|DatabaseBackup" regex but I'm finding that I can filter out this alert by using "IndexOptimize|BACKUP DATABASE|RESTORE VERIFYONLY".
Which version of SQL Server are you running these queries on out of interest? Also do you execute these scripts from within jobs or from directly from SSMS?
Thanks
Chris / comments
I'm checking the IndexOptimize and DatabaseBackup scripts now. I'm finding that the IndexOptimize query is excluded but excluding the DatabaseBackup one is a bit more of a pain.
On running: EXECUTE...
Sire wrote:
When updating to the latest (beta) version about a week ago I started seeing long running query warnings that were excluded successfully in the previous version. The settings were unchanged, and the exclude text was still "IndexOptimize|DatabaseBackup" (not multiple lines).
Are you able to post the SQL statements that you are trying to match? I'm guessing that these refer to stored procedures?
Thanks
Chris / comments
Sire wrote:
When updating to the latest (beta) version about a week ago I started seeing long running query warnings that were excluded successfully in the previous version. The settings were un...
Sire wrote:
The settings were unchanged, and the exclude text was still "IndexOptimize|DatabaseBackup" (not multiple lines).
That should work as it's the style of regular expressions I have been investigating on this thread. However, I've been using the released version (build 3780).
What build of SQL Monitor are you running by the way? The final beta build was 3529 so I'm presuming it's that one.
The released version of SQL Monitor can be found at: http://www.red-gate.com/products/sql_monitor/index.htm
Thanks
Chris / comments
Sire wrote:
The settings were unchanged, and the exclude text was still "IndexOptimize|DatabaseBackup" (not multiple lines).
That should work as it's the style of regular expressions I have be...
The RegEx wrapping to the next line shouldn't matter because as it turns out we only support a single expression. So multiple words/phrases will need separating with the pipe character '|'.
We'll be changing the embedded help to reflect the functionality in the next version. However, it's possible that in a future version we will change it to work the way you expected it to.
Many Thanks
Chris / comments
The RegEx wrapping to the next line shouldn't matter because as it turns out we only support a single expression. So multiple words/phrases will need separating with the pipe character '|'.
We'll b...
It looks to me like your Womaster queries should get excluded. I will do some investigation as this could be a bug. I'll post here when I know more.
Many thanks
Chris / comments
It looks to me like your Womaster queries should get excluded. I will do some investigation as this could be a bug. I'll post here when I know more.
Many thanks
Chris
Sorry for the delay getting back on this one. I've been testing this internally and I'm pretty sure that there is a bug when multiple regex expressions are specified on separate lines. This has been raised as a bug internally and we'll look into fixing it for an upcoming release.
A workaround might be to make a one line regEx that incorporates all the text that you want excluded. I'm thinking something like this: Database Mail|Womaster|RESTORE VERIFYONLY|SQLBackup|DatabaseMail90|sp_readrequest
This worked when I tried it on my test setup although mine only involved two different words.
Hope this helps
Chris / comments
Sorry for the delay getting back on this one. I've been testing this internally and I'm pretty sure that there is a bug when multiple regex expressions are specified on separate lines. This has bee...
I think I was wrong to suggest the ^ to be honest as that only matches characters at the start of the string.
Have you tried just Womaster without any special characters. \b matches a backspace and I don't think that would work in your case. [Ww]omaster should match both "Womaster" and "womaster"
Also the embedded help next to the regEx box has some useful tips and a link to a fairly comprehensive Microsoft regEx page.
Hope this helps.
Chris / comments
I think I was wrong to suggest the ^ to be honest as that only matches characters at the start of the string.
Have you tried just Womaster without any special characters. \b matches a backspace and...