Activity overview
Latest activity by jalfano
RBA,
We are very pleased with the product but we are also seeing that this CPU issue is very bad. Are there some steps we can take to troubleshoot or at least provide your team with the necessary information to investigate some of this?
I ran the ANTS profiler on the environment that's monitoring our dev servers and saw (what i thought was a lot) of exceptions being thrown.
Our other environment was pegged at 99% CPU almost constantly after running for about a week and then when I tried to stop the base monitor process it crashed.
I think if we're going to move forward on this product we'd need to know that this CPU issue was being seriously looked at and there are some hard steps being taken to resolve some of it.
Let me know what information I can provide you to start investigating these issues.
Thanks! / comments
RBA,
We are very pleased with the product but we are also seeing that this CPU issue is very bad. Are there some steps we can take to troubleshoot or at least provide your team with the necessary ...
Oh! I didn't even realize that! So basically whatever level I'm clicked on (server, instance, group) that is the level that the setting will apply to. Got it!
Thanks!
Is there any estimated release date for SQLMonitor v2.2? / comments
Oh! I didn't even realize that! So basically whatever level I'm clicked on (server, instance, group) that is the level that the setting will apply to. Got it!
Thanks!
Is there any estimated relea...
Disabling / Acknowledging Alerts By Server
Is there any way to disable an alert for a particular server? Another option would be to acknowledge an alert for a given period of time or until the alert stops and starts again.
This would be he...
RBA,
Right now we're just testing so we have 6 servers on one test environment with about 50-120 databases which would be similar to production (except in production we'll have about 20 servers) and we have another test environment with about 10 servers and about 10-25 databases per server which is more similar to our dev environment.
The databases are all fairly small (< 8 GB) but they have a large number of objects in them (procedures, tables, etc...).
So I think once we purchase we're looking to get about 30 servers monitored.
The trace I sent you was for the smaller environment that mimics our testing environment but i'm seeing similar CPU usage on both. / comments
RBA,
Right now we're just testing so we have 6 servers on one test environment with about 50-120 databases which would be similar to production (except in production we'll have about 20 servers) an...
Here's a sendspace link to a saved, short ANTS profiler trace of the base monitor service on my local machine. I also included the html output. http://www.sendspace.com/file/s0o579 / comments
Here's a sendspace link to a saved, short ANTS profiler trace of the base monitor service on my local machine. I also included the html output.http://www.sendspace.com/file/s0o579
SQLMonitor 2.1 - High CPU Utilization
We have been running a trial of SQLMonitor for the past week or so and are seeing that the process called Redgate.Response.Engine.Alerting.Base.Service is consuming a lot of the CPU time on the ser...
Installing SQLMonitor in a Disconnected Environment
Our company has a central network and we have multiple separate hosted environments at other locations. Each of the other locations has at least one database server and 3-4 other web / application...
Fragmented Indexes Alert on System Tables
I am getting notified that master..syscomments has 46% fragmentation but when I run DBCC DBREINDEX('syscomments') it tells me
DBCC DBREINDEX cannot be used on system tables
Should the alert be c...
I ran the exact code you posted above and just replaced the path with a path to one of our files. I'm still getting the same error "Syntax error: 'SINGLERESULTSET' after 'WITH'"
File version of SQBCoreService.exe is 5.1.0.2781
When I go to help > about it says I'm using Red-Gate SQLBackup 5.4.0.55
Windows version is Windows Server 2003 Enterprise Edition x64 SP2
SQL Server is SQL Server 2005 Standard Edition x64 SP3 CU1
(9.0.4207)
Please let me know if you need any other information.
Thanks!
John / comments
I ran the exact code you posted above and just replaced the path with a path to one of our files. I'm still getting the same error "Syntax error: 'SINGLERESULTSET' after 'WITH'"
File version of SQ...
I'm trying to use it for the RESTORE HEADERONLY command. I need to extract information from the header in order to do what I need to do.
John / comments
I'm trying to use it for the RESTORE HEADERONLY command. I need to extract information from the header in order to do what I need to do.
John