Re: MSSQL Integration Agent (189 Views)
Reply
Trusted Contributor
Johnc_3
Posts: 170
Registered: ‎07-16-2004
Message 1 of 3 (219 Views)

MSSQL Integration Agent

Hi,

 

I'm testing the MSSQL Integration Agent and am getting some strange results.  Whenever a backup completes the following message is displayed:

 

Database statistics:

--------------------------------------------------------------

1. model 1 MB 1 min (5751 MB/h)

2. msdb 13 MB 1 min (24440 MB/h)

3. master 3 MB 1 min (11587 MB/h)

4. TestDB 19626 MB 7 min (166637 MB/h)

Sum: 19644 MB 7 min (70720453 MB/h)

--------------------------------------------------------------

 

I'm fairly sure that the 'Sum:' isn't correct.  Does anyone elese see this?

 

Thanks,

 

John

------------------
Kudos gratefully accepted - How to assign...
Advisor
ChrisVH
Posts: 19
Registered: ‎08-30-2011
Message 2 of 3 (204 Views)

Re: MSSQL Integration Agent

Spoiler
 

Hello John,

 

what leads you to the assumption that "sum" is incorrect? The sum matches with sum of 1-4. The MB/s next to sum is incorrect or misleading but the same weird number is next to my summary, see screenshot attached. Backups are consistent, so I am not concerned.

 

If it's not that, please can you explain the issue in more detail?

 

Trusted Contributor
Johnc_3
Posts: 170
Registered: ‎07-16-2004
Message 3 of 3 (189 Views)

Re: MSSQL Integration Agent

Hi Chris,

 

That was precisely my query.  I'm not too worried with the MB/h figure since I know my backups (and restores) are working, I just wondered if anyone else was experiencing this.

 

John

------------------
Kudos gratefully accepted - How to assign...
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.