MSSQL Integration Agent (89 Views)
Reply
Trusted Contributor
Johnc_3
Posts: 158
Registered: ‎07-16-2004
Message 1 of 3 (89 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...
Please use plain text.
Advisor
ChrisVH
Posts: 17
Registered: ‎08-30-2011
Message 2 of 3 (74 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?

 

Please use plain text.
Trusted Contributor
Johnc_3
Posts: 158
Registered: ‎07-16-2004
Message 3 of 3 (59 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...
Please use plain text.
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