Hello experts,
I just noticed something sort of trivial, but curious nonetheless. I have a T-SQL backup statement using STATS = 10, but this was the output just now:
10 percent processed.
20 percent processed.
30 percent processed.
41 percent processed.
51 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
91 percent processed.
I've never noticed that apparently sometimes the count says, say, 51 instead of 50 - which seems like STATS = 11 lol.
Does anyone know why this happens?
Thanks for any info.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Since those are estimated calculations, it's probably just some rounding errors that they didn't bother eliminating. But, I don't know the internals, so maybe I'm wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2023 at 3:35 pm
Like Grant, I don't know. My guess is there is an event of sorts that notes we've gotten to 10%, but with load, the event might delay until 11% is the value. AFAIK, the goal of the backup system has always been to write out as fast as possible, to the detriment of things like reporting progress.
August 11, 2023 at 3:09 pm
OK, was just wondering. Thanks!
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 28, 2023 at 2:40 pm
A small inconvenience!
DBASupport
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply