Comments
Sort by recent activity
I uninstalled and re-installed the whole thing and it seems to be working now. / comments
I uninstalled and re-installed the whole thing and it seems to be working now.
Apparently part of the issue was the Domain accounts credentials. I reentered the password on the Service Account and the Base Monitor service started correctly.
However, I still have the information dialog on the Global Overview page that says "You are not currently monitoring any servers." even though the Monitored Servers page shows two servers and 4 instances. / comments
Apparently part of the issue was the Domain accounts credentials. I reentered the password on the Service Account and the Base Monitor service started correctly.
However, I still have the informat...
Hey Thanks for the reply.
I have a similar problem. 50K+ entries of SQL Error log for a failed disk ( fortunately on a Dev server:) / comments
Hey Thanks for the reply.
I have a similar problem. 50K+ entries of SQL Error log for a failed disk ( fortunately on a Dev server:)
linque wrote:
I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:
Sure wish you'd said where the option is. I must have mud in my eye because I don't see it. / comments
linque wrote:
I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:
Sure wish you'd said w...
I am confused by your post. Are you using TFS or Visual Source Safe? / comments
I am confused by your post. Are you using TFS or Visual Source Safe?
I could live with the auto-refresh if I could just figure out how to access the history to create custom reports.
I want to query the history directly to determine things such as how the duration, raw size, and compressed size of the t-log backups varies through the day.
I can query MSDB to get some of the information I need but right now the only way I see to get the Raw and Compressed size is to laboriously page through the constantly updating GUI which does not even sort in a useful order. I.e., if you sort by Type then the Date is unordered. If you sort by date, then the Full and Diffs are hard to find.
Direct, Read Access to the history database would solve this issue. / comments
I could live with the auto-refresh if I could just figure out how to access the history to create custom reports.
I want to query the history directly to determine things such as how the duration, ...
rayherring wrote: »
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
I am trying to change the SQL Backup Agent Service account. It is a member of SysAdmin fixed server role on the instance. SQL 2008R2 Standard on Windows 2008R2 Data Center.
It turns out account needs access to HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal as well. / comments
rayherring wrote: »
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still se...
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
I am trying to change the SQL Backup Agent Service account. It is a member of SysAdmin fixed server role on the instance. SQL 2008R2 Standard on Windows 2008R2 Data Center. / comments
There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
I am trying...
I don't mind sharing the files with Red Gate but I am not willing to post them on an open forum [image]
If you provide an email address I'll forward them to you as attachments or if you email a link I can upload them. / comments
I don't mind sharing the files with Red Gate but I am not willing to post them on an open forum
If you provide an email address I'll forward them to you as attachments or if you email a link I can...
I have a very similar problem.
I am running a full backup of a 4TB database. For months the backup succeeds with little impact on the rest of the system. Of course it takes multiple hours.
Now, suddenly the backup core service is using 100% of 8 cores for the entire period of the backup.
The backup is set to create 8 files so the file sizes are manageable (each is ~50GB). Compression is set to Level 3. CheckSum and Verify are OFF.
According to Perfmon, SQBCoreService is using an average of 400% processor with a maximum of 500+. Perfmon also shows all 8 Cores at continuous 95% plus User Time.
Update: This was not a Red Gate Backup issue.
I spent some additional time analyzing this issue and I have determined that there is not really a specific problem. The database is 4TB and I am backing it to 8 files (all on the same disk). The server has 8 cores (2 x 4). The final files are around 40GB each (+/-15GB). The backup takes about 4 hours when several major application activities are shut down. When those same activities are running the backup can take up to 7 or 8 hours.
Right now, with just normal application processing in progress, I see that all 8 cores are consistently well-over 60% utilization and the Average %Idle Time for each core is in the 20% - 30% range.
So the issue here is clearly that the processors are just at overload under normal circumstances and adding the full backup just drives them to saturation [image] / comments
I have a very similar problem.
I am running a full backup of a 4TB database. For months the backup succeeds with little impact on the rest of the system. Of course it takes multiple hours.
Now, s...