April 15, 2013 at 10:48 am
Hello --
I am trying out the dbWarden application by running it within the 2008 Standard R2 SQL Studio application. It appears to have executed successfully, but I am having trouble identifying and locating the output file. Can anyone provide information on this? Thanks.
April 15, 2013 at 12:32 pm
Hello --
I had a follow-up. I saved the output of the file to an rpt file, but I am hoping to generate a file similar to that which is shown in the screenshot on the following site:
https://sourceforge.net/projects/dbwarden/?source=navbar
What steps are required to accomplish this?
April 15, 2013 at 1:39 pm
You might have better luck with these questions if you click the 'join the discussion' link at the end of the article. The authors may or may not be active forum participants so gettting their attention with a forum question may not be effective. They are monitoring the article discussion link.
July 2, 2013 at 10:44 am
I have this running on numerous SQL Server 2008 R2 Cluster Instances and works great except for one. This one instance that gives me trouble just happens to be one which is Mirroring to another Instance across the WAN.
The issue is the "dbWarden_HealthReport" runs but never finishes or fails.
I am betting the issue is because the DB is Mirroring but not sure what to do about it.
Any ideas / suggestions?
Thanks!
March 6, 2018 at 4:29 am
Michael 97042 - Tuesday, July 2, 2013 10:44 AMI have this running on numerous SQL Server 2008 R2 Cluster Instances and works great except for one. This one instance that gives me trouble just happens to be one which is Mirroring to another Instance across the WAN. The issue is the "dbWarden_HealthReport" runs but never finishes or fails.I am betting the issue is because the DB is Mirroring but not sure what to do about it.Any ideas / suggestions?Thanks!
Hello Michael....
Were you able to resolve the issue of the job running forever and not completing or failing.
I have started facing the same problem on one of my intances, but thi works fine on the other 3 intances.
Also i do not have any mirrored databases in my environment.
Any help is appreciated.
Thanks,
S_M
March 7, 2018 at 10:40 am
S_M - Tuesday, March 6, 2018 4:29 AMMichael 97042 - Tuesday, July 2, 2013 10:44 AMI have this running on numerous SQL Server 2008 R2 Cluster Instances and works great except for one. This one instance that gives me trouble just happens to be one which is Mirroring to another Instance across the WAN. The issue is the "dbWarden_HealthReport" runs but never finishes or fails.I am betting the issue is because the DB is Mirroring but not sure what to do about it.Any ideas / suggestions?Thanks!Hello Michael....
Were you able to resolve the issue of the job running forever and not completing or failing.
I have started facing the same problem on one of my intances, but thi works fine on the other 3 intances.
Also i do not have any mirrored databases in my environment.
Any help is appreciated.
Thanks,
S_M
In general, this is because there is a lot of data in the ErrorLog, if you comment this section in the HealthReport stored procedure, the results may appear faster.
I created a table of parameters to see or hide the different sections of this report, and I modified the stored HealthReport procedure to show its sections depending on this. You can do the same. Luck
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply