Red Gate forums: SQL Monitor 2

Long Island Computer Repair Onsite

sagor0055 — Sat, 25 May 2013 09:50:52 GMT

LAB Computer Consultants, LLC, your experts in Computer Repair Queens and Long Island.We are a full service cost-efficient In-shop Long Island Queens Computer Repair and On-site Long Island Queens Computer Repair, that has built highly skilled team of Computer Support Technicians with a broad range of experience in all things technical.

RE: Perfmon Bad data error

Lynchie435 — Wed, 22 May 2013 12:19:43 GMT

I have the same error:

22 May 2013 1:14 PM General Perfmon Bad data #Rnv

Perfmon data is missing objects: SQLServer:Access Methods, SQLServer:Buffer Manager, SQLServer:Databases, SQLServer:General Statistics, SQLServer:Latches, SQLServer:Locks, SQLServer:Memory Manager, SQLServer:SQL Statistics. Possible causes include performance counter library corruption, or a 32-bit/64-bit mismatch between Windows and the performance counter provider (e.g. SQL Server).

We are running 64bit 2008 Datacentre and 64 bit SQL Server 2008 RS. When checking perfmon on the machine itself the counters are all there.

If I run Powershell Command:

Code:

Get-Counter -ComputerName server -ListSet "*sql*

I have all the performance monitors listed yet I still get the error, can anyone shed some light for me please.

Cheers.

RE: False Alert - Monitoring error (SQL Server data collection)

priyasinha — Fri, 12 Apr 2013 09:27:10 GMT

Hi,

We do not allow customizing Monitoring error alert because they are important for the SQL Monitor to work as expected.

I would suggest that you investigate that why you are getting so many Monitoring error alerts. These alerts come up when any data collection fails. It is worth looking at the Base Monitor log files to see what data collection is failing and then investigating why?

Also, it is worth posting questions in SQL Monitor 3 forum and not SQL Monitor 2 forum. SQL Monitor 3 forum is active now and we would be responding much qucikly to question in that forum.

Thanks,
Priya

RE: False Alert - Monitoring error (SQL Server data collection)

retracement — Tue, 26 Mar 2013 10:54:06 GMT

I still don't seem to be able to find the functionality to customize alerts for timeouts (as indicated in this thread to be introduced in the next version). This currently means that a regular daily task is to clear down hundreds of false alerts generated from sqlmonitor. Am I missing something or can we still not change the alert timeout for this event? We are running version 3.

RE: Operation on handle \\server\HKEY_LOCAL_MACHINE failed

stanori — Thu, 31 Jan 2013 00:13:02 GMT

Hi hespinoza,

Thanks for your post. It looks like there could be some issues with remote registry access. From the machine that is running the SQL Monitor Base Monitor service you can log in with the new account you changed to, and run through the following data collection tests:

http://www.red-gate.com/supportcenter/content/SQL_Monitor/help/3.2/SM_Testing_data_collection

It could be this account does not have proper rights to the remote registry. Hope this helps.

Best Regards,

Operation on handle \\server\HKEY_LOCAL_MACHINE failed

hespinoza — Tue, 29 Jan 2013 22:58:48 GMT

We recently change the account our sql red gate service is running under and after that change we are having problems starting the monitoring of our servers. Below is the entry of our log file that gets written when we try to reestablish the connection to the servers

2013-01-29 22:46:01,822 [ 5] WARN RedGate.Response - Getting Log file
2013-01-29 22:47:07,601 [ 21] WARN RedGate.Response.Engine.Monitoring.Core.Licensing.LicenceAllocator - Licence level for uldbprod (1) changing from #a to #b
2013-01-29 22:47:07,625 [ 21] WARN RedGate.Response.Engine.Monitoring.Core.New.DataCollectionScheduler - Overriding schedule for [Cluster].[SqlServer].[Database].[Table].[Index] with WeeklyJobSchedule(Sunday, 1, 0)
2013-01-29 22:47:07,716 [ 5] WARN RedGate.Response.Engine.Monitoring.Core.Communicators.Machines.Registry.Unmanaged.Handles.AutoRegistryHandle - Operation on handle \\server\HKEY_LOCAL_MACHINE failed with error 5. Closing handle.

Any ideas of what this would possible be?

Thanks.

RE: DNS server

priyasinha — Tue, 15 Jan 2013 12:10:45 GMT

Hi,

Are you looking for IP address of Base Monitor machine? If this is the case then go to the machine where you have installed Web server and then navigate to this or equivalent location C:\ProgramData\Red Gate\SQL Monitor 3. There should be a file here called BaseLocation. This file will have the name or IP of the base monitor machine along with the port number.

Thanks,
Priya

DNS server

giopariax — Mon, 14 Jan 2013 11:25:00 GMT

How can I find my original IP adress and dns server if I changed them both, but forgot to write them down? I renewed and changed the dns server and now I can't connect to the internet. I need to find the original dns server and IP adress #'s. Can anyone help please?

RE: polling frequency

priyasinha — Fri, 07 Dec 2012 11:35:59 GMT

Hi Nach,

It varies for each counter. Some of counters like CPU are polled every 15 sec, others such as disk I think are polled every 1/2 hour whereas Index fragmentation is checked once a week.

As far as load on Monitored database is concerned, ideally you shouldn't notice anything significant on either CPU or memory. Network work traffic (inbound plus outbound) should be in regions of 10 KB/sec per server.

Thanks,
Priya

polling frequency

nach — Wed, 05 Dec 2012 19:11:34 GMT

Hi,

I want to know the polling frequency of Redgate monitor to the monitored databases. There are other enterprise monitoring tools which are in use and wanted to verify that the load is not too heavy. Thanks.

Nach

RE: Retry Connection after Monitoring Stopped

Brady1408 — Tue, 06 Nov 2012 20:20:34 GMT

Thank you!

RE: XSP web service consuming 99% of CPU

Brian Donahue — Tue, 23 Oct 2012 15:23:05 GMT

The only definite cause I was able to find was this one case where an external requester was DOSing the webserver. Some external IP was making many requests per second for phishing URLs. For example http://server/cgi-bin, http://server/phpbb, etc.

RE: XSP web service consuming 99% of CPU

wrighla — Tue, 23 Oct 2012 13:51:28 GMT

I am having the exact same symptoms here on our SQL Monitor server. Was a resolution ever determined?

RE: RequiresEncryption Flag

traian — Mon, 06 Aug 2012 15:14:24 GMT

I had the same issue, found this posts when I googled the WMI error. Followed the steps and it was fixed, but please note that I couldn't overwrite the .mof file, event tho' I ran as an admin the notepad and tried to save the original file....anyways, I saved it as .mof.txt and then ran: Mofcomp.exe ClusWMI.mof.txt

tsquillario wrote:

Anyone have success in trying the fix above?

I just got SQL Monitor running and this error started for me also. 2 Node Physical 2008R2, SQL 2008 SP3 Cluster.

RE: Error recieved after installing SQL Monitor 3

bgeoghan — Fri, 27 Jul 2012 14:09:40 GMT

THis issue was resolved. I changed the asp.net version to 2.0.50727 on the web site and that fixed the issue.